Microsoft Office Tutorials and References
In Depth Information
EX 78
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
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 Accent 1 - 20% 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.
Figure 1–104
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. 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 using the ﬁ le name, Lab 1-3
Part 2 College Cost and Financial Support. Print the worksheet. Submit the assignment as requested by your
instructor.
Instructions Part 3: Open the workbook Lab 1-3 Part 2 College Cost and Financial Support. 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 and C13:E17. If necessary, reformat the
Search JabSto ::

Custom Search