Home Blog Tableau Certification Questions – Calculations (Part 5)

Tableau Certification Questions – Calculations (Part 5)

December 22, 2020

2896

In this series of Tableau Certification Questions for Tableau Desktop Certification exams, we will discuss Calculations in Tableau. The purpose of this Tableau Exam Questions part-5 is to explore Tableau Calculations targeting the Tableau Desktop Specialist or Certified/Qualified Associate exams. We have provided a complete step by step solution for each exam question at the end with the correct answer. Check out our detailed Tableau Certification Preparation Training Videos from Tableau Certified Professionals to explore further questions and tips for passing the exam on the first attempt.

We are providing the complete Tableau Certification Dumps and Practice Tests to validates Tableau Data Visualization skills.

Tableau Certification Practice Tests:

Tableau Certification Questions List:

Let’s dive into Tableau Certification Questions related to Tableau Calculations in Tableau.

Question 1:

What is the movie name that starts with the letter ‘T’ and when sorted on the sum of profitability in descending order comes in fourth place.

Note: Use Hollywood’s Most Profitable Stories Sample Data

A) The Twilight Saga: The Moon
B) Twilight
C) The Proposal
D) Twilight: Breaking Down

Correct Answer: D

Checkout Solution:

1. Create a calculation field first letter.

2. Put sum of profitability to Columns and Film on Rows.

3. Put the calculated field ‘first letter’ in filter shelf and select ‘T’.

4. It will look like this below:

From here you can identify that fourth record is Twilight: Breaking Down

Question 2:

Using Orders sheet is Sample-Superstore , Find out what is percentage of sales for customer segment ‘Corporate’ in year 2012 where product category is Furniture.

Note: Use Superstore Sample Data

Choose the correct option:

A) 38.20 %
B) 20.38 %
C) 25.65 %
D) 34.35 %

Correct Answer: A

Check out the Solution:

1. Put customer segment on rows shelf.

2. Put Product Category on Filter and select ‘Furniture’ as shown below:

3. Put Order Date on Filter and select 2012.

4. Now Put Sales on Text in the Marks Card.

5. Now select Sales in the Marks Card, Right Click and select the Option ‘Percentage of Total’.

6. It shows that Percentage of customer segment ‘Corporate’ for selected parameters in 38.20 %.

Fundamentals of Visualization with Tableau

University of California via Coursera
11 hours of effort required
111,158+ already enrolled!
★★★★★ (4,671 Ratings)

Data Visualization and Communication with Tableau

Duke University via Coursera
25 hours of effort required
175,244+ already enrolled!
★★★★★ (2,852 Ratings)

Tableau A-Z: Hands on Tableau Training for Data Science

Kirill Eremenko via Udemy
9 hours on demand videos
230,147+ already enrolled!
★★★★★ (60,907 ratings)

Question 3:

Using Orders Sheet in Sample Super Store, Find the total sales of orders that took 3 days for ‘Express Air’ shipping mode.

Note: Use Superstore Sample Data

A) 37458
B) 37854
C) 37800
D) 37900

Correct Answer: A

Checkout the Solution:

1. Create Calculated Field as:

2. Convert it to Dimension.

3. Put Dimension ‘Delivery Days’ on Filter and select 3.

4. Put Shipping Mode in Filter and select the option.

5. Now Put Sales on Text in the Marks Card.

It will show the Sales Value 37458.

Tableau Certification Practice Tests:

Get access to 19 Tableau Training Videos explaining 19 different questions including Tableau Calculations in detail by Tableau Certified Professional.

Stay in touch for the next part in this series for Tableau Certification questions related to Mapping.

Related Articles:

Tableau Certification Questions – Calculations (Part 5)

Tableau Certification Practice Tests: