Apply Your Knowledge Reinforce the skills and apply the concepts you learned in this module. 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 5 G4 3. M14 1 15 * H12 / 10 ,5 L3 4. M14 1 G4 < H12 / C2 5. (C2 1 H12) * 2 .5 L3 – (L3 / 4) * 2 6. L3 1 300 . H12 * G4 1 10 7. G4 * M14 .5 2 * (M14 2 25) 8. H12 5 10 * (C2 1 8) Returned value: _______________________ Returned value: _______________________ Returned value: _______________________ Returned value: _______________________ Returned value: _______________________ Returned value: _______________________ Returned value: _______________________ Returned value: _______________________