Excel - Exam 2

Which formula will calculate the amount the gross salary for employee 1?

• =B4*C4

• =B4+C4

• =B4:C4

• =(B4:C4)*C4

Which formula will provide the right calculation for employee payout?

• =IF(B4="OFF",0,C4*B4)

• =IF(B4=OFF,0,C4*B4)

• =IF(B4="OFF",C4*B4,0)

• =IF(B4=OFF,C4*B4,0)

Which formula will calculate the amount of hours worked?

• =(C4-B4)*24

• =C4-B4

• =C4*B4

• =(C4-B4)*12

Which formula will calculate the hours worked for employees?

• =IF(C4="OFF",0,(C4-B4)*24)

• =IF(C4=OFF,0,C4-B4)

• =IF(C4="OFF",0,(C4-B4)*12)

• =IF(C4=OFF,0,(C4-B4)*24)

Given the information already present in the table. Which formula would you use to calculate the proper pay?

• =D4*E4

• =IF(C4="OFF",E4*D4,0)

• =C4-B4

• =(C4-B4)*E4

Considering that employees can sometimes work over 40 hours and as such, work overtime. Which formula would you put in this table to determine overtime hours? (determines ONLY the overtime hours)

• =IF(B5>40,0,40-B5)

• =IF(B5>40,40-B5,0)

• =B5-40

• =40-B5

Which formula would calculate the pay? knowing that regular working week is 40 hours

• =IF(B5>40,((40*C5)+(B5-40)*C5*1.5),B5*C5)

• =IF(B5>40,((40*C5)+(B5-40)*C5),B5*C5)

• =IF(B5<40,((40*C5)+(40-B5)*C5),0)

• =IF(B5<40,((40*C5)+(40-B5)*C5),B5*C5)

Considering that employees earn 3% of their sales number, which formula would you use to calculate employee pay? Use most appropriate formula that could be written once and dragged down.

• =(B5*C5)+(D5*$B$2)

• =(B5*C5)+D5

• =(B5*C5+D5)*B2

• =B5*C5+D5*B2

Which formula would you use to calculate commission to be paid? Use the most appropriate formula that can be dragged down

• =D5*$B$2

• =D5*B2

• =D5*3%

• =D5*3

Sandra worked the night shift and as such, clocked in at night and clocked out the following morning. Which formula would properly calculate the hours worked by Sandra given that she worked overnight?

• =(((C4-B4)*24)+24)

• =C4-B4

• =(C4-B4)*24

• =(C4-B4)*12