Quiz for Lesson 7 April 9, 2025 by matthew531@msn.com Formulas and Functions 1. What happens when you change the value of a cell that is used in a formula? A) The result remains the same B) Excel deletes the formula C) The formula result updates automatically 2. What does Excel do when you copy and paste a formula to a new location? A) It keeps the exact same cell references B) It automatically adjusts the cell references C) It replaces the formula with a value 3. Where can you see or edit a formula for a selected cell? A) In the cell name box B) In the Home tab C) In the formula bar 4. What is the purpose of the COUNTIF function in Excel? A) To count all blank cells B) To count the number of formulas C) To count the number of cells matching a condition 5. What symbol must you type first to enter a formula in Excel? A) + B) = C) : 6. Which Excel feature helps you insert a function if you’re unsure of the name or syntax? A) Insert Function B) Function Generator C) AutoCorrect 7. What does the SUM function do in Excel? A) Multiplies selected cells B) Adds the values in a range of cells C) Divides selected cells 8. What part of a formula is calculated first in Excel? A) Operations inside parentheses B) Addition and subtraction C) Formulas typed last Your score is 0% Restart quiz
