Tallridge Regional Medical Center FORMATTING, FORMULAS, AND CHARTS GETTING STARTED Carmelo Miraglia is an executive consultant at Tallridge Regional Medical Center. Carmelo is building a workbook that summarizes income and expenses for the organization. Download the file NP_EX19_C$1-4a located in Brightspace - Final Test. Open and Save the file as NP_EX19_C51-4a_Tallridge on your computer. Enter your name in cell B6 in the Documentation sheet. Complete the following Steps. 1. On the Departments worksheet, change the width of columns C through H to 12.00 characters. 2- Change the height of row 1 to 21 points. 3. Merge and center the contents of the range A2:12. 4 . Format the merged range A2:12 as described below: a. Apply the 40 % - Accent 5 cell style. b . Apply bold formatting. C. Change the font size to 14. 5. 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 Abbreviation Departmen M Suppor n D N t 6. Format the range A5:15 as described below: a. Center cell contents. b. Change the font size to 11 pt. C. Apply Wrap Text to the text in each cell. 7. In cell C14 , use the SUM function to sum the values in the range C6 :C13 8. In cell D14, use the AVERAGE function to average the values in the range D6:D13