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: _______________________

Answer rating: 100% (QA)

Lets evaluate each logical test using the given cell values and determine whether an IF function in ... View the full answer