v
Curriculum Guide
ACTIVITY
NEW SKILLS
17 Facebook
Merge cells.
Insert a page footer.
18 Colleges
Format text directi on.
19 Concerts
Change column widths using AutoFit.
Format cells as currency.
20 Reality TV
Use text wrap within cells.
21 U.S. Presidents
Insert a clipart image in a spreadsheet.
22 Original 13 States
Insert comments for cells.
23 Pro Athletes
Format cells to currency using the dollar sign butt on.
24 Checkbook Register
Use the AutoSum butt on.
25 Sales Report
None. This acti vity provides additi onal reinforcement in using many of
the skills introduced in previous acti viti es.
26 Accounts Payable
Format cells to percents.
27 L.A. Lakers
Cut, copy, and paste data.
Use sets of parentheses in formulas.
28 Quarterback Stati sti cs Change cell shading.
29 M&M's Candy
Format cells as fracti ons.
30 NBA Standings
Insert and delete rows.
31 Verizon Wireless
Use the absolute cell reference in a formula.
32 Music Sales in U.S.
Format font colors.
33 Top 10 Candy Bars
Insert columns.
Move columns.
34 Expense Report
Insert a page break.
35 Billboard.com
Delete Columns.
Use <CTRL>+D to duplicate data in cells.
36 Original 13 States 2
Adjust page scaling.
Remove comments from cells.
37 Stocks
Format cells to negati ve numbers.
Change a cell's fi ll color.
For Evaluation Purposes Only