GETTING STARTED - IWA Computer Class



45720086868000Illustrated Excel 2016 | Module 1: SAM Project 1aRestaurant Profit Analysisgetting started with excel 2016GETTING STARTEDOpen the file IL_EX16_1a_FirstLastName_1.xlsx, available for download from the SAM website.Save the file as IL_EX16_1a_FirstLastName_2.xlsx by changing the “1” to a “2”.If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.With the file IL_EX16_1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.PROJECT STEPSKatherine owns two fast food restaurants, and she plans to invest in the one that is more profitable. Her Excel worksheet shows detailed financial information for each location. Select the Profit Analysis worksheet. Add a header to the worksheet by entering the text Restaurant Comparison into the center section of the header.Click on any cell and switch back to Normal view.Enter the text Restaurant Comparison in cell A1.Enter the text Profit Analysis in cell A2. In cell A3, change the text “2015” to 2018 so that the cell contains the text “Pizza Palace 2018-2020 Profit”.In cell D10, enter the value 38900.Use the Fill Handle to fill the range E6:E10 with the formula in cell E5.In cell B11, enter a formula that uses the SUM function to total the range B5:B10. Use the Fill Handle to fill the range C11:E11 with the formula you created in cell B11.In cell A13, insert the text 2018-2020 Profit after the word “Shack” so that the cell contains the text “Burger Shack 2018-2020 Profit”.Enter the information shown in Table 1 below into the range B20:D20.Table 1: Values for the Range B20:D20CellB20C20D20Value252002641025780Katherine wants to determine the total profit from each type of burger sold between 2018 and 2020. In cell E15, enter a formula that uses the SUM function to total the values in the range B15:D15.Use the Fill Handle to fill the range E16:E20 with the formula in cell E15. In cell B21, enter a formula that uses the SUM function to total the range B15:B20. Use the Fill Handle to fill the range C21:E21 with the formula in cell B21.Katherine wants to know the difference in total profits between her two restaurants.In cell B25, enter a formula that subtracts the value in cell B21 from the value in cell B11. Use the Fill Handle to fill the range C25:E25 with the formula in cell B25.Hide the gridlines for the Profit Analysis worksheet.Change the orientation of the worksheet to Landscape.Your workbook should look like the Final Figure on the following page. Save your changes, close the workbook, then exit Excel. Follow the directions on the SAM website to submit your completed project.Final Figure 1: Profit Analysis Worksheet Notes1. Save a workbook for the first time. 2. Save a workbook with a new name. 3. Select a cell. 4. Save a workbook to a new location. 5. Enter a number into a cell. 6. Create a formula using arithmetic operators. 7. Create a formula using the SUM function. 8. Edit cell contents. 9. Use the Fill handle to copy a formula. 10. Undo an action. 11. Insert a header using Header & Footer Elements. 12. Enter text in a header. 13. Hide a worksheet. 14. Hide worksheet gridlines. 15. Insert a page break. 16. Change the page orientation. 17. Print a section of a worksheet. 18. Set the print area of a worksheet. 19. Scale a worksheet for printing. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download