Which of the following is a valid way to create Sets in Tableau?

• A.In the Data pane, right-click a dimension and select Create > Set.
• B.In the Tableau Main Menu, Choose Worksheet and select Create > Set
• C.In the Tableau Main Menu, choose Dashboard and select Create > Set
• D.In the Data pane, right-click a measure and select Create > Set.

Correct Answer: A

Explanation
There are two types of sets: dynamic sets and fixed sets. The members of a dynamic set change when the underlying data changes. Dynamic sets can only be based on a single dimension.
To create a dynamic set:
1) In the Data pane, right-click a dimension and select Create > Set.
2) In the Create Set dialog box, configure your set. You can configure your set using the following tabs:
General: Use the General tab to select one or more values that will be considered when computing the set.
You can alternatively select the Use all option to always consider all members even when new members are added or removed.

None of the other options exist, and therefore are incorrect answers.

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes the best way to change the formatting at a workbook level?

• A.Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane.
• B.It is only possible to specify formatting at a worksheet level, not at the workbook level.
• C.Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane.
• D.Choose Format from the menu on top and then specify the formatting in the new Format workbook pane.

Correct Answer: D

It is very much possible to specify the formatting at a WORKBOOK level (all sheets) instead of a single worksheet level.
You can quickly change how fonts, titles, and lines look in every view in a workbook by specifying format settings at the workbook level, instead of the worksheet level.
For example, you might want to use a specific font, size, and color so that all views adhere to your company's brand. You might also want to remove grid lines from your views-or make them more noticeable by increasing their pixel size or color.
You can also change the theme used by your workbook. Themes control items like the default font, colors, and line thickness. When you create a new workbook, it automatically uses the Default theme, which uses visual best practices.
Change fonts in your workbook:
You can change all fonts in your workbook or you can change fonts for only certain areas, such as just worksheet titles.
1) On the Format menu, select Workbook.
2) The Format Workbook pane replaces the Data pane on the left and provides a series of drop-down lists where you can change all font settings in a workbook, as well as the font settings for titles of worksheets, stories, and dashboards.

Note: If you have made font changes at the worksheet level, such as on a filter card or a worksheet title, changing the font at the WORKBOOK level will overwrite those changes.

Reset a workbook to its default settings
When you make changes to your workbook's font settings, a gray dot appears next to the setting in the Format Workbook pane. You can quickly switch back to default settings using the Reset to Defaults button.
1) On the Format menu, select Workbook.
2) In the Format Workbook pane, click Reset to Defaults.
Graphical user interface, application Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

What two methods can you use to change the font of a worksheet title? Choose two.

• A.Double-click the title in a particular view and use the dialog box.
• B.Right-click the title in a view, and then select Format Title.
• C.Select Format on the menu, and then select Font.
• D.Select Format on the menu, and then select Title and Caption.

Comment: *

Name: *

Email: *

Verification: *

Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)

• A.76.25
• B.65.67
• C.68.77
• D.4.87

Correct Answer: A

Pretty common question on the Tableau Desktop Specialist exam.
1) First, lets create Sheet 1. For this, drag sport to the Row shelf, and Weight to the Text mark in the Marks shelf. Change its aggregation to Average:

2) Now, for sheet 2 - Drag nationality to the view, and gold to the size mark in the Marks shelf.
NOTE: Depending on your version of Tableau , you may need to assign a Geographical role to the nationality column first as follows:


3) Now, let's create a dashboard, and use both these sheets in it:

4) Now, for the most Important step, use SHEET 2 AS A FILTER FOR SHEET 1 as follows:

Now simply click on Russia in Sheet 2, and Sheet 1 will automatically update as follows:

Comment: *

Name: *

Email: *

Verification: *

What are three ways to access bolding options for the text in a tooltip? Choose three.

• A.Select Tooltip on the Marks card.
• B.Select Format on the menu, and then select Font
• C.Select Worksheet on the menu, and then select Tooltip
• D.Hover over a mark and press CTRL+B.
• E.Hover over a mark and press ALT+F.
• F.Right-click on the Field and select Format.

Comment: *

Name: *

Email: *

Verification: *