Microsoft Excel 2021365 - Beginner to Advanced - Exercise 02 - work on the UNIQUE function

This video tutorial guides students through exercises on dynamic array functions, including unique, filter, sort, X lookup, and Rand array functions. It covers creating data validation lists, filtering and sorting data, and generating dummy data. The tutorial provides a detailed walkthrough of each exercise, ensuring students understand the application of these functions in practical scenarios.

What is the primary purpose of using the unique function in the first worksheet?

• To extract a list of months with duplicates

• To extract a list of unique months

• To extract a list of all months

• To extract a list of months in alphabetical order

Which function is used to create a drop-down list with unique values?

• SORT

• FILTER

• UNIQUE

• XLOOKUP

What should be displayed if the FILTER function returns no results?

• No Data

• Empty

• No Records

• Zero

Which function is used to retrieve the team, revenue, and profit for a selected sales agent?

• FILTER

• UNIQUE

• XLOOKUP

• RANDARRAY

What is the purpose of using the RANDARRAY function in this exercise?

• To sort data

• To validate data

• To filter data

• To generate dummy data

How do you ensure that the unique function returns only items that appear exactly once?

• By using a SORT function

• By using a COUNT function

• By using a TRUE argument

• By using a FALSE argument

What is the role of the COUNTA function in counting unique months?

• To count only empty cells

• To count all cells with text

• To count only numeric values

• To count only cells with formulas

Which operator is used to filter data for multiple criteria using the FILTER function?

• AND

• OR

• PLUS

• MULTIPLY

How do you sort the results in ascending order by Sales Agent using a formula?

• By using the UNIQUE function

• By using the FILTER function

• By using the SORT function

• By using the XLOOKUP function

Where should the total profit for Claire in March be entered?

• Cell P4

• Cell I4

• Cell B5

• Cell G5