2. Use <CTRL>+D to
United States and publishes the results in Billboard magazine. The two
albums). The Hot 100 is the music industry's standard singles popularity chart,
and the rankings are based on both sales and radio play. The Billboard 200
ranks the 200 highest-selling music albums and the rankings are based solely
on sales. The number one album on the Billboard 200 in the November 13,
2010 issue of Billboard magazine was "Speak Now" by Taylor Swift .
The following acti vity illustrates how spreadsheets can be used to make a list
of the current top selling albums by genre.
2. Type the data as shown.
3. Delete the empty column D.
4. Format the width of column A to 15.0 and left align.
6. Format column B as dates showing the day and month spelled out.
9. Bold rows 5, 14, 23, 32, and 41.
13. Save the spreadsheet as BILLBOARD.COM.
14. Analyze the changes made to the data in the spreadsheet.
15. Set the Print Area to include all cells containing data in the spreadsheet.
16. Print Preview and adjust the Page Setup so that the spreadsheet fi ts on one