Excel Modules 1-4 SAM Capstone Project 1b | NP_EX19_CS1-4b | Saxon Municipal Government

Whatsapp: +923177402009
Whatsapp: +923084981394
Email: Alim25431@gmail.com
Whatsapp link: https://wa.me/qr/ALGVOLHWN4M2K1

Instagram link: https://www.instagram.com/alim25431?i...

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more

Excel Modules 1-4 SAM Capstone Project 1b | NP_EX19_CS1-4b | Saxon Municipal Government


#Excel Modules 1-4 SAM Capstone Project 1b#Modules 1-4 SAM Capstone Project 1b#Modules 1-4 SAM Capstone#SaxonMunicipalGovernment
#New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1b
#Excel_Modules_1-4#ExcelCapstoneProject14#ExcelModules1-4SAMCapstoneProject1b#Capstone#Project 1b#Modules 1-4 SAM
#Excel Modules 1-4 SAM Capstone#Capstone Project 1b
#NP_EX19_CS1-4b
#Shelly #Saxon #New
#Excel_Modules_1-4_SAM_Capstone_Project_1b #NP_EX19_CS1-4b #ExcelModules1-4SAMCapstoneProject1b #Excel_Capstone_Project_1-4 #ExcelCapstoneProject14 #NewPerspectivesExcel2019Modules1-4SAMCapstoneProject1b #Capstone #Excel_Modules_1-4 #New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1b
#Saxon_Municipal_Government #SaxonMunicipalGovernment

#New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1b
#NewPerspectivesExcel2019Modules1-4SAMCapstoneProject1b
#New Perspectives Excel 2019 Modules 1-4 SAM Capstone Project 1b
#Excel Modules 1-4 SAM Capstone Project 1b
#Excel_Modules_1_4_SAM_Capstone_Project_1b
#ExcelModules1-4SAMCapstoneProject1b
#Excel Capstone Project 1-4
#ExcelCapstoneProject1-4
#Excel_Capstone_Project_1_4
#Excel Capstone Project 1-4 Saxon Municipal Government
#ExcelCapstoneProject1-4SaxonMunicipalGovernment
#Excel_Capstone_Project_1_4_ Saxon_Municipal_Government
#NP_EX19_CS1-4b_FirstLastName_1.xlsx
#NP_EX19_CS1-4b_FirstLastName_2.xlsx
#NP_EX19_CS1-4b
#Saxon Municipal Government
#Saxon_Municipal_Government
#SaxonMunicipalGovernment
#FORMATTING, FORMULAS, AND CHARTS





PROJECT STEPS
1. Abdul Rassim is a financial analyst for the Saxon Municipal Government. Abdul is building a workbook that summarizes budget and staffing data for the city.
Change the theme of the workbook to Office.
2. On the Employees worksheet, change the width of columns D through I to 11.00 characters.
3. Change the height of rows 2 and 6 to 30 points.
4. Merge and center the contents of the range B3:K3.
5. Format the merged range B3:K3 as described below:
a. Apply the 40% - Accent 2 cell style.
b. Apply bold formatting.
c. Change the font size to 12.
6. Enter the values shown in Table 1 into the corresponding cells in the range B6:F6.

7. Format the range B6:K6 as described below:
a. Center cell contents.
b. Change the font size to 11 point.
c. Change the background color to Orange, Accent 2, Lighter 80% (6th column, 2nd row on the Theme Colors palette).
d. Apply Wrap Text to the text in cell K6.
8. Select the range B7:K17 and then add a Light Gray, Background 2, Darker 10% (2nd row, 3rd column in the Theme Colors palette) border to all sides of each cell.
9. Select the range B18:K18 and then add a thin top border to each cell using Orange, Accent 2 (1st row, 6th column in the Theme Colors palette).
10. Select the range I7:I17 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 20% as Light Red Fill with Dark Red Text.




#New_Perspectives_Excel_2019_Modules_1_4_SAM_Capstone_Project_1b
#NewPerspectivesExcel2019Modules1-4SAMCapstoneProject1b
#New Perspectives Excel 2019 | Modules 1-4: SAM Capstone Project 1b
#Shelly_Cashman_Excel_2019_Modules_1_4_SAM_Capstone_Project_1b
#ShellyCashmanExcel2019Modules1-4SAMCapstoneProject1b
#Shelly Cashman Excel 2019 | Modules 1-4: SAM Capstone Project 1b


#New_Perspectives_Excel_2019_Modules_5_8_SAM_Capstone_Project_1b
#NewPerspectivesExcel2019Modules5-8SAMCapstoneProject1b
#New Perspectives Excel 2019 | Modules 5-8: SAM Capstone Project 1b
#Shelly_Cashman_Excel_2019_Modules_5_8_SAM_Capstone_Project_1b
#ShellyCashmanExcel2019Modules5-8SAMCapstoneProject1b
#Shelly Cashman Excel 2019 | Modules 5-8: SAM Capstone Project 1b


#New_Perspectives_Excel_2019_Modules_9_12_SAM_Capstone_Project_1b
#NewPerspectivesExcel2019Modules9-12SAMCapstoneProject1b
#New Perspectives Excel 2019 | Modules 9-12: SAM Capstone Project 1b
#Shelly_Cashman_Excel_2019_Modules_9_12_SAM_Capstone_Project_1b
#ShellyCashmanExcel2019Modules9-12SAMCapstoneProject1b
#Shelly Cashman Excel 2019 | Modules 9-12: SAM Capstone Project 1b