60
EXL
6
· EnteraformulaincellN6thatwillcomputetheTotalDeductions.
Hint:
=Sum(J6:M6).
· EnteraformulaincellO6thatwillcomputetheNetPay.
Hint:
=I6-N6.
6. UsetheAutoFillfeaturetocopytheformulasdowntotheremainingcellsforeachoftheemployees.
7. UseAutoSumtofindtheTotalsforcolumnsGthroughO.
8. FormatthenumbersincolumnDandcolumnsFthroughOtoAccountingwith2decimalplacesandthe$
symbol.
9. BoldcolumnOandrow15.
10. Display formulas in your spreadsheet by using Ctrl +` to check for accuracy.
11. Carefully proofread your work for accuracy and format.
12. Resavethefile.
13. SetthePrintAreatoincludeallcellscontainingdatainthespreadsheet.
14. Print Preview and adjust Page Setup with the following changes:
· Paperorientationshouldbelandscape
· Pagemarginsshouldbe.25inchesonallsides
· Thecenteroftheheadershouldcontainthetext"PAYROLLREGISTER"
· The sheet should show gridlines
· Thesheetshouldbeverticallyandhorizontallycenteredonthepage
· Thescalingshouldbesettofittoonepage
15. Print a copy of the document if required by your instructor.
Payroll Register
For Evaluation Purposes Only