Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What does the UNIQUE function return?

  1. A A spilled list of distinct values from a range
  2. B The count of unique values
  3. C The first value in a range
  4. D A sorted range
Answer

A spilled list of distinct values from a range

UNIQUE combined with SORT and FILTER replaces much of what previously required PivotTables or advanced filters.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as