Microsoft Office Tutorials and References
In Depth Information
Cases and Places
Cases and Places continued
3: Analyzing Historical Yearly Sales
Business
You are working part-time for Noble’s Mobile Services. Your manager has asked you to prepare a
worksheet to help her analyze historical yearly sales by type of product (Table 1– 11). Use the concepts
and techniques presented in this chapter to create the worksheet and an embedded 3-D Clustered
Column chart that includes proper numerical formatting, totaling, and formatting of the worksheet.
Table 1–11 Noble’s Mobile Services Historical Yearly Sales
2008
2009
2010
2011
Camera Phones
92598
10487
136791
176785
Headsets
9035
8909
4886
6512
Music Phones
57942
44923
54590
67696
Other Accessories
27604
38793
24483
33095
Satellite Radios
17161
19293
30763
44367
Standard Mobile Phones
8549
9264
7600
6048
Wireless PDAs
57963
68059
103025
87367
Search JabSto ::




Custom Search