LIT_MP5

What is the correct way of referring to the range of cells which record both Regular and Overtime Hours for the employees?

• A5,B20

• B5:C20

• 5B:20C

• B5,C20

In cell B23, use a function to calculate the total hours worked  (both Regular and Overtime).  How many hours were worked in total?

• 515

• 528

• 542

• 551

In cell B24, use a function to calculate the Average Pay Rate for employees.  What is the Average Pay Rate?

• $12.69

• $13.02

• $13.56

• $14.73

Subtotal is equal to an employee's Pay Rate multiplied by their Hours, plus their Overtime Hours at a rate that is 1.5 times their Pay Rate.  What is John Dole's Subtotal?

• $343.00

• $351.00

• $359.00

• $362.00

Subtotal is equal to an employee's Pay Rate multiplied by their Hours, plus their Overtime Hours at a rate that is 1.5 times their Pay Rate.  What is Lyle O'Toole's Subtotal?

• $675.00

• $690.50

• $704.00

• $712.50

In cells C30 and C31 are listed the Income Tax rates for employees earning less than $450.00 and greater than or equal to $450.00.  In column F, create an IF function, which evaluates which tax bracket an employee falls into and uses Absolute References to return the amount of their total taxes paid.  How much does John Abhot pay in Income tax?

• $106.96

• $107.81

• $134.31

• $134.92

In cells C30 and C31 are listed the Income Tax rates for employees  earning less than $450.00 and greater than or equal to $450.00. In column F, create an IF function, which evaluates which tax bracket an employee falls into and uses Absolute References to return the amount of their total taxes paid.  How much does Fred Gretchen pay in Income Tax?

• $192.61

• $193.28

• $241.96

• $242.50

Pay After Taxes is equal to the Subtotal minus Income Tax.  How much does Alex Zimmerman make after taxes?

• $467.01

• $421.73

• $509.98

• $510.13

In cell B25, use a function to determine the highest Pay After  Taxes value.  Which of the following is the correct value?

• $513.50

• $522.50

• $537.50

• $565.50

In cell B27, use a function to determine the average Pay After Taxes value.  Which of the following is the correct value?

• $312.68

• $342.18

• $351.56

• $366.76