Microsoft Office Tutorials and References
In Depth Information
In the Lab
In the Lab continued
Instructions Part 1: Using the numbers in Table 1– 9, create the worksheet shown in columns A through F
in Figure 1– 81. Format the worksheet title as Calibri 24-point bold purple. Merge and center the
worksheet title in cell A1 across columns A through F. Format the worksheet subtitles in cells A2 and
A11 as Calibri 16-point bold red. Format the ranges A3:F3 and A12:F12 with the Heading 2 cell style
and center the text in the cells. Format the ranges A4:F9 and A13:F19 with the 20% - Accent 2 cell style,
and the ranges A10:F10 and A20:F20 with the Total cell style.
Change the name of the sheet tab and apply the Purple color from the Standard Colors area
to the sheet tab. Update the document properties, including the addition of at least one keyword to the
properties, and save the workbook using the i le name, Lab 1-3 Part 1 College Resources and Expenses.
Print the worksheet. Submit the assignment as specii ed by your instructor.
Figure 1– 81
After reviewing the numbers, you realize you need to increase manually each of the
Sophomore-year expenses in column C by \$400, except for the Activities Fee. Change the Sophomore-
year expenses to rel ect this change. Manually change the Parents resources for the Sophomore year
by the amount required to cover the increase in costs. The totals in cells F10 and F20 should equal
\$91,642.87. Print the worksheet. Close the workbook without saving changes.
Instructions Part 2: Open the workbook Lab 1-3 Part 1 College Resources and Expenses and then save
the workbook using the i le name, Lab 1-3 Part 2 College Resources and Expenses. Insert an Exploded
pie in 3-D chart in the range G3:K10 to show the contribution of each category of resources for the
Freshman year. Chart the range A4:B9 and apply the Style 26 chart style to the chart. Add the Pie chart
title as shown in cell G2 in Figure 1– 81. Insert an Exploded pie in 3-D chart in the range G12:K20 to
show the contribution of each category of expenses for the Freshman year. Chart the range A13:B19
and apply the Style 26 chart style to the chart. Add the Pie chart title shown in cell G11 in Figure 1– 81.
Save the workbook. Print the worksheet in landscape orientation. Submit the assignment as specii ed by