Question:
College Cost and Financial Support Worksheet
Problem: Attending college is an expensive proposition and your resources are limited. To plan for your four year college career, you have decided to organize your anticipated resources and costs in a worksheet. The data required to prepare your worksheet is shown in
The table below
1. Using the numbers in Table 1-9, create the worksheet shown in columns A through F in the above figure
2. Format the worksheet title as Calibri 24-point bold red.
3. Merge and center the worksheet title in cell Al across columns A through F.
4. Format the worksheet subtitles in cells A2 and All as Calibri 16-point bold green.
5. Format the ranges A3:F3 and A12:F12 with the Heading 2 cell style, the ranges A4:F9 and A13:F17 with the 20% - Accent1 cell" style, and the ranges Al 0:F10 and A18:F18 with the Total cell style.
6. Update the document properties, including the addition of at least one keyword to the properties, and save
the workbook using the file name, Final Lab Part 1 College Cost and Financial Support.
Instructions Part 2:
1. Insert an Exploded pie in 3-D chart in the range G3:K10 to show the contribution of each category of cost for the Freshman year. Chart the range A4:B9 and apply the Style 8 chart style to the chart.
3. Add the Pie chart title
4. Insert an Exploded pie in 3-D chart in the range G12:K18 to show the contribution of each category of financial support for the Freshman year.
5. Chart the range A13:B17 and apply the Style 8 chart style to the chart.
6. Add the Pie chart title shown .
7. Update the identification area with the exercise part number and save the workbook
Answers
Answer:
Worksheet
Problem: Attending college is an expensive proposition and your resources are limited. To plan for your four year college career, you have decided to organize your anticipated resources and costs in a worksheet. The data required to prepare your worksheet is shown in
The table below
1. Using the numbers in Table 1-9, create the worksheet shown in columns A through F in the above figure
2. Format the worksheet title as Calibri 24-point bold red.
3. Merge and center the worksheet title in cell Al across columns A through F.
4. Format the worksheet subtitles in cells A2 and All as Calibri 16-point bold green.
5. Format the ranges A3:F3 and A12:F12 with the Heading 2 cell style, the ranges A4:F9 and A13:F17 with the 20% - Accent1 cell" style, and the ranges Al 0:F10 and A18:F18 with the Total cell style.
6. Update the document properties, including the addition of at least one keyword to the properties, and save
the workbook using the file name, Final Lab Part 1 College Cost and Financial Suppor