Question: Please provide the steps for how to do each step, not just the final answer. 1. Carla Acranga is a senior account manager at Ensight

Please provide the steps for how to do each step, not just the final answer.

Please provide the steps for how to do each step, not just

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!