#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
Contact Me
Email :cengagesolutions@gmail.com
WhatsApp:+923096000718
WhatsApp Direct Chat : wa.link/sspsfs
#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
#FORMATTING_FORMULAS_AND_CHARTS
#FORMATTINGFORMULASANDCHARTS
#Shelly_Cashman_Excel_2019_Modules_1_4_SAM_Capstone_Project_1b
#ShellyCashmanExcel2019Modules1-4SAMCapstoneProject1b
#Shelly Cashman Excel 2019 Modules 1-4 SAM Capstone Project 1b
#ShellyCashmanExcel2019
#NewPerspectivesExcel2019
#Capstone
#capstoneproject
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
Негізгі бет Excel Modules 1-4 SAM Capstone Project 1b | NP_EX19_CS1-4b | Saxon Municipal Government
Пікірлер: 1