Randolph Middle School

Technology Literacy


1. Create a NEW document in Excel.
2. Include your name in cell A1.
3. In the second row second column create the bold header titled Food.
4. Create entries under food that includes 10 foods you will serve at your party.
5. The next column should have a header of Quantity and list the amount of each type of food you will purchase.
6. The next column should have a header of Units and list the packaging of each type of food you will purchase (ie packs or each).
7.The next column should have a header of Cost Per and list the cost of 1 unit of each type of food you will purchase.
8. The next column should have a header of Extended Cost. Create a formula that will list the total amount you will pay for each type of food you will purchase.
9. At the bottom of that row create a formula that will calculate the grand total you will spend on the entire party.
10. Label the number from step 6 Grand Total.