Exam TDA-C01 All QuestionsBrowse all questions from this exam
Go to Exam
Question 52

You have the following chart that sorts states by the number of products each state has purchased.

Which formula should you use to Include a number with the position of each state within each region?

    Correct Answer: C

    To include a number with the position of each state within each region, the correct formula to use is INDEX(). INDEX() provides the position of each row in the partition, which can be modified and reset based on the region in this case. This way, each state will be assigned a unique position number within its respective region.

Discussion
MonBoujOption: C

C. INDEX()

MonBouj

sorry it should be B B. LOOKUP(SUM([Quantity]))

88c0ad8Option: C

It's INDEX()