Model Rocket Parts Close Button

In this activity you will work on a spreadsheet that tracks how much money was made selling rocket parts.

  1. Click the Model Rockets icon to open the file.



  2. Look at the cells, there are numbers missing from some of the daily sales. Enter the following information into the empty cells:
    • cell C3 - 20
    • cell D5 - 32
    • cell E6 - 75
    • cell F4 - 41
    • cell G6 - 20
    • cell H7 - 68


  3. Format the cells with numbers for currency.


  4. How much money did the store make on Wednesday?


  5. What is the cell address for all the money made for that week?


  6. What day had the biggest amount of sales?


  7. What day had the least amount of sales?


  8. How much money was made on nose cones during the week?


    9. Use the column graph to answer the following questions.

  9. What day were the most engine mounts sold?


  10. What two items totaled nearly the same amount on Thursday?


  11. What item totaled the least amount on Monday?


  12. On Tuesday, which item sold exactly $40?


  13. If it's o.k. with your teacher, save and print your spreadsheet.