Microsoft Excel 2021365 - Beginner to Advanced - Unique Versus Distinct

The video tutorial explains the difference between extracting unique and distinct values in Excel. Distinct values are all entries from the source data shown once, while unique values are those that appear only once. The tutorial demonstrates using the UNIQUE function to extract both distinct and unique lists, highlighting the use of arguments to specify the desired output. The process includes setting up a data table and selecting the appropriate arguments to achieve the desired list of values.

What is the main difference between distinct and unique values?

• Unique values are repeated entries.

• Distinct values appear only once in the data.

• Unique values are all entries shown once.

• Distinct values are all entries shown once.

What is the first step in setting up data for extracting distinct values?

• Naming the table.

• Choosing a table style.

• Putting data into a table.

• Selecting the range of data.

Which argument is used in the UNIQUE function to extract distinct values?

• TRUE

• FALSE

• NULL

• ZERO

When extracting unique values, which argument should be used in the UNIQUE function?

• TRUE

• ZERO

• NULL

• FALSE

What is the result when using the TRUE argument in the UNIQUE function?

• All entries are shown once.

• Only entries that appear once are shown.

• All entries are shown multiple times.

• No entries are shown.