Microsoft Office Tutorials and References
In Depth Information
Cases and Places
and C13:E17. If necessary, reformat the tables, as described in Part 1. The worksheet should appear
as shown in Figure 1–104, except that some of the totals will be off by 0.01 due to rounding errors.
Save the worksheet using the ﬁ le name, Lab 1-3 Part 3 College Cost and Financial Support. Print the
worksheet. Press CTRL + ACCENT MARK ( `) to display the formulas. Print the formulas version. Submit
the assignment as requested by your instructor. Close the workbook without saving changes.
Apply your creative thinking and problem solving skills to design and implement a solution.
• E ASIER •• M ORE D IFFICULT
• 1: Design and Create a Workbook to Analyze Yearly Sales
You are working as a summer intern for Hit-the-Road Mobile Services. Your manager has asked you
to prepare a worksheet to help her analyze historical yearly sales by type of product (Table 1–10). Use
the concepts and techniques presented in this chapter to create the worksheet and an embedded 3-D
Clustered Column chart.
Table 1–10 Hit-the-Road Mobile Services Sales
Standard Mobile Phones
• 2: Design and Create a Worksheet and Chart to Analyze a Budget
To estimate the funds needed by your school’s Environmental Club to make it through the upcoming
year, you decide to create a budget for the club itemizing the expected quarterly expenses. The
anticipated expenses are listed in Table 1–11. Use the concepts and techniques presented in this
chapter to create the worksheet and an embedded 3-D Column chart using an appropriate chart style
that compares the quarterly cost of each expense. Use the AutoCalculate area to determine the average
amount spent per quarter on each expense. Manually insert the averages with appropriate titles in an
empty area on the worksheet.
Table 1–11 Quarterly Environmental Club Budget
Jan – Mar
April – June
July – Sept
Oct – Dec
Meeting Room Rent
Copies and Supplies