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–104. Format the worksheet title as Calibri 24-point bold red. 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 green. Format the ranges A3:F3 and A12:F12 with the Heading 2 cell
style, the ranges A4:F9 and A13:F17 with the 20% - Accent cell style, and the ranges A10:F10 and
A18:F18 with the Total cell style.
Update the document properties, including the addition of at least one keyword to the properties,
and save the workbook using the ﬁ le name, Lab 1-3 Part 1 College Cost and Financial Support. Print
the worksheet. Submit the assignment as requested by your instructor.
After reviewing the numbers, you realize you need to increase manually each of the Junior-year
expenses in column D by $600. Change the Junior-year expenses to reﬂ ect this change. Manually change the
ﬁ nancial aid for the Junior year by the amount required to cover the increase in costs. The totals in cells F10
and F18 should equal $87,373.90. Print the worksheet. Close the workbook without saving changes.
Instructions Part 2: Open the workbook Lab 1-3 Part 1 College Cost and Financial Support and then save
the workbook using the ﬁ le name, Lab 1-3 Part 2 College Cost and Financial Support. 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. Add the Pie chart title as shown in cell G2
in Figure 1–104. Insert an Exploded pie in 3-D chart in the range G12:K18 to show the contribution of each
category of ﬁ nancial support for the Freshman year. Chart the range A13:B17 and apply the Style 8 chart style
to the chart. Add the Pie chart title shown in cell G11 in Figure 1–104. Update the identiﬁ cation area with the
exercise part number and save the workbook. Print the worksheet. Submit the assignment as requested by your
Instructions Part 3: Open the workbook Lab 1-3 Part 2 College Cost and Financial Support. Do not
save the workbook in this part. A close inspection of Table 1–9 shows that both cost and ﬁ nancial support
ﬁ gures increase 6% each year. Use Excel Help to learn how to enter the data for the last three years
using a formula and the Copy and Paste buttons on the Home tab on the Ribbon. For example, the
formula to enter in cell C4 is =B4*1.06. Enter formulas to replace all the numbers in the range C4:E9