Excel 2019 | Modules 1-4: SAM Capstone Project 1b | Saxon Municipal Government #newperspectives
If you reaIly want to get the project from us then contact us on our Whatsapp. Link is given here,
Whatsapp Contact Link:
[ Ссылка ]
Whatsapp Number:
+919116641093
+918005564456
Gmail Id:
assignmentstutorial@gmail.com
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.
Table 1: Data for the Range B6:F6
B C D E F
6 Code Department Directors Clerks Staff
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.
11. Select the range J7:J17 and then use conditional formatting to add gradient fill red data bars.
12. Select the range K7:K17 and then add top/bottom conditional formatting rules to format the top 5% of values as Green Fill with Dark Green Text and the bottom 5% of values as Light Red Fill with Dark Red Text.
13. Enter a formula in cell N8 using the VLOOKUP function to find an exact match for the department code. Look up the department code (cell N7) using an absolute reference, search the employee table data (the range B7:K17) using absolute references, and return the department name (the 2nd column).
14. Copy the formula in cell N8 to the range N9:N16, pasting the formula only, and then edit the copied formulas to return the value from the column indicated by the label in column M.
new perspectives excel 2019, modules 1-4 sam capstone project 1b, saxon municipal government undefined project, new perspectives excel 2019 modules 1-4 sam capstone project 1b, modules 1-4 sam capstone project 1b saxon municipal government, saxon municipal government sam capstone project 1, shelly cashman excel 2019 modules 1-4 sam capstone project 1b, shelly cashman excel 2019, excel 2019 modules 1-4 sam capstone project 1b, Module 2 end of module project 2, Module 3 textbook project, Module 4 textbook project
Ещё видео!