Microsoft Excel Functions 3 — Questions and Answers
Question 1: What does the CONCATENATE function (or & operator) do in Excel?
- Splits text into multiple cells
- Joins multiple text strings into one (Correct answer)
- Counts characters in a cell
- Formats text as a number
Correct answer: Joins multiple text strings into one
CONCATENATE joins two or more text strings into a single string; the & operator achieves the same result.
Question 2: Which function counts only the cells in a range that are not empty?
- COUNT
- COUNTA (Correct answer)
- COUNTBLANK
- COUNTIF
Correct answer: COUNTA
COUNTA counts all non-empty cells, including those with text, numbers, or errors.
Question 3: What does the NOW() function return?
- Only the current date
- Only the current time
- The current date and time (Correct answer)
- The current year
Correct answer: The current date and time
NOW() returns the current date and time as a serial number formatted as a date and time.
Question 4: Which Excel function finds a value in the first column of a table and returns a value in the same row from another column?
- HLOOKUP
- VLOOKUP (Correct answer)
- XLOOKUP
- INDEX
Correct answer: VLOOKUP
VLOOKUP (Vertical Lookup) searches the first column of a range and returns a value from a specified column in the same row.
Question 5: What is the purpose of the ABS function?
- Returns the absolute (positive) value of a number (Correct answer)
- Rounds a number to the nearest integer
- Returns the square root of a number
- Converts a number to text
Correct answer: Returns the absolute (positive) value of a number
ABS returns the absolute value of a number, removing any negative sign.
Question 6: Which function returns the remainder after dividing one number by another?
- DIV
- REMAIN
- MOD (Correct answer)
- QUOTIENT
Correct answer: MOD
MOD returns the remainder when the first argument is divided by the second argument.
Question 7: What does the TRIM function do?
- Removes all spaces from text
- Removes leading and trailing spaces and reduces internal spaces to one (Correct answer)
- Truncates text to a specified length
- Removes special characters from text
Correct answer: Removes leading and trailing spaces and reduces internal spaces to one
TRIM removes leading and trailing spaces and reduces multiple consecutive spaces between words to a single space.
Microsoft Excel Functions 3
What does the CONCATENATE function (or & operator) do in Excel?