TDA-C01 Practice Test practice questions, page 5 of 9, with answer review and explanations.
Question 21
You have the following dataset. When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table. What should you do?
Change the default number format of the Sales field.
Create a calculated field that uses a formula of '#39; + str (Round([Sales],2)) + 'K'.
Create a calculated field that uses a formula of' '#39; + str (([Sales]/1000)).
Change the data type of the Sales field to String.
Question 22
You have the following map. You need the map to appear as shown in the following visualization. What should you do?
Change the mark type to Density.
Drag Location to Size on the Marks card.
Change the mark type to Map.
Drag Population to Size on the Marks card.
Change the opacity to 75%.
Question 23
You have a dataset that contains people and the awards they have won. Which formula should you use to get the number of different types of awards that have been won?
COUNTD([NAME])
COUNTD([Award])
MAX([Award])
COVAR ([Award])
INDEX()
Question 24
You have the following visualization. You want the count of Returns displayed only for the first year in the table. How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Question 25
You have the following bar chart. You want the chart to appear as shown in the following exhibit. What should you add?