Question

For each of the following logical tests, inficate whether an IF function in Excel would return a value of True or False; given the following cell values: C =12; H12 – 80; L3=121;M14=25 ; and G4=15

C2>H12 Return Value____________

L3=M14Return Value____________

M14=15*H12 / 10 <=L3Return Value____________

G4 –M14 < H12/C2Return Value____________

(C2 + H12)* 2 >=L3-(C2/4)*2Return Value____________

C2 + 300 >H12*G4+10Return Value____________

G4*M14>=2*(L3+25)Return Value____________

H12 = 10*(C2/8)Return Value____________

Write Cell J49 as a relative reference, absolute reference, mixed reference with column varying, and mixed reference with row varying.