QUESTION 13
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

QUESTION 14
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?

QUESTION 15
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?

QUESTION 16
You have the following tiled dashboard that has one sheet.

You want to replace fit sheet with Sheet2.
What should you do?

QUESTION 17
You have the following dataset in Microsoft Excel.

You are using interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

QUESTION 18
Open the link to Book1 found on the desktop. Open the Line worksheet.
Modify the chart to show only main and max values of both measures in each region.

QUESTION 19
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.

QUESTION 20
You have the following dataset.

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

QUESTION 21
You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?

QUESTION 22
Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.
Replace the existing data source with the Netflix_2019 data source.

QUESTION 23
You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

QUESTION 24
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.

QUESTION 25
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

QUESTION 26
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.

QUESTION 27
You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?