create&aspreadsheet&forthe&...
TRANSCRIPT
Create a Spreadsheet for the Twelve Days of Christmas
1. Open new Excel workbook 2. On the Layout Tab – change the orientation to Landscape. 3. In cells A2 through A13 type in the twelve days of Christmas (i.e. Partridge
in a Pear Tree, Turtle Doves, French Hens, etc.) 4. In cell B1 type “Day 1”, using fill handle, drag through to M1 5. In cell B2 type the number “1”, and using fill handle, drag through to M2. 6. In cell C3, type the number “2”, and using fill handle, drag through to M3. 7. Repeat for each item for each day (D4 = 3, E5 =4, etc.) 8. Make columns O and P as $ 9. Cell N1 type “Total Items”, cell O1, type “Item Costs”, cell P1 “Total costs” 10. In cells O2 through O13 assign a dollar value to each item (i.e. for a
Partridge in a pear tree = $200, each Turtle Dove = $6, each French Hen $7.50, etc).
11. In cells N2 through N13, using auto sum, students calculate total number of each item for the 12 days.
12. In cells P2 through P13, using multiplication, students calculate total $ spent on each item.
13. In cell P14, using auto sum, students calculate total $ spent over the 12 days. 14. Insert a Clustered Column Chart
a. Select Cells A1 through A13 AND Cells P1 through P13 b. Then choose Insert Tab – Chart – Clustered Column c. Resize the Width of the Chart to 4 Inches Wide. d. Apply a Preset Layout of your choice to the Chart e. Move the Chart so it starts in Cell P20 f. Insert a Caption that goes below your chart that says, “Coolest Chart
Ever!” 15. Insert a Picture of your Favorite of the 12 Days 16. Resize the Width of the Photo to 5 inches wide. 17. Add a Moderate Frame, Black around the Picture, and Rotate the Photo
Clockwise, 4 Degrees. 18. Add a New Row Before Row 1. Select Cells A1 through P1 and Merge &
Center them. Then Type “The Twelve Days of Christmas – Bah Humbug!” 19. Format the text as 18 Point, Bold, Red 20. Insert a New Row After Row 1. Select Cells B1 through P1 and Merge &
Center them. 21. Format your name as Bold 22. Then Type “Your Name, Period ____?”
23. Choose File – Print, and mark the box to Fit To Page -‐ Turn It In!
Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Day 11 Day 12 Total items Item Costs Total CostsPartridge Pear 1 1 1 1 1 1 1 1 1 1 1 1 12 45.00$ 540.00$ 14ve 2 2 2 2 2 2 2 2 2 2 2 22 22.00$ 484.00$ 2 rf ds f 3 3 3 3 3 3 3 3 3 3 30 15.00$ 450.00$ fds fd 4 4 4 4 4 4 4 4 4 36 7.00$ 252.00$ fdsa ads 5 5 5 5 5 5 5 5 40 5.45$ 218.00$ gdsa gfdsa g 6 6 6 6 6 6 6 42 87.00$ 3,654.00$ dsfa gdv 7 7 7 7 7 7 42 97.00$ 4,074.00$ dfs g 8 8 8 8 8 40 66.00$ 2,640.00$ gdsa fds 9 9 9 9 36 33.00$ 1,188.00$ dsa gdsa 10 10 10 30 22.00$ 660.00$ gdsa dsa 11 11 22 11.00$ 242.00$ bfdah gter 12 12 9.00$ 108.00$
14,510.00$
The Twelve Days of Christmas -‐ Bah Humbug!Your Name, period xxx
$-‐ $500.00
$1,000.00 $1,500.00 $2,000.00 $2,500.00 $3,000.00 $3,500.00 $4,000.00 $4,500.00
Total Costs
Total Costs