Microsoft Office Tutorials and References
In Depth Information
In the Lab
In the Lab continued
Figure 1– 80
Instructions: Perform the following tasks.
1. Create the worksheet shown in Figure 1– 80 using the data in Table 1– 8.
2. Use the SUM function to determine total revenue for the three sales channels, the totals for
each product, and the company total. Add column and row headings for the totals row and totals
column, as appropriate.
Table 1– 8 Play ‘em Again Semiannual Revenue
Mail
Store
Web
Accessories
378512.09
20380.80
24257.51
Cell Phones
124118.00
366216.77
32333.20
CDs
47055.42
311570.23
427261.96
Controllers
409368.32
118871.41
36140.54
DSs
281443.97
472259.61
431317.79
DVDs
311004.73
109971.82
21209.46
Games
413265.32
112511.16
151722.44
iPods
149327.59
358232.57
37465.90
Other
254398.60
126224.85
298479.20
PlayStation 3s
253917.77
173103.58
293961.01
PSPs
469556.54
136579.71
163465.19
Wiis
495690.83
10169.70
130150.03
XBoxes
456773.97
169627.11
145925.85
3. Format the worksheet title with the Title cell style and center it across columns A through E. Use
the Font group on the Ribbon to format the worksheet subtitle to 16-point Cambria red, bold font.
Center the title across columns A through E.
4. Format the range B3:E3 with the Heading 3 cell style and center the text in the cells. Format the
range A4:E16 with the 20% - Accent 4 cell style, and the range B9:E9 with the Total cell style.
Format cells B4:E4 and B17:E17 with the Accounting Number Format and cells B5:E16 with the
Comma Style numeric format.
Search JabSto ::




Custom Search