#Excel_Module_2_SAM_End_of_Module_Project_2 #NP_EX19_EOM2-2 #ExcelModule2SAMEndofModuleProject2 #Module2EndofModuleProject2 #ExcelModule2 #Excel_Module_2 #NP_EX19_EOM2-2_FirstLastName_1.xlsx #SAM #Cengage #End_of_Module #NP #Shingle_Rock_College #ShingleRockCollege
Contact Me
Email :
[email protected]
WhatsApp:+923096000718
WhatsApp Direct Chat : https://wa.link/sspsfs
#Excel Module 2 SAM End of Module Project 2
#ExcelModule2SAMEndofModuleProject2
#Excel_Module_2_SAM_End_of_Module_Project_2
#Excel Module 2: End of Module Project 2
#ExcelModule2EndofModuleProject2
#Excel_Module_2_End_of_Module_Project_2
#Shingle Rock College
#ShingleRockCollege
#Shingle_Rock_College
#FORMAT WORKBOOK TEXT AND DATA
#FORMAT WORKBOOK TEXT AND DATA
#FORMAT WORKBOOK TEXT AND DATA
#Excel Module 2 SAM End of Module Project 2 Shingle Rock College
#ExcelModule2SAMEndofModuleProject2ShingleRockCollege
#Excel_Module_2_SAM_End_of_Module_Project_2_Shingle_Rock_College
#New Perspectives Excel 2019 Module 2 End of Module Project 2
#NewPerspectivesExcel2019Module2EndofModuleProject2
#New_Perspectives_Excel_2019_Module_2_End_of_Module_Project_2
#shelly cashman excel 2019 module 2 end of module project 2
#shelly_cashman_excel_2019_module_2_end_of_module_project_2
#shellycashmanexcel2019module2endofmoduleproject2
#cengage
#NP
#NP_EX19_EOM2-2_FirstLastName_1.xlsx
#NP_EX19_EOM2-2_FirstLastName_2.xlsx
#NP_EX19_EOM2-2
PROJECT STEPS
1. Sid Kellerman works in the Office of Admissions at Shingle Rock College. Sid is adding formatting to the workbook he uses to track applications for the upcoming academic year to make the data easier to read and print.
Switch to the Applications worksheet, then format the headings. Merge and Center the range A1:F1.
2. For the range A1:F1, apply the Accent 6 cell style, then bold the contents and change the font size to 18 point.
3. Merge and center the range A2:F2, apply the 40% - Accent 6 cell style, then change the font size to 12 point. [Mac Hint: The font size may automatically be changed to 12 points.]
4. For the range A4:A5, change the alignment to right.
5. Unmerge the range B4:C4.
6. Format the date and application total. For the range A4:B5, apply the 40% - Accent 5 cell style, then change the font size to 12 point.
7. For the range B4:B5, bold the cell contents.
8. For cell B4, apply the Long Date number format (e.g., Friday, July 16, 2021).
#NP_EX19_EOM1-1
#NP_EX19_EOM2-1
#NP_EX19_EOM3-1
#NP_EX19_EOM4-1
#NP_EX19_EOM5-1
#NP_EX19_EOM6-1
#NP_EX19_EOM7-1
#NP_EX19_EOM8-1
#NP_EX19_EOM9-1
#NP_EX19_EOM10-1
#NP_EX19_EOM11-1
#NP_EX19_EOM12-1
#NP_EX19_EOM1-2
#NP_EX19_EOM2-2
#NP_EX19_EOM3-2
#NP_EX19_EOM4-2
#NP_EX19_EOM5-2
#NP_EX19_EOM6-2
#NP_EX19_EOM7-2
#NP_EX19_EOM8-2
#NP_EX19_EOM9-2
#NP_EX19_EOM10-2
#NP_EX19_EOM11-2
#NP_EX19_EOM12-2
#NP_EX19_EOM1-1_FirstLastName_1.xlsx
#NP_EX19_EOM2-1_FirstLastName_1.xlsx
#NP_EX19_EOM3-1_FirstLastName_1.xlsx
#NP_EX19_EOM4-1_FirstLastName_1.xlsx
#NP_EX19_EOM5-1_FirstLastName_1.xlsx
#NP_EX19_EOM6-1_FirstLastName_1.xlsx
#NP_EX19_EOM7-1_FirstLastName_1.xlsx
#NP_EX19_EOM8-1_FirstLastName_1.xlsx
#NP_EX19_EOM9-1_FirstLastName_1.xlsx
#NP_EX19_EOM10-1_FirstLastName_1.xlsx
#NP_EX19_EOM11-1_FirstLastName_1.xlsx
#NP_EX19_EOM12-1_FirstLastName_1.xlsx
#NP_EX19_EOM1-2_FirstLastName_1.xlsx
#NP_EX19_EOM2-2_FirstLastName_1.xlsx
#NP_EX19_EOM3-2_FirstLastName_1.xlsx
#NP_EX19_EOM4-2_FirstLastName_1.xlsx
#NP_EX19_EOM5-2_FirstLastName_1.xlsx
#NP_EX19_EOM6-2_FirstLastName_1.xlsx
#NP_EX19_EOM7-2_FirstLastName_1.xlsx
#NP_EX19_EOM8-2_FirstLastName_1.xlsx
#NP_EX19_EOM9-2_FirstLastName_1.xlsx
#NP_EX19_EOM10-2_FirstLastName_1.xlsx
#NP_EX19_EOM11-2_FirstLastName_1.xlsx
#NP_EX19_EOM12-2_FirstLastName_1.xlsx
#ExcelModule1SAMEndofModuleProject1
#ExcelModule2SAMEndofModuleProject1
#ExcelModule3SAMEndofModuleProject1
#ExcelModule4SAMEndofModuleProject1
#ExcelModule5SAMEndofModuleProject1
#ExcelModule6SAMEndofModuleProject1
#ExcelModule7SAMEndofModuleProject1
#ExcelModule8SAMEndofModuleProject1
#ExcelModule9SAMEndofModuleProject1
#ExcelModule10SAMEndofModuleProject1
#ExcelModule11SAMEndofModuleProject1
#ExcelModule12SAMEndofModuleProject1
#ExcelModule1SAMEndofModuleProject2
#ExcelModule2SAMEndofModuleProject2
#ExcelModule3SAMEndofModuleProject2
#ExcelModule4SAMEndofModuleProject2
#ExcelModule5SAMEndofModuleProject2
#ExcelModule6SAMEndofModuleProject2
#ExcelModule7SAMEndofModuleProject2
#ExcelModule8SAMEndofModuleProject2
#ExcelModule9SAMEndofModuleProject2
#ExcelModule10SAMEndofModuleProject2
#ExcelModule11SAMEndofModuleProject2
#ExcelModule12SAMEndofModuleProject2