Employee

Hourly

Rate

Regular

Hours

 

Earnings

Benitez, L.

14.36

40

 

Daniel, K.

15.14

36

 

Huang, M.

11.85

40

 

O’Neil, A.

13.11

40

 

Parker, N.

16.62

40

 

TOTAL

 

 

 

 

 

  1. Copy the above table to a Microsoft Word document file.
  2. Save the document as Payroll1.7 and your initials
  3. Display the Tables and Borders Toolbar.
  4. Calculate the earnings for Benitez.
    1. Position the insertion point in the first blank cell in the Earnings column.
    2. Open the Table menu and choose Formula.
    3. Word Proposes =SUM(LEFT).  Delete the proposed formula and enter =c2*b2.
    4. Click the down arrow in the Number format list box and select $#,##0.00; ($#,##0.000).
    5. Click OK
  5. Calculate the earnings for Daniel in the same way, changing the formula to =c3*b3.
  6. Enter formulas in the Earnings cell for Huyang, O’Neil, and Parker.
  7. Position the insertion point in the last row of the Regular Hours column and click the AutoSum button on the Tables and Borders toolbar.  Word automatically computes the value of all the numbers above.
  8. Position the insertion point in the last row of the Earnings column and click the Autosum button.
  9. Insert a new row at the bottom of the table. Enter Average Hrs in the first cell.
  10. Press Tab to move the insertion point to the Regular Hours column.  Open the Table menu and choose Formula.
  11. Deflete the proposed formula and enter =AVERAGE(c2:c6).