Illustrated Excel 2016 Module 1: SAM Project 1b Sherita Thomas 1

Subject:MS ExcelPrice:19.87 Bought3

Share With

Illustrated Excel 2016 Module 1: SAM Project 1b

Sherita Thomas

1. Joseph owns two clothing stores, and he wants to determine which business is a better

option for adding investment. He is working on an Excel worksheet that shows detailed

financial information for each store.

Select the Profit Analysis worksheet and add a header to this worksheet. Enter the text

Joseph's Jeans and More in the center box of the header.

Click on any cell and switch back to Normal view.

Add a header to a worksheet.

2.Enter the text Joseph's Jeans and More in cell A1.

Enter text in a cell.

3.Enter the text Profit Analysis in cell A2.

Enter text in a cell.

4.Edit the text in cell A3 to update the year so that it reads “Women's Clothing Store 2018-

2020 Profit”.

Update a value in a cell.

5.In cell D10, enter the value 42560.

Enter a value 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 just created in cell B11.

Enter a formula using a function.

Copy a formula into a range.

8. In cell A13, insert the text 2018-2020 Profit after the word “Store” so that it reads “Men's

Clothing Store 2018-2020 Profit”.

Update text in a cell.

9.Enter the information shown in Table 1 in the Instruction file into the range B19:D19.

Enter a value in a cell.

10.

Joseph wants to see the total profit from each category of men’s clothing sold between 2018

and 2020. In cell E15, enter a formula using the SUM function to total the values in the range

B15:D15.

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

Enter a formula using a function.

Copy a formula into a range.

11. In cell B20, enter a formula that uses the SUM function to total the range B15:B19. Use the

Fill Handle to fill the range C20:E20 with the formula in cell B20.

Enter a formula using a function.

Copy a formula into a range.

12. 

Joseph wants to know the difference in total profits between his two stores.

In cell B24, enter a formula that subtracts the value in cell B20 from the value in cell B11.

Use the Fill Handle to fill the range C24:E24 with the formula in cell B24.

Enter a formula.

Copy a formula into a range.

13.Hide the gridlines for the Profit Analysis worksheet.

Turn off the display of gridlines in a worksheet.

14.Change the orientation of the worksheet to Landscape.

Change the orientation of a worksheet.