EXCEL Practice Test: Video 2 Answers (25 Questions)

Question 1

What does the UNIQUE function do in Excel 365?

Accepted Answer

Extracts distinct values from a range as a dynamic array

Answer

UNIQUE returns a dynamic array of distinct values, removing duplicates.

Question 2

What does the TEXT function do?

Accepted Answer

Formats a number as text using a format code

Answer

TEXT converts a numeric value to text with a specific format.

Question 3

How does AVERAGEIFS calculate its result?

Accepted Answer

Averages values where all corresponding criteria are met

Answer

AVERAGEIFS averages values in a range only where ALL corresponding criteria are satisfied.

Question 4

What is the difference between relative and absolute cell references?

Accepted Answer

Relative adjust when copied, absolute (with $) stay fixed

Answer

Relative references adjust when copied; absolute references ($A$1) remain fixed.

Question 5

Which option should you choose when you want a query's results available for other queries but do not want a table placed on any worksheet?

Accepted Answer

Only Create Connection

Answer

Connection-only queries exist without loading output to the workbook.

Excel Practice Test