Q47. 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.

Q48. 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?

Q49. Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.

Q50. You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?

Q51. You have the following dataset.

Which grouping option should you use m Tableau Prep to group al five names automatically?

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

Q53. 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.

Q54. You create a parameter named Choose Region fiat contains values from a field named Region.
You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regions What should you do next?

Q55. You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?

Q56. You have the following dataset

You need to create the following visualization.

Which quick table calculation should you drag to Text on the Marks card?

Q57. You have the following tiled dashboard that has one sheet.

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

Q58. 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%.

Q59. Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.

Q60. You create a parameter named Choose Region fiat contains values from a field named Region.
You want users to be able to use the Choose Region parameter to interact with a chart by logging between different regions What should you do next?

Q61. in which three formats can you export a worksheet from the Worksheet menu? Choose three

Q62. Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.

Q63. 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?

Q64. A colleague provides you with access to a folder that contains the following files:
* Sates.csv
* Bookl.twb
* Sates.hyper
* Export.mdb
Which He contains an extract?

Q65. You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?

Q66. Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.