New Perspectives Excel 365/2021 | Modules 1-4: SAM Capstone Project 1a | NP_EX365_2021_CS1-4a

Описание: New Perspectives Excel 365/2021 | Modules 1-4: SAM Capstone Project 1a | Instructions_NP_EX365_2021_CS1-4a | #Modules1-4 #TallridgeRegionalMedicalCenter #Modules1-4:SAMCapstoneProject1a



Contact us:'

Gmail: [email protected]


WhatsApp : +923137134857


WhatsApp Link: https://tinyurl.com/3evzy692






#New Perspectives Excel 365/2021 | Modules 1-4: SAM Capstone Project 1a
#New Perspectives Excel 365/2021
#Perspectives Excel 365/2021
#Excel 365/2021
#Modules 1-4: SAM Capstone Project 1a
#SAM Capstone Project 1a
#Capstone Project 1a
#Project 1a
#Modules 1-4
#SAM Capstone Project
#Capstone Project
#Project


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.