Microsoft Excel Functions 3

Question 1

What does the CONCATENATE function (or & operator) do in Excel?

Accepted Answer

Joins multiple text strings into one

Answer

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?

Accepted Answer

COUNTA

Answer

COUNTA counts all non-empty cells, including those with text, numbers, or errors.

Question 3

What does the NOW() function return?

Accepted Answer

The current date and time

Answer

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?

Accepted Answer

VLOOKUP

Answer

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?

Accepted Answer

Returns the absolute (positive) value of a number

Answer

ABS returns the absolute value of a number, removing any negative sign.

Excel Practice Test