$1 Million Dollar Spreadsheet

Congratulations! You've won the lottery! Spend the money on whatever you want (Rated G). Follow the directions to create a spreadsheet to list the items you want. You have a $1,000,000 budget that you MUST spend. You must buy at least 15 items.

Directions:

1. Use Open Office Calc to create the spreadsheet
2. Change the orientation of your page to landscape (Format > Page, Sheet tab)
3. Click in cell A1 and type "My Million Dollar Shopping Spree"
4. Change the width of the column to fit all of the text
5. Click and drag from cell A1 to cell G1 and merge the cells. Center the title. Change the font size to 16 and bold.
6. Immediately save as "Million Dollar Spreadsheet" in your spreadsheet folder.
7. Click on the column header for column B to highlight the entire column.
8. Choose Format Cells. Click on the Numbers tab. Choose Currency under category.
9. In the Format section, choose the 2nd in the list. Your column will now be formatted as currency automatically.
10. Do the same thing for Column C.
11. In cell A4, type the word Item
12. In cell B4, type the word Price
13. In cell C4, type the word Remaining Amount
14. Click on Row 4 and bold the column headings.
15. Go to cell A26 and type TOTAL
16. In A27 type Budget
17. In A28 type Amount left
18. In A29 type Average cost
19. In B26 type the formula that calculates the sum of cells B5 through B24
20. In B27 type 1000000
21. In B28 type the formula that subtracts cell B27 from B26.
22. In B29 type the formula to calculate the average of cells B5 through B24
23. In C5 type =sum(1000000-b5)
24. In C6 type =sum(c5-b6)
25. Press the ENTER key
26. With your mouse, right click on C6 on click copy
27. Highlight column C, rows 7 through 24. Right click on the highlighted cells and click Paste.
28. Fill in column A, rows 5 through 24 with items you want to buy. Put the price of the item in the column next to the item. Make sure you spend exactly $1,000,000
29. Go to Edit > Headers and Footers to create a header. Left header: Your Name, Center header: ________'s Million Dollar Shopping Spree; Right header: Date
30. Save as Million Dollar Spreadsheet in your MP3 folder.

This project is worth 30 points. You will receive 2 points off for each step not completed.