Скачать или смотреть Exp22_Word_Ch03_Cumulative - Tourism | Exp22 Word Ch03 Cumulative - Tourism | Ch03Cumulative Tourism

Contact us:



Whatsapp: +923025441145

Direct Whatsapp Link: https://tinyurl.com/3zfyhs35

Email address: [email protected]



#Exp22_Word_Ch03_Cumulative - Tourism |# Exp22 Word Ch03 Cumulative - Tourism | #Ch03Cumulative Tourism##Exp22_Word_Ch03_Cumulative - Tourism |# Exp22 Word Ch03 Cumulative - Tourism | #Ch03Cumulative Tourism#


Project Description:
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.

Steps to Perform:


Place the insertion point at the end of the document. Insert a 2x1 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).
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 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.
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
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: Data provided by the National Conservation Fund 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 Average 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 C2 Rating 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 Approximate Visitors/Year 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 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: