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 fi 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.
Cases and Places
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
2005
2006
2007
2008
Standard Mobile Phones
87598
99087
129791
188785
Camera Phones
71035
75909
96886
100512
Music Phones
65942
24923
34590
15696
Wireless PDAs
67604
58793
44483
35095
Satellite Radios
15161
27293
34763
43367
Headsets
9549
6264
2600
4048
Other Accessories
47963
108059
100025
62367
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
300
300
150
450
Copies and Supplies
390
725
325
640
Travel
450
755
275
850
Refreshments
105
85
215
155
Speaker Fees
200
200
0
500
Miscellaneous
125
110
75
215
 
 
Search JabSto ::




Custom Search