Exam TDA-C01 All QuestionsBrowse all questions from this exam
Question 64

You have a dataset that contains people and the awards they have won.

Which formula should you use to get the number of people who won an award?

    Correct Answer: E

    To get the number of people who won an award, you need a formula that counts the unique names in the dataset. Since some individuals have won more than one award, they will appear multiple times in the list. The COUNTD([Name]) function counts distinctive or unique names, ensuring each person is counted only once regardless of the number of awards they have won.

Discussion
iccent2Option: E

Answer is correct. You need the distinct count because some winners appear more than once.