excel hw

profilemike patel

 

Start Excel. Open the downloaded Excel file named Skills_e03_Grader_EOC.xlsx.
 
0
2Rename the Sheet1 worksheet as Courthouse and then change the color of the sheet tab to Ice Blue - Accent 5.
 
4
3Group 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
4With all of the worksheets grouped together, apply the cell style 40% - Accent3 to the range A4:F4.
 
3
5With the range A4:F4 still selected and the worksheets grouped, center align and wrap the text in the cells.
 
6
6With 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
7With all of the worksheets grouped together, select the range B9:F9 and use the SUM function to total the values in each column.
 
6
8With all of the worksheets grouped together, apply the Total cell style to the selected range (B9:F9).
 
3
9With 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
10Insert a new worksheet. Rename the sheet tab as Summary and then change the color of the sheet tab to Orange, Accent 1.
 
6
11Move the Summary sheet to the left of the Courthouse sheet tab.
 
4
12Copy 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
13On 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
14On 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
15On the Summary sheet, use the fill handle to copy the formulas in the range B5:B7 through column F.
 
4
16On 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
17Create a clustered bar chart using the nonadjacent ranges A4:A7 and C4:E7 on the Summary sheet.
 
7
18Move the bar chart to a new sheet and rename the chart sheet as Payroll Chart.
 
3
19Add the chart title Payroll Adjustments by Location above the chart and then switch the row and column data on the bar chart.
 
5
20Change the style of the bar chart to Style 13 and the layout to Layout 3.
 
6
21Modify the primary horizontal axis of the bar chart so that the text is aligned with a custom angle of -40°.
 
5
22Ensure 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

blurred-text
NOT RATED
  • attachment
    skills_e03_grader_eoc.xlsx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    skills_e03_grader_eoc.xlsx
Bids(0)