Shelly Cashman Excel 365/2021 | Modules 1-3: SAM Capstone Project 1a | Help in Homework |

24 / 7 Live Support
[e-mail]
[phone]
[phone]
Ensight Healthcare Consultants
CREATE FORMULAS WITH FUNCTIONS
GETTING STARTED
• Save the file SC_EX365_2021_CS1-3a_FirstLastName_1.xlsx as SC_EX365_2021_CS1-3a_FirstLastName_2.xlsx
o Edit the file name by changing “1” to “2”.
o If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.
• With the file SC_EX365_2021_CS1-3a_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.
o If cell B6 does not display your name, delete the file and download a new copy.
PROJECT STEPS
1. Carla Arranga is a senior account manager at Ensight Healthcare Consultants, a consulting firm that works with hospitals, clinics, and other healthcare providers around the world. Carla has created a workbook summarizing the status of the consulting project for Everett Hospital. She asks for your help in completing the workbook.
Go to the Project Status worksheet. Unfreeze the first column since it does not display information that applies to the rest of the worksheet.
2. In cell J1, enter a formula using the NOW function to display today's date. Apply the Short Date number format to display only the date in the cell.
3. Format the worksheet title as follows to use a consistent design throughout the workbook:
a. Fill cell B2 with the Dark Red, Accent 6, Lighter 40% shading color.
b. Change the font color to White, Background 1.
c. Merge and center the contents of cell B2 across the range B2:H2.
d. Use AutoFit to resize row 2 to its best fit.
4. Format the billing rate data as follows to suit the design of the worksheet and make the data easier to understand:
a. Italicize the contents of cell I2 to match the formatting in cell I1.
b. Apply the Currency number format to cell J2 to clarify that it contains a dollar amount.