75
iNPuT
DATA
32
Music Sales in U.S.
17. Save the spreadsheet as MUSIC SALES IN U.S.
18. Analyze the changes made to the data in the spreadsheet.
19. Set the Print Area to include all cells containing data in the spreadsheet.
20. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one
page.
21. Print a copy of the spreadsheet if required by your instructor.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A
B
C
D
Activity 32 Student Name
U.S. ALBUM SALES BY GENRE
GENRE
2009 SALES
2008 SALES
% OF CHANGE
Alternative
68,195,000
80,919,000
Christian/Gospel
27,822,000
29,793,000
Classical
12,140,000
13,323,000
Country
46,130,000
47,657,000
Jazz
11,779,000
11,791,000
Latin
16,496,000
25,125,000
Metal
38,734,000
50,476,000
New Age
2,354,000
2,943,000
R&B
69,889,000
77,014,000
Rap
26,441,000
33,410,000
Rock
124,164,000
139,666,000
Soundtrack
18,980,000
20,847,000
TOTAL
ACTIVITY
For Evaluation Purposes Only