Illustrated Excel 2016 Module 1: SAM Project 1a Christian Styles 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

Illustrated Excel 2016 Module 1: SAM Project 1a

Christian Styles

1. 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.

Select the Profit Analysis worksheet. Add a header to the worksheet by entering the text

Katherine's Restaurants Analysis into the center section of the header.

Click on any cell and switch back to Normal view.

Add a header to a worksheet.

2.  Enter the text Katherine’s Restaurants in cell A1.

Enter text in a cell.

3. Enter the text Profit Analysis in cell A2.

Enter text in a cell.

4. In cell A3, change the text “2015” to 2018 so that the cell contains the text “Katherine's Pizza 2018-2020 Profit”.

Update text in a cell.

5. In cell D10, enter the value 38900.

Enter a number in a cell.

6.Use the Fill Handle to fill the range E6:E10 with the formula in cell E5.

Copy a formula into a range.

7.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.

Create a formula using a function.

Copy a formula into a range.

8. In cell A13, insert the text 2018-2020 Profit after the word “Burgers” so that the cellcontains the text “Katherine's Sandwiches and Burgers 2018-2020 Profit”.

Update text in a cell.

9.Enter the information shown in Table 1 of the Instruction file into the range B20:D20.

Enter numbers into a range of cells.

10.Katherine wants to determine the total profit from each type of sandwich or 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.

Create a formula using a function.

Copy a formula into a range.

11. 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.

Create a formula using a function.

Copy a formula into a range.

12. 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.

Create a formula.

Copy a formula into a range.

13. Hide the gridlines for the Profit Analysis worksheet.

Hide gridlines in a worksheet.

14.Change the orientation of the worksheet to Landscape.

Change the orientation of a worksheet.