The first picture shows how it should look. Please use excel functions to calculate
Exercise E2 Restaurant Sales Data Monroe Location 1st 2nd 3rd 4th Category Quarter Quarter Quarter Quarter Dine-In 54000 510001 48000 43000 Pick-up 29000 310001 30000 30000 Delivery 35000 45000 55000 65000 Ruston Location 4th 1 st 2nd 3rd Category Quarter Quarter Quarter Quarter Dine-In 240001 210001 19000 17000 Pick-up 38000 37000 37000 37000 Delivery 36000 450001 57000 71000 Shreveport Location 2nd Category 1st Quarter Quarter 3rd Quarter 4th Quarter Dine-In 47000 45000 40000 33000 Pick-up 51000 52000 51000 52000 Delivery 33000 37000 46000 53000 Instructions Download the file "Exercise E2 Data.docx" from Moodle and follow the instructions below. Everything must be done using Excel functions. Not using Excel functions will result in a zero for that part of the assignment. Open the data file. A. Author Information 1. Open a blank worksheet using Excel 2. Name the worksheet Author 3. Enter your name, "Exercise E2", "CIS 310"and date. B. Data 1. In Word, open the data document file 2. In Excel, create more worksheets named as follows: a. Monroe b. Ruston c. Shreveport d. Summary 3. Copy the data from the three locations, cach onto its own worksheet. Make sure that you copy to the same location on each worksheet 4. Format the first location worksheet to some your corporate colors of your choosing C. Monroe 1. Follow the instructor's directions on how to fill in sales totals. 2. You must have a "Monroe" title row and use a bigger font size 3. You must use either =SUMO or another formula 4. You must NOT use a formula inside a SUMO a. For example, do NOT do this: =SUM(E1-E2-E3) -- The inside does the adding: SUM changes nothing. 5. Create sales totals for each quarter 6. Create sales totals for each category 7. Calculate the total of all total sales (grand total) 8. Format all numbers with a. S signs b. Whole dollars (no digits to the right of the C. Monroe 1. Follow the instructor's directions on how to fill in sales totals. 2. You must have a "Monroe" title row and use a bigger font size 3. You must use either =SUM) or another formula 4. You must NOT use a formula inside a SUMO a. For example, do NOT do this: =SUM(E1 E2 E3) The inside does the adding: SUM changes nothing. 5. Create sales totals for each quarter 6. Create sales totals for each category 7. Calculate the total of all total sales (grand total) 8. Format all numbers with a. S signs b. Whole dollars (no digits to the right of the decimal place) 9. Make sure that all the data is fully visible (i.c.. NO #'s!) 10. Center the Monroe title horizontally across all the rows of the table D. Ruston 1. Using your experience with the Monroe worksheet, add a title row and calculate the sales for each quarter, category, and the total of the totals (grand total) 2. Follow the instructor's directions on how to copy the format of the Monroe worksheet. This means all the following formatting must be the same in the Ruston worksheet as you have been given in the Monroe worksheet. Including a. Colors (both fill color and font color) b. S signs c. Font & font size d. Bold or not bold 3. Make sure that all the data is fully visible (.e.. NO #'s!) E. Shreveport 1. Using your previous experience with the Monroe 6. Create sales totals for each category 7. Calculate the total of all total sales (grand total) 8. Format all numbers with a. S signs 1. Whole dollars (no digits to the right of the decimal place) 9. Make sure that all the data is fully visible (i.e., NO #'s!) 10. Center the Monroe title horizontally across all the rows of the table D. Ruston 1. Using your experience with the Monroe worksheet, add a title row and calculate the sales for cach quarter, category, and the total of the totals (grand total) 2. Follow the instructor's directions on how to copy the format of the Monroe worksheet. This means all the following formatting must be the same in the Ruston worksheet as you have been given in the Monroe worksheet. Including a. Colors (both fill color and font color) b. S signs c. Font & font size d. Bold or not bold 3. Make sure that all the data is fully visible (i.e.. NO #'s!) E. Shreveport 1. Using your previous experience with the Monroe and Ruston worksheets, add a title row, and calculate the sales and format the worksheet. 2. Make sure that all the data is fully visible (i.e. NO #'s!) F. Summary 1. Using your previous experience, format the worksheet 2. Add a title row "Totals by Category and by Quarter"; make it a bigger font size. 3. Follow the instructor's directions on how to add up the sales from cach restaurant for all the quarters and categories 4. Using your previous experience calculate the 8. Format all numbers with a. S signs b. Whole dollars (no digits to the right of the decimal place) 9. Make sure that all the data is fully visible (i.e.. NO #'s!) 10. Center the Monroe title horizontally across all the rows of the table D. Ruston 1. Using your experience with the Monroe worksheet, add a title row and calculate the sales for each quarter, category, and the total of the totals (grand total) 2. Follow the instructor's directions on how to copy the format of the Monroe worksheet. This means all the following formatting must be the same in the Ruston worksheet as you have been given in the Monroe worksheet. Including a. Colors (both fill color and font color) b. S signs c. Font & font size d. Bold or not bold 3. Make sure that all the data is fully visible (i.e.. NO #s!) E. Shreveport 1. Using your previous experience with the Monroe and Ruston worksheets, add a title row, and calculate the sales and format the worksheet. 2. Make sure that all the data is fully visible (i... NO #'s!) F. Summary 1. Using your previous experience, format the worksheet. 2. Add a title row "Totals by Category and by Quarter": make it a bigger font size. 3. Follow the instructor's directions on how to add up the sales from each restaurant for all the quarters and categories
