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?
TDA-C01 Exam QuestionsBrowse all questions from this exam
TDA-C01 Exam - Question 64
Show AnswerHide Answer
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
1 commenticcent2Option: E
May 29, 2024Answer is correct. You need the distinct count because some winners appear more than once.