making it fi ve consecuti ve years that music sales had exceeded $1 billion. There's a lot of competi ti on among the online music stores, and Napster, Zune Marketplace, Amazon MP3, Nokia Music Store, Tune Tribe, and the other online music stores have very steep competi ti on from iTunes. Apple's fi rst quarter 2010 report showed that iTunes had cornered 70% of the digital download market, leaving its many competi tors behind in the digital dust. The following acti vity illustrates how spreadsheets can be used to list 2009 and 2008 album sales by genre in the United States and calculate the percentage of change in sales. 2. Type the data as shown. 3. Bold cell A2 and change the font size to 14 point. 4. Bold and underline row 4. 6. Format the width of column A to 30.0 and left align. 9. Format cells B5 C18 as currency displaying 0 decimal places and the $ symbol. 13. Change the font color of cells D5 D16 to red. 14. Enter formulas to calculate the TOTAL for columns B and C. 15. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy. 16. Carefully proofread your work for accuracy. |