Edge Ski Team Dante Pearson is the program director for the nonprofit Edge Ski Team ski club at Haystack Mountain in Vermont. The team has an enrolled membership of more than 60 families with approximately 90 children ages 7–18 participating in multiple levels of ski racing. The team supports four levels of competitive skiing—Beginners (ages 7–9); Level 1 (ages 10–12); Level 2 (ages 13–16); and Advanced (ages 17–20). The program is controlled by a board of directors and is funded through event fees, club dues, races, and fundraisers such as the annual Ski, Board, and Skate Swap. At the end of each season, Dante writes a short report for the board of directors summarizing the team’s racing season. He created the text of the report and wants you to add a chart from an Excel file that shows the total number of skiers at each level, and a table listing the number of skiers who competed at each level in each race. Complete the following steps:
1. Open the Word document Report, which is located in the Integration Case1 folder included with your Data Files, and then save it as Board Report in the location where you are saving your files.
2. Open the Excel workbook Team, which is located in the Integration Case1 folder, and then save it as Team Info in the location where you are saving your files.
3. Copy the chart on the Demographics Chart worksheet. Switch back to the Board Report document, delete the text “” between the two full paragraphs in the body of the report, and then embed the pie chart in that paragraph using the destination theme. 4. Modify the embedded chart so that the legend doesn’t show, and change the data labels so they are formatted as callouts. Keep the default chart style.
5. Resize the chart so that it is 3.5 inches high and 6 inches wide, and then use the Center button in the Paragraph group on the HOME tab to center the chart horizontally.
6. Switch to the Team Info workbook, and then copy the range A4:F9 in the Race Qualifiers worksheet. Switch back to the Board Report document, delete the text “”, and then link the copied data in that paragraph using the destination styles.
7. Switch back to the Race Qualifiers worksheet in the Team Info workbook, and then add the number of Advanced skiers for each race as follows, starting in cell E5: 10, 7, 7, 10, 5. Save your changes, and then close Excel.
8. Switch back to the Board Report document, and then update the link.
9. In the Board Report document, apply the Grid Table 4 – Accent 5 table style to the table. 10. In the last paragraph in the document, type your name. Save the document, and then close Word.
