1. Open the file, DataTech First Quarter Sales.docx. Save the file as My DataTech First Quarter Sales.docx to your personal folder in a new folder titled My Exam Folder, which you will need to create. Complete the following steps using any technique you wish. 2. Add the following text to the end of the third paragraph located just above the list. We are proud of their accomplishments in this quarter and are truly excited about what we can accomplish this year. 3. Move the first paragraph and place it after the third paragraph just above the list. 4. Format the title at the top with Heading 1 style, and then change the font to Calibri, Bold, and Automatic font color. Add an After spacing of 12pt to the title. Hint: Use the Paragraph dialog box. 5. Include the following information as the last item in the sales information list. Press the Tab key as indicated. South [Tab] Mason [Tab] Raleigh [Tab] Furniture [Tab] $12,651.03

2 6. Modify the entire list as follows: Place a Bar Tab at 1" on the ruler to insert a line between Region and Salesperson. Place a Decimal Tab at 6" on the ruler and remove the Left Tab at 5" to align the figures. Move the Left Tab from 2.5" to 2.75". Move the Left Tab from 3.5" to 4". Sort the list by Region then Salesperson then Product, all in Ascending order. 7. Add the following heading above the list. Our Team's Accomplishments 8. Format the heading with Heading 2 style, and then change the font to Calibri, Bold, and Automatic font color. Add an After spacing of 6pt. 9. Add a page break after the list. 10. Type the following heading and format it with the same formatting applied to the heading above the list. First Quarter Sales 11. Copy the list below the new heading and then convert it to a table. 12. Modify the table as follows: Add the Grid Table 4 - Accent 2 table style. Sort the table by Total in descending order, then by Salesperson and then by Product in ascending order. Add a row at the bottom and select the Total Row checkbox on the Table Tools Design ribbon. Add a formula in the last cell in this row (in the Total column) that determines the total sales for the first quarter. 13. Add a page break after the table. 14. Type the following heading and format it with the same formatting applied to the heading above the table. Sales by Product 15. Copy the table below the new heading and then delete the first three columns, Region, Salesperson, and City.

3 16. Modify the table as follows: Sort the table by Product in ascending order, then Total in descending order. Hint: Do not select the row at the end containing the formula. Add two rows after the last Computers entry. In the first blank row, type Total Computers in the Product column and add a formula to sum the totals for the Computers sales in the Totals column. Repeat for Furniture and for Software. Bold the Totals for Computers, Furniture, and Software. 17. Press Enter to add a blank line below the table, and then insert a 3-D Pie chart with the following information.

Hint: Expand the Sales column if the numbers display as #####. 18. Modify the chart as follows: Change the heading to Sales by Product, change the font size to 12pt and the font color to Automatic. Change the font size of the legend to 12pt. Decrease the size of the chart so that it fits on the same page as the table and is approximately the same width as the table. 19. Select the table (and its heading) and the chart and format as 2 columns, and add a column break below the table. 20. Below the chart, add the following online picture