excel hw
mike patel
Start Excel. Open the downloaded Excel file named Skills_e03_Grader_EOC.xlsx. | 0 | |
2 | Rename the Sheet1 worksheet as Courthouse and then change the color of the sheet tab to Ice Blue - Accent 5. | 4 |
3 | Group all three worksheets. Add the file name field to the left footer and the sheet name field to the right footer so that they will update automatically. Return to Normal view. | 6 |
4 | With all of the worksheets grouped together, apply the cell style 40% - Accent3 to the range A4:F4. | 3 |
5 | With the range A4:F4 still selected and the worksheets grouped, center align and wrap the text in the cells. | 6 |
6 | With all of the worksheets grouped together, in cell F5, create a formula that will subtract the total deductions (in C5, D5, and E5) from the Total Gross Pay (in B5). Copy the formula down through cell F8. | 6 |
7 | With all of the worksheets grouped together, select the range B9:F9 and use the SUM function to total the values in each column. | 6 |
8 | With all of the worksheets grouped together, apply the Total cell style to the selected range (B9:F9). | 3 |
9 | With all of the worksheets grouped, apply the cell style Currency [0] to the ranges B5:F5 and B9:F9. Apply the cell style Comma [0] to the range B6:F8. Ungroup the sheets. | 6 |
10 | Insert a new worksheet. Rename the sheet tab as Summary and then change the color of the sheet tab to Orange, Accent 1. | 6 |
11 | Move the Summary sheet to the left of the Courthouse sheet tab. | 4 |
12 | Copy the range A1:F4 on the Courthouse sheet. Paste the copied values into cell A1 on the Summary sheet, keeping the source column widths. | 6 |
13 | On the Summary sheet, in cell A2, replace the existing text with City Payroll; in cell A4, replace the existing text with Location; in cell A5, type Courthouse; in cell A6, type City Center; in cell A7, typeCommunity Center; and in cell A8, type Total. | 2 |
14 | On the Summary sheet, in cell B5, create a formula that will display the value from cell B9 on the Courthouse sheet. Use the same technique in cells B6 and B7 to place the Total Gross Pay values from the City Center and the Community Center sheets on the Summary sheet. | 6 |
15 | On the Summary sheet, use the fill handle to copy the formulas in the range B5:B7 through column F. | 4 |
16 | On the Summary sheet, select the range B8:F8 and use the SUM function to total the values in each column. Apply the Total cell style to the selected range. | 6 |
17 | Create a clustered bar chart using the nonadjacent ranges A4:A7 and C4:E7 on the Summary sheet. | 7 |
18 | Move the bar chart to a new sheet and rename the chart sheet as Payroll Chart. | 3 |
19 | Add the chart title Payroll Adjustments by Location above the chart and then switch the row and column data on the bar chart. | 5 |
20 | Change the style of the bar chart to Style 13 and the layout to Layout 3. | 6 |
21 | Modify the primary horizontal axis of the bar chart so that the text is aligned with a custom angle of -40°. | 5 |
22 | Ensure that the worksheets are correctly named and placed in the following order in the workbook: Payroll Chart, Summary, Courthouse, City Center, Community Center. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. |
- 10 years ago
- 3
Answer(2)
Purchase the answer to view it
NOT RATED
- skills_e03_grader_eoc.xlsx
Purchase the answer to view it
NOT RATED
- skills_e03_grader_eoc.xlsx
Bids(0)
other Questions(10)
- the western heritage volume 1: to 1740page 661.what virtues does Pericles find in the Athenian constitution?2. against what criticisms is...
- can two fractions have a sum greater than 1?
- Find all the zeros of the given function and show all work: f(x)= x^3+ 4 x^2+93x+1000
- week8
- what is united state circuit court of appeals for the federal circuit
- Write a composite time signature in which triple meter in 8th notes is followed by a duple meter in quarter...
- -10-3(4x-3)+2y-1
- What is a sig fig
- solve for power: 500J, 50 minutes
- p/9 = 5/6