Ms. Excel and Ms. Access Revision

What is the VLOOKUP formula to find the last name for Mary?

• =VLOOKUP(H6,A4:E20,2,FALSE)

• =VLOOKUP(A4,A4:E20,1,FALSE)

• =VLOOKUP(B4,A4:A20,1,FALSE)

• =VLOOKUP(H6,A4:E20,1,FALSE)

What is the VLOOKUP for Mary's employment status?

• =VLOOKUP(C4,C4:E20,2,FALSE)

• =VLOOKUP(C4,C4:E20,3,FALSE)

• =VLOOKUP(C4,C4:E20,1,FALSE)

• =VLOOKUP(B4,C4:E20,1,FALSE)

What is the formula for Today's date?

• =TODAY ( )

• =NOW ( )

• =DAY ( )

• =DATE ( )

What is the formula to find bonus status for Jose Grimes?

• =IF(C20=$C$5,"No Bonus")

• =IF(C20=$C$5,"Bonus")

• =IF(C20=$C$5,"Bonus",No Bonus)

• =IF(C20=$C$5,"Bonus","No Bonus")

What is the formula to calculate total salaries?

• =SUM(E4:E20)

• =SUM(E4/E20)

• =SUM(E4*E20)

• =SUM(E4+E20)

What is the formula to Count for Full Time?

• =COUNTIF(C4:C20,Full Time)

• =COUNTIF(C4:C20,"Full Time")

• =COUNTIF(B4:B20,"Full Time")

• =COUNTIF(A4:A20,"Full Time")

What is the formula to Sum for Part Time?

• =SUMIF(C4:C20,"Part Time",E4:E20)

• =SUMIF(C4:C20,"Part Time")

• =SUMIF(C4:C20,Part Time,E4:E20)

• =SUMIF("Part Time",E4:E20)

What is the formula for current date and time?

• = HOUR ( )

• = NOW ( )

• = DAY ( )

• = DATE ( )

How to calculate extra charge for BOO001?

• =G5*$B$15

• =E5*$B$15

• =I5*$B$15

• =E5+$B$15

What is the formula to calculate Final Price for Moo?

• =E7+F7-G7

• =E7+F7+G7

• =E7*F7-G7

• =E7/F7-G7