The following data is entered in the cells of an Excel sheet ranging from L1 to 1.5: 16, 9, 11, 15, 12. What will be the output of the following function? =AVERAGEIF(L 1:L5, >13" a. 7,5 b.8.6 C. 15.5 d. 17.3 e. 18.5 QUESTION 7 The function that will return the number of items in a range that meet a certain criteria is: a. COUNTIE b. HLOOKUP MEDIAN d. OR e. SUMIF QUESTION 8 If the [Range-lookup) argument of the VLOOKUP function is defined with the word TRUE, the function will look for a value that is an exact match or the closest match that is more than the lookup value True False