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

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


#TallridgeRegionalMedicalCenter
#Excel Modules 1-4 SAM Capstone Project 1a
#Tallridge_Regional_Medical_Center
#New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1a
#Excel_Modules_1-4#ExcelCapstoneProject14
#NewPerspectivesExcel2019Modules1-4SAMCapstoneProject1a#Capstone
#NP_EX19_CS1-4a#Excel_Capstone_Project_1-4#ExcelModules1-4SAMCapstoneProject1a#SAM Capstone Project 1aEXCEL modules 1-4 sam capstone project 1a









Tallridge Regional Medical Center
FORMATTING, FORMULAS, AND CHARTS

GETTING STARTED
• Open the file NP_EX19_CS1-4a_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as NP_EX19_CS1-4a_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file NP_EX19_CS1-4a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
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.