MOS Excel: Formulas and Functions 2 — Questions and Answers
Question 1: Which function returns the number of characters in a text string?
- COUNT
- LEN (Correct answer)
- TEXT
- FIND
Correct answer: LEN
LEN returns the number of characters in a text string, including spaces.
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 catches the division-by-zero error and returns the specified value "Error" instead.
Question 3: Which function finds the position of a substring within a text string, case-insensitively?
- SEARCH (Correct answer)
- FIND
- MATCH
- LOCATE
Correct answer: SEARCH
SEARCH is case-insensitive and returns the position of a substring, while FIND is case-sensitive.
Question 4: What result does =ROUND(2.567, 2) produce?
- 2.5
- 2.56
- 2.57 (Correct answer)
- 3
Correct answer: 2.57
ROUND(2.567, 2) rounds to 2 decimal places, and the third decimal (7) rounds up the second decimal from 6 to 7.
Question 5: A formula uses the range name 'SalesData'. What type of reference is this?
- Relative reference
- Absolute reference
- Named range reference (Correct answer)
- Mixed reference
Correct answer: Named range reference
Named ranges provide a descriptive label for a cell or range that acts like an absolute reference and is easier to read.
Question 6: Which function calculates the sum of values that meet a single condition?
- SUMPRODUCT
- SUMIF (Correct answer)
- COUNTIF
- AVERAGEIF
Correct answer: SUMIF
SUMIF sums values in a range that satisfy a single specified condition.
Question 7: What does the $ symbol do in the cell reference $B$4?
- Converts the value to currency
- Makes both the column and row absolute (Correct answer)
- Makes only the column absolute
- Locks the sheet reference
Correct answer: Makes both the column and row absolute
Placing $ before both the column letter and row number locks both, creating a fully absolute reference that does not change when copied.
MOS Excel: Formulas and Functions 2
Which function returns the number of characters in a text string?