Home / Expert Answers / Computer Science / apply-your-knowledge-reinforce-the-skills-and-apply-the-concepts-you-learned-in-this-module-underst-pa723

# (Solved): Apply Your Knowledge Reinforce the skills and apply the concepts you learned in this module. Underst ...

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

We have an Answer from Expert