Formulas Flashcards
7 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Formulas flashcards as text
Which function returns the position of a value within a range?
Answer: MATCH
MATCH returns the relative position of a value within a one-dimensional range.
What does the formula =IFERROR(A1/B1, "Error") return when B1 is 0?
Answer: Error
IFERROR returns the second argument whenever the first argument produces any error, including #DIV/0!.
Which of the following is a valid absolute cell reference in a formula?
Answer: $A$1
$A$1 locks both the column and row so the reference doesn't change when copied.
What result does =MOD(17, 5) return?
Answer: 2
MOD returns the remainder after division; 17 ÷ 5 = 3 remainder 2.
Which function counts only the cells in a range that contain numbers?
Answer: COUNT
COUNT tallies only numeric values, ignoring text, blanks, and errors.
The formula =LEFT("PracticeTest", 8) returns which string?
Answer: Practice
LEFT extracts 8 characters from the start of the text string, yielding "Practice".
What happens when you enter a formula that creates a circular reference in Excel?
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.