1. Create a new workbook in Excel. Save the file asCIS114DE_L2Shoppers_MEID.xlsx. In the file name, be sure to replace "MEID" with your actual student MEID.
2. Type the following labels in cellsA4:E4:
   • Item Name
   • Category
   • # of Units
   • Price per Unit
   • Total
3. Select cellB5. The four categories areGrocery,Meats,Produce, andRefrig/Frozen. Type these labels in cellsB6:B19.Mix them up so that they do not follow a pattern.
4. Select cellA5and typeItem 1.Fill item numbers to reach row19. The last entry should read as Item 15.
5. Enter the number of units purchased and a price per unit for each item. Format the values in columnDasCurrencywith two decimal places.
6. Select cell E5, multiply the number of units by price per unit. Copy the formula to cellsE6:E19.
7. Enter a function to calculate a total in cellE20.
8. TypeSales by Categoryin cellB22.
9. In cellsB23:B26, copy or type the four category names listed in Project Direction #3.
10. Select cellC23and use theSUMIF Functionto calculate the total for the category in cellB23. Use relative and absolute references so that you can copy the formula to cellsC24:C26. Format the results asCurrencywith two decimal places.
11. Check results of theSUMIFformula in cellC23before you copy it by selecting the appropriate cells in columnEfor the category and viewing theAutoCalculateresults in theStatusbar.
12. Enter a function to calculate a total in cellC27. (This total should sum up the values in cells C23:C26. If you created your SUMIF formulas correctly, the total in C27 should match the total in E20.)
13. Type a fictitious shopper's name in cellA1followed by a comma and typeOrder #1.
14. Insert theTODAYFunction in cellA2.
15. Name the sheet Shoppers and set a tab color
16. Complete formatting on the sheet to relate and highlight sections of the data. Change the theme, set alignment, apply cell styles, build borders, and fill. Adjust column width accordingly.
17. Insert a footer that displays the file name in the right section.
18. Set document properties to show your name as the author and a title of your choice.
19. Save the file.