Quiz for Lesson 9

May 27, 2025 by matthew531@msn.com

Formulas and Functions

1. How can you quickly copy a formula from one cell to another?

A) Use the drag-and-drop method

B) Manually type the formula again

C) Change the cell formatting

2. How can you insert a function in Excel?

A) Use the Insert Function button

B) Open a new worksheet

C) Click the Review tab

3. What symbol is used at the beginning of a formula in Excel?

A) #

B) $

C) =

4. What does Excel do when you change a cell that is part of a formula?

A) It ignores the change

B) It recalculates the formula’s result automatically

C) It erases the formula

5. What does the COUNTIF function do?

A) Counts the total number of cells

B) Counts cells that meet a specific condition

C) Adds the values of all cells

6. When copying a formula, what does Excel automatically adjust?

A) Font size

B) Cell references

C) Worksheet color

7. What is the correct order of operations in Excel (operator precedence)?

A) Multiplication and division first, then addition and subtraction

B) Addition and subtraction first, then multiplication and division

C) Operations are performed from left to right without precedence

8. What is the correct formula format for using a function in Excel?

A) =Function[Arguments]

B) Function=Arguments

C) =Function(Arguments)

Your score is