Which of the following returns the Absolute Value of a given number?

• A.ABS(Number)
• B.CEILING(Number)
• C.FLOOR(Number)
• D.ZN(Number)

Correct Answer: A

Explanation
From the official Tableau website:

Comment: *

Name: *

Email: *

Verification: *

You want to add Custom shapes to your visualisation. Where can you add these new shapes?

• A.In Downloads -> My Tableau Repository -> Shapes
• B.In My Computer -> C: -> Tableau -> Shapes
• C.In Program Files -> Tableau -> Shapes
• D.In My Documents -> My Tableau Repository -> Shapes

Comment: *

Name: *

Email: *

Verification: *

How would you calculate GDP per capita in Tableau?

• A.SUM([GDP]/[POPULATION])
• B.SUM([Population]/[GDP]])
• C.SUM([GDP]*[POPULATION])
• D.SUM([GDP]) / SUM([Population])

Correct Answer: D

Explanation
GDP / Population = GDP Per Capita

Here Sum is a function, / and + are operators. On the bottom there are comments.

Comment: *

Name: *

Email: *

Verification: *

Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

• A.Tom Ashbrook
• B.Sanjit Engle
• C.Penelope Sewall
• D.Tamara Chand

Correct Answer: C

Explanation
As the question mentions, we need to create a SET with the following conditions -> Choose only those customers whose Sales > 30,000
1) Right click on customer name --> Create --> Set

2) Let's Name the Set - Customer>30k ( you can name it anything you want :) ) Select USE ALL, and then move to the CONDITION TAB:

3) In the Condition Tab, Choose BY FIELD -> Select Sales -> Sum -> Greater than 30000 , and click OK

4) You should now have a new Set in the Data Pane as follows:

5) Drag this set to the rows shelf, and click on SHOW MEMBERS IN SET. Now drag Sales to the Column Shelf.

6) Click on the Show Mark Labels, and Sort ascending icons as shown:

7) Voila! We have our answer:
c

Comment: *

Name: *

Email: *

Verification: *

True or False: The Highlighting action can be disabled for the entire workbook.

• A.True
• B.False

Correct Answer: A

Explanation
Yes, it is possible to disable highlighting for the entire workbook.

For more information : https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm

Comment: *

Name: *

Email: *

Verification: *