D20 Cell B20 C20 Mindtap Excel Homework

By /

D20 Cell B20 C20 Mindtap Excel Homework

GETTING STARTED

  • Open 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 STEPS

  • Katherine 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.
  • 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.
  • Katherine 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.
  • 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.
  • Hide the gridlines for the Profit Analysis worksheet.
  • Change the orientation of the worksheet to Landscape.

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.

Table 1: Values for the Range B20:D20

Cell

B20

C20

D20

Value

25200

26410

25780

Use the Fill Handle to fill the range E16:E20 with the formula in cell E15.

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.

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.