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; and G4 = 2.
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; and G4 = 2.
1. C2 , H12 Returned value: _______________________
2. L3 5 G4 Returned value: _______________________
3. M14 1 15 * H12 / 10 ,5 L3 Returned value: _______________________
4. M14 1 G4 < H12 / C2 Returned value: _______________________
5. (C2 1 H12) * 2 .5 L3 – (L3 / 4) * 2 Returned value: _______________________
6. L3 1 300 . H12 * G4 1 10 Returned value: _______________________
7. G4 * M14 .5 2 * (M14 2 25) Returned value: _______________________
8. H12 5 10 * (C2 1 8) Returned value: _______________________
Instructions Part 2: Write cell L23 as a relative reference, absolute reference, mixed reference with
the column varying, and mixed reference with the row varying.
_____________ ______________ _____________ _____________
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
