Скачать или смотреть Excel 2019 |Modules 1-4: SAM Capstone Project 1a |Tallridge Regional Medical Center

UNITED STATES
Excel 2019 |Modules 1-4: SAM Capstone Project 1a |Tallridge Regional Medical Center #newperspectives




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

new perspectives excel 2019, modules 1-4 sam capstone project 1a, tallridge regional medical center undefined project, new perspectives excel 2019 modules 1-4 sam capstone project 1a, modules 1-4 sam capstone project 1a tallridge regional medical center, tallridge regional medical center sam capstone project 1, shelly cashman excel 2019 modules 1-4 sam capstone project 1a, shelly cashman excel 2019, excel 2019 modules 1-4 sam capstone project 1a, Module 1 end of module project 1, Module 6 sam project 1c, Module 12 end of module project 1
Ask
Get answers, explore topics, and more

Ask questions
Transcript
Follow along using the transcript.


Show transcript

Assignments Tutorial
102 subscribers
Videos
About
0 Comments
cloud
cloud
cloud
cloud
cloud
cloud
cloud
pearson MyItLab
Add a comment...