Question

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

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 = 88; H12 = 15; L3 = 24; M14 = 150; and G4 = 5.

1.C2 > H12 Returned value: _______________________

2.L3 = G4 Returned value: _______________________

3.M14 + 15 * H12 / 10 <= L3 Returned value: _______________________

4.M14 – G4 < H12 / C2 Returned value: _______________________

5.(C2 + H12) * 2 >= L3 – (C2 / 4) * 2 Returned value: _______________________

6.L3 + 300 > H12 * G4 + 10 Returned value: _______________________

7.G4 * M14 >= 2 * (H12 + 25) Returned value: _______________________

8.H12 = 10 * (C2 / 8)Returned value: _______________________

1. Since 88 > 15, the answer is True.

2.since 24 is not equal to 5, the answer is false.

3. SinceM14+15*H12/10 = 172.5 and this is greater than 24, the answer is false

4. since M14 - G4 = 145 and H12/C2 = 0.17, the answer is false

5. Since (c2+H12)*2 = 206 and L3-(C2/4)*2 = -20, the answer is true

6. L3+300 = is 324, andH12*G4+10 is 85, the answer is true

7. Since G4*M14 = 750 and 2*(H12+25) = 80, the answer is true

8. 10*(C2/8) is 110, the answer is false

`

Earn Coins

Coins can be redeemed for fabulous gifts.

Need Online Homework Help?

Most questions answered within 1 hours.