Module $3-$ FINAL PROJECT

Instructions Part $1$: For each of the following logical tests, indicate whether an IF function in

Excel would return a value of True or False; given the following cell values:

$C2=41$

$H12=13$

$L3=32$

$M14=125$

$G4=2$

$$ Provide answers for Part $1$& Part $2$ in a Word document.

$L3=G4M14+{15}^{**}H\frac{12}{10}L3(C2+H12)**2L3-(L\frac{3}{4})**2L3+300>H12G4+10G4**M142**(M14-25)H12=10**(C2+8)M14+G4$

$(C2+H12)**2L3-(L\frac{3}{4})**2$

Returned value:

Returned value:

Returned value:

Returned value:

$L3+300>H12*G4+10$

Returned value:

$G4**M142**(M14-25)$

Returned value:

$H12=10**(C2+8)$

Returned value:

Returned value:

Instructions Part $2$: Write cell $L23as$ a relative reference, $absolute$

reference, mixed reference with the column varying, and mixed

reference with the row varying.$C2$

$L3=G4$

$M14+{15}^{**}H\frac{12}{10}L3$

$M14+G4$

$(C2+H12)**2L3-(L\frac{3}{4})**2$

Returned value:

Returned value:

Returned value:

Returned value:

$L3+300>H12*G4+10$

Returned value:

$G4**M142**(M14-25)$

Returned value:

$H12=10**(C2+8)$

Returned value:

Returned value:

Instructions Part $2$: Write cell $L23as$ a relative reference, $absolute$

reference, mixed reference with the column varying, and mixed

reference with the row varying.