Microsoft Excel Formulas 2 — Questions and Answers
Question 1: Which function returns the position of a value within a range?
- FIND
- MATCH (Correct answer)
- SEARCH
- INDEX
Correct answer: MATCH
MATCH returns the relative position of a value within a one-dimensional range.
Question 2: What does the formula =IFERROR(A1/B1, "Error") return when B1 is 0?
- 0
- #DIV/0!
- Error (Correct answer)
- FALSE
Correct answer: Error
IFERROR returns the second argument whenever the first argument produces any error, including #DIV/0!.
Question 3: Which of the following is a valid absolute cell reference in a formula?
- A1
- $A1
- $A$1 (Correct answer)
- A$
Correct answer: $A$1
$A$1 locks both the column and row so the reference doesn't change when copied.
Question 4: What result does =MOD(17, 5) return?
- 3
- 2 (Correct answer)
- 3.4
- 1
Correct answer: 2
MOD returns the remainder after division; 17 ÷ 5 = 3 remainder 2.
Question 5: Which function counts only the cells in a range that contain numbers?
- COUNTA
- COUNTIF
- COUNT (Correct answer)
- COUNTBLANK
Correct answer: COUNT
COUNT tallies only numeric values, ignoring text, blanks, and errors.
Question 6: The formula =LEFT("PracticeTest", 8) returns which string?
- Practice (Correct answer)
- TestGeek
- PracticeT
- racticeT
Correct answer: Practice
LEFT extracts 8 characters from the start of the text string, yielding "Practice".
Question 7: What happens when you enter a formula that creates a circular reference in Excel?
- Excel deletes the formula automatically
- Excel returns zero by default
- Excel displays a warning and may return 0 or an error (Correct answer)
- Excel solves it using Goal Seek
Correct answer: Excel displays a warning and may return 0 or an error
By default Excel warns the user about circular references and typically shows 0 unless iterative calculation is enabled.
Microsoft Excel Formulas 2
Which function returns the position of a value within a range?