Quiz for Lesson 8 April 9, 2025 by matthew531@msn.com Most Used Functions 1. What symbol does the COUNTIF function use to match a series of characters? A) ? B) # C) * 2. What does the SUMPRODUCT function do? A) Finds the maximum value in a range B) Calculates the total number of products C) Calculates the sum of the products of corresponding numbers in one or more ranges 3. What does the IF function do in Excel? A) Checks if a condition is met and returns one value if true, another if false B) Returns the sum of values based on a condition C) Calculates the average of a range 4. Which function would you use to count the number of cells that contain numbers? A) COUNTIF B) COUNT C) COUNTA 5. Which function allows you to search for a value in the first column of a table and return a value in the same row from another column? A) VLOOKUP B) MATCH C) INDEX 6. Which Excel function returns the average of selected numbers? A) SUMIF B) AVERAGE C) COUNT Your score is 0% Restart quiz
