Excel Modules 1-4: SAM Capstone Project 1a (Tallridge Regional Medical Center) NP_EX365_2021_CS1-4a

Описание: Excel Modules 1-4: SAM Capstone Project 1a (Tallridge Regional Medical Center) NP_EX365_2021_CS1-4a

Contact me for your assighnments and full course:

Email : [email protected]

WhatsApp:+923017351754

WhatsApp Direct Chat : https://tinyurl.com/4e2emedu


#New Perspectives Excel 365/2021 | Modules 1-4: SAM Capstone Project 1a
#Excel Modules 1-4: SAM Capstone Project 1a
#Modules 1-4: SAM Capstone Project 1a
#SAM Capstone Project 1a
#Capstone Project 1a
#Project 1a
#1a
#New Perspectives Excel 365/2021
#Perspectives Excel 365/2021
#Excel 365/2021
#NP_EX365_2021_CS1-4a
#EX365_2021_CS1-4a
#CS1-4a
#4a
#Excel Modules 1-4
#Modules 1-4
#Tallridge Regional Medical Center
#Regional Medical Center
#Medical Center
#Center
#Capstone


PROJECT STEPS
1. Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. Carmelo is building a workbook that summarizes income and expenses for the organization.
Change the theme of the workbook to Office.
2. On the Departments worksheet, change the width of columns C through H to 12.00 characters.
3. Change the height of row 1 to 21 points.
4. Merge and center the contents of the range A2:J2.
5. Format the merged range A2:J2 as described below:
a. Apply the 40% - Accent 5 cell style.
b. Apply bold formatting.
c. Change the font size to 14.
7. Format the range A5:J5 as described below:
a. Center cell contents.
b. Change the font size to 11 pt.
c. Change the background color to Blue, Accent 5, Lighter 40% (9th column, 4th row of the Theme Colors palette).
d. Apply Wrap Text to the text in each cell.
8. Select the range A6:J14 and then add a White, Background 1 border to all sides of each cell.
9. Select the range A14:J14 and then add a thin top border to each cell using the Automatic color.
10. Select the range H6:H13 and then format the range as described below:
a. Format the range with the Percentage number format with zero decimal places.
b. Add a Highlight Cells conditional formatting rule that formats cells that are greater than 0.24 as light red fill with dark red text.
11. Select the range I6:I13 and then use conditional formatting to add solid orange data bars.
12. Select the range J6:J13 and then add top/bottom conditional formatting rules to format the top 10% of values as green fill with dark green text and the bottom 10% of values as light red fill with dark red text.
13. Enter a formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column).
14. Copy the formula in cell M7 to the range M8:M15, and edit the copied formulas to return the value from the column indicated by the label in column L.

#Excel Modules 1-4: SAM Capstone Project 1a
#Tallridge Regional Medical Center
#NP_EX365_2021_CS1-4a