Solution for QID #48112: Illustrated Excel 2016 Module 1: SAM Project 1b Sherita T | StudyHelpMe

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.