Step

Instructions

Points Possible

1

Start Word. Download and open the file named Exp22_Word_Ch03_Cumulative_Tourism.docx . Grader has automatically added your last name to the beginning of the filename.

0

2

Place the insertion point at the end of the document. Insert a 2×1 table. Adjust the width of the first column to 2 inches. Apply a table style of List Table 2 – Accent 6 (row 2, column 7 under List Tables).

8

3

Center the newly created table horizontally. Select the table and apply shading of Gray, Accent 3, Lighter 80 % (row 2, column 7).

7

4

Insert a row between the first and second rows of the first table (under the Eco-Friendly World Destinations row). Type Destination in the first cell on the new row. Type Description in the next cell. Type C2 Rating in the last cell on the row.

7

5

Insert a column at the right of the last column in the table. Type Approximate Visitors/Year in the last cell on the second row. Type data in the final two columns of the table as follows: C2 Rating Approximate Visitors/Year 8 250,300 7 524,000 9 2,000,700 6 34,900 9 190,000 10 3,500 7 145,000 8 348,000

7

6

Select the first table. Select a border style of Double solid lines , ½ pt, Accent 3 (row 3, column 4). Apply the selection to outside borders. AutoFit contents of the table

5

7

Select the first row of the first table and merge cells. Center text in the first row. Apply shading of Light Gray, Background 2, Darker 50% (row 4, column 3). Change font color of text in the first row to White, Background 1 . Bold text in the selected row and change the font size to 14.

11

8

Select rows 2 through the end of the table and apply shading of Light Gray, Background 2 (row 1, column 3). Use Border Painter to copy the double-line format from an outside border and apply it to each vertical gridline within the table.

6

9

Apply Align Center alignment to all text in the second row so that contents are both horizontally and vertically centered. Apply Align Center alignment to all text in the first and third columns. Select all numbers in the last column and apply Align Center Right alignment.

6

10

Include a caption that reads Table 1 : Data provided by the National Conservation Fund below the first table.

6

11

Select rows 3 through the end of the first table. Sort the rows in ascending order by Column 1. All destinations should be shown in alphabetical order.

6

12

Insert a row at the bottom of the first table. Type Average in the second cell on the last row. Choose Align Center Right alignment and bold the entry.

5

13

Include a function in the third cell on the last row (below the C2 Rating column) that determines the average of the values in the column above. You do not need to select a number format.

6

14

Include a function in the last cell on the last row (below the Approximate Visitors/Year column) that determines the average of the values in the column above. You do not need to select a number format.

6

15

Begin a mail merge process, selecting Letters as the mail merge type and selecting a recipient list from Members.xlsx. Data is located in Sheet1$ of the workbook. Note, Mac users select the text file Members.csv as a recipient list, responding affirmatively if asked to confirm any file conversion activities. Edit the recipient list to include a business you left off, as follows: Sloan Outfitters 171 Wood Avenue Anderson SC 34408 Serena Blake [email protected]

2

16

Sort the recipient list in ascending order by Business, and filter results to show only those from SC.

3

17

Click in or select the first cell of the last table on the page (following Thanks for Supporting Us!). Insert the Business merge field. In the second cell of the table, insert the Contact merge field. Preview results and finish the merge, editing individual documents and merging all. The merged document should contain six pages.

2

18

Select all of the merged document and copy the selection. Display Exp22_Word_Ch03_Cumulative_Tourism, move the insertion point to the end of the document, and insert a page break. Click the new blank page and paste all copied text, resulting in an 8-page document.

7

19

Save and close Exp22_Word_Ch03_Cumulative_Tourism.docx. Close all other open documents without saving. Submit Exp22_Word_Ch03_Cumulative_Tourism.docx as directed.

0

Total Points

100