Quiz for Lesson 10 May 27, 2025 by matthew531@msn.com Most Used Functions 1. Which functions are used to find the minimum and maximum values in a range? A) SUM and AVERAGE B) INDEX and MATCH C) MIN and MAX 2. What does the SUMPRODUCT function do? A) Multiplies all numbers in a range B) Multiplies and sums matching numbers in one or more ranges C) Adds only positive numbers in a range 3. What is the purpose of the VLOOKUP function? A) Looks up a value in a row and returns data from a different row B) Looks up a value in the first column and returns data from a specified column C) Looks up a value in a column and returns a color 4. What does the IF function return if a condition is true? A) It returns False B) It returns True C) It returns a specified value if true and another if false 5. What does the COUNTIF function do? A) Counts cells based on a specific condition B) Counts only blank cells C) Adds the values of cells that match a condition 6. What does the COUNT function do in Excel? A) Counts the number of cells that contain numbers B) Counts the total number of cells in a range C) Counts the number of cells containing text 7. Which function would you use to find the sum of a range of cells? A) SUM B) AVERAGE C) COUNTIF Your score is 0% Restart quiz
