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 =...

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.

_____________  ______________  _____________  _____________

Extracted text: Understanding Logical Tests and Absolute Cell Referencing Note: To complete this assignment, you will be required to use the Data Files. Please contact your instructor for information about accessing the Data Files. 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="" 2.="" l3="G4" returned="" value:="" returned="" value:="" 3.="" m14="" +="" 15="" *="" h12="" 10=""><= l3="" returned="" value:="" 4.="" m14="" +="" g4="L3" –="" (l3="" 4)="" *="" 2="" 6.="" l3="" +="" 300="">H12 * G4 + 1Ó 7. G4 * M14 >= 2 * (M14 – 25) 8. H12 = 10 * (C2 + 8) Returned value: Returned value: Returned value: 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.