1. Which of the following formulas returns the smallest of the numbers in cells E1,E2,E3,E4, E5, E6, and E7. a. =MIN(E1;E7) b. =MIN(E:E7) c. =MAX(E1:E7) d. =MAX(E1;E7) 2. =Which of the following is the equivalent of B4+B5+B6+B7 ? a. =SUM(B4:B7) b. =SUM(B4;B7) c. =SM(B4+B7) d. None 3. =IF(D4>80, "PASS", "FAIL") What must D4 be in order to write PASS in the function? a. 19 b. 80 c. 88 d. 60 4. Which of the following is not a logical function? a. AVERAGE b. AND c. OR d. IF