As a member of a local chapter of the Audubon Society, you are involved with an outreach to promote ecotourism, which encourages travel to natural habitats while conserving the environment in the process. You will finalize a short flyer that identifies eight unique destinations for ecotourism, describing them in a Word table. Business sponsors have agreed to support the effort and will be distributing flyers, so you plan to include each business name and contact in the flyer. Start Word. Download and open the file named Grader has automatically added your last name to the beginning of the filename. Place the insertion point at the end of the document. Insert a 2×1 table. Adjust the width of the first column to inches. Apply a table style of List Table 2 – Accent 6 (row 2, column 7 under List Tables). Center the newly created table horizontally. Select the table and apply shading of Gray, Accent 3, Lighter 80 (row 2, column 7). Insert a row between the first and second rows of the first table (under the row). Type in the first cell on the new row. Type in the next cell. Type in the last cell on the row. Insert a column at the right of the last column in the table. Type 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 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 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. 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. 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. Include a caption that reads Table 1 below the first table. 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. Insert a row at the bottom of the first table. Type in the second cell on the last row. Choose Align Center Right alignment and bold the entry. Include a function in the third cell on the last row (below the column) that determines the average of the values in the column above. You do not need to select a number format. Include a function in the last cell on the last row (below the column) that determines the average of the values in the column above. You do not need to select a number format. Begin a mail merge process, selecting Letters as the mail merge type and selecting a recipient list from . Data is located in of the workbook. Note, Mac users select the text file 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: Sort the recipient list in ascending order by Business, and filter results to show only those from . Click in or select the first cell of the last table on the page (following ). 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. Select all of the merged document and copy the selection. Display , 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. Save and close Close all other open documents without saving. Submit as directed.