Excel Modules 1-4 SAM Capstone Project 1a | Tallridge Regional Medical Center

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


Contact Me:
WhatsApp No:+1(725) 272-9378



#Excel_Modules_1-4_SAM_Capstone_Project_1a #NP_EX19_CS1-4a #ExcelModules1-4SAMCapstoneProject1a #Excel_Capstone_Project_1-4 #ExcelCapstoneProject14 #NewPerspectivesExcel2019Modules1-4SAMCapstoneProject1a #Capstone #Excel_Modules_1-4 #New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1a
#Tallridge_Regional_Medical_Center #tallridgeregionalmedicalcenter

#New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1a
#NewPerspectivesExcel2019Modules1-4SAMCapstoneProject1a
#New Perspectives Excel 2019 Modules 1-4 SAM Capstone Project 1a
#Excel Modules 1-4 SAM Capstone Project 1a
#Excel_Modules_1_4_SAM_Capstone_Project_1a
#ExcelModules1-4SAMCapstoneProject1a
#Excel Capstone Project 1-4
#ExcelCapstoneProject1-4
#Excel_Capstone_Project_1_4
#Excel Capstone Project 1-4 Tallridge Regional Medical Center
#ExcelCapstoneProject1-4TallridgeRegionalMedicalCenter
#Excel_Capstone_Project_1_4_ Tallridge_Regional_Medical_Center
#NP_EX19_CS1-4a_FirstLastName_1.xlsx
#NP_EX19_CS1-4a_FirstLastName_2.xlsx
#NP_EX19_CS1-4a
#Tallridge Regional Medical Center
#Tallridge_Regional_Medical_Center
#TallridgeRegionalMedicalCenter
#FORMATTING, FORMULAS, AND CHARTS
#FORMATTING_FORMULAS_AND_CHARTS
#FORMATTINGFORMULASANDCHARTS
#Shelly_Cashman_Excel_2019_Modules_1_4_SAM_Capstone_Project_1a
#ShellyCashmanExcel2019Modules1-4SAMCapstoneProject1a
#Shelly Cashman Excel 2019 Modules 1-4 SAM Capstone Project 1a
#ShellyCashmanExcel2019
#NewPerspectivesExcel2019
#Capstone
#capstoneproject




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.
6. Enter the values shown in Table 1 into the corresponding cells in the range A5:E5.
Table 1: Data for the Range A5:E5

A B C D E
5 Abbreviation Department MD RN Support

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).