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?
Exam TDA-C01 All QuestionsBrowse all questions from this exam
Question 21
Correct Answer: A
To format the Sales field to show values automatically in the desired format (e.g., $44K for 43,971), changing the default number format of the Sales field is the appropriate action. This approach allows you to customize the display without altering the underlying data, ensuring all values are presented uniformly and correctly. Creating calculated fields or converting data types would not achieve the same straightforward and consistent result.
Discussion
JUT_TCOption: A
A- change the sales field in the data pane suing the default properties for number format.
ZabbaOption: A
B will not work because it rounds to only 2 digits, but some of the values are 3 digits. C will not work because it will not append the 'K'. D will not work because converting to string would only convert the numeric data type into a string with the same value. A is the correct answer.
MonBoujOption: A
A. Change the default number format of the Sales field
VedjhaOption: A
A is correct. we can achieve it through calculated field as well but it will add new measure/dimension