TABLEAU
### Introduc on to Tableau
1. **What is Tableau primarily used for?**
- A) Data storage
- B) Data visualiza on
- C) Data mining
- D) Data entry
- **Answer: B**
2. **Which Tableau product is used for crea ng dashboards and reports?**
- A) Tableau Reader
- B) Tableau Server
- C) Tableau Desktop
- D) Tableau Public
- **Answer: C**
3. **What is Tableau Public?**
- A) A tool for crea ng visualiza ons for private use
- B) A tool for crea ng and sharing visualiza ons publicly
- C) A tool for crea ng visualiza ons on mobile devices
- D) A tool for managing data sources
- **Answer: B**
4. **Which Tableau product allows users to view and interact with visualiza ons but not create
them?**
- A) Tableau Desktop
- B) Tableau Server
- C) Tableau Reader
- D) Tableau Public
- **Answer: C**
5. **How does Tableau connect to data?**
- A) By using SQL scripts
- B) Through built-in data connectors
- C) By impor ng data files manually
- D) By using Excel formulas
- **Answer: B**
6. **Which Tableau product is designed for enterprise-level data analy cs and collabora on?**
- A) Tableau Desktop
- B) Tableau Server
- C) Tableau Reader
- D) Tableau Public
- **Answer: B**
7. **What file format does Tableau use to save workbooks?**
- A) .xlsx
- B) .docx
- C) .twbx
- D) .pdf
- **Answer: C**
8. **Which feature in Tableau allows for real- me data analysis?**
- A) Data Extracts
- B) Live Data Connec ons
- C) Data Blending
- D) Data Aggrega on
- **Answer: B**
9. **What is a Tableau workbook?**
- A) A collec on of related data sources
- B) A collec on of visualiza ons and dashboards
- C) A database file
- D) A spreadsheet document
- **Answer: B**
10. **Which type of visualiza on is not supported in Tableau?**
- A) Bar chart
- B) Line chart
- C) Pie chart
- D) Pivot table
- **Answer: D**
11. **What is the purpose of Tableau's Show Me feature?**
- A) To format data tables
- B) To suggest suitable visualiza ons based on selected data
- C) To connect to data sources
- D) To publish visualiza ons online
- **Answer: B**
12. **How can you share Tableau visualiza ons with others?**
- A) By expor ng as a PDF
- B) By sharing the Tableau workbook file
- C) By publishing to Tableau Server or Tableau Public
- D) All of the above
- **Answer: D**
### Data Sources in Tableau
13. **Which of the following is a valid data source in Tableau?**
- A) Microso Excel
- B) Google Sheets
- C) SQL databases
- D) All of the above
- **Answer: D**
14. **What is data blending in Tableau?**
- A) Combining data from mul ple worksheets
- B) Combining data from different data sources
- C) Merging data within a single data source
- D) Spli ng data into mul ple parts
- **Answer: B**
15. **Which connec on type in Tableau allows for real- me data updates?**
- A) Data Extract
- B) Live Connec on
- C) Cached Connec on
- D) Sta c Connec on
- **Answer: B**
16. **How can you combine data from mul ple tables in Tableau?**
- A) By using joins
- B) By using blends
- C) By using unions
- D) All of the above
- **Answer: D**
17. **Which type of join is not available in Tableau?**
- A) Inner join
- B) Le join
- C) Right join
- D) Cross join
- **Answer: D**
18. **What is a data extract in Tableau?**
- A) A snapshot of data taken from a live connec on
- B) A live connec on to the data source
- C) A combina on of mul ple data sources
- D) A data visualiza on file
- **Answer: A**
19. **How do you refresh a data extract in Tableau?**
- A) By reopening the workbook
- B) By clicking on the Refresh Extract bu on
- C) By re-impor ng the data
- D) By duplica ng the data source
- **Answer: B**
20. **Which data source type is primarily used for big data in Tableau?**
- A) Text files
- B) Excel files
- C) SQL databases
- D) Hadoop
- **Answer: D**
21. **How can you connect Tableau to a web data connector?**
- A) Through the Data menu
- B) By impor ng a CSV file
- C) By using the Web Data Connector op on
- D) By wri ng a custom script
- **Answer: C**
22. **What does the Tableau Data Interpreter do?**
- A) Cleans and organizes Excel data
- B) Translates text to mul ple languages
- C) Converts SQL queries to Tableau visualiza ons
- D) Formats data tables for be er visualiza on
- **Answer: A**
23. **Which Tableau feature allows for integra on with R and Python?**
- A) Data Interpreter
- B) Data Blending
- C) Tableau Extensions
- D) Tableau Prep
- **Answer: C**
24. **What type of data source is used when working with geospa al data in Tableau?**
- A) Excel files
- B) CSV files
- C) SQL databases
- D) Shapefiles
- **Answer: D**
### Taxonomy of Data Visualiza on
25. **Which type of chart is best for showing trends over me?**
- A) Bar chart
- B) Line chart
- C) Pie chart
- D) Sca er plot
- **Answer: B**
26. **What is the primary purpose of a heat map?**
- A) To show geographical data
- B) To show rela onships between variables
- C) To represent data values with color intensity
- D) To display hierarchical data
- **Answer: C**
27. **Which chart type is best for comparing parts of a whole?**
- A) Line chart
- B) Sca er plot
- C) Pie chart
- D) Histogram
- **Answer: C**
28. **What does a sca er plot display?**
- A) The frequency of data points
- B) The rela onship between two numerical variables
- C) The distribu on of a single variable
- D) The parts of a whole
- **Answer: B**
29. **Which type of visualiza on is used to show the distribu on of data?**
- A) Bar chart
- B) Line chart
- C) Histogram
- D) Sca er plot
- **Answer: C**
30. **What type of visualiza on is best for hierarchical data?**
- A) Heat map
- B) Pie chart
- C) Tree map
- D) Line chart
- **Answer: C**
31. **Which chart type is used to display the distribu on of categorical data?**
- A) Histogram
- B) Bar chart
- C) Line chart
- D) Sca er plot
- **Answer: B**
32. **What does a bubble chart represent?**
- A) Data points with different sizes to represent another dimension
- B) Data values using color intensity
- C) Trends over me
- D) Geographical data
- **Answer: A**
33. **Which type of visualiza on is best for showing the rela onship between three numerical
variables?**
- A) Line chart
- B) Sca er plot
- C) Bubble chart
- D) Histogram
- **Answer: C**
34. **What is a Gan chart used for?**
- A) Showing trends over me
- B) Comparing parts of a whole
- C) Displaying project schedules
- D) Showing rela onships between variables
- **Answer: C**
35. **Which visualiza on technique uses nodes and links to show rela onships?**
- A) Tree map
- B) Network diagram
- C) Heat map
- D) Bar chart
- **Answer: B**
36. **What type of visualiza on is best for showing the composi on of an en ty over me?**
- A) Line chart
- B) Area chart
- C) Bar chart
- D) Pie chart
- **Answer: B**
### Numeric Calcula ons in Tableau
37. **How do you create a calculated field in Tableau?**
- A) Right-click on
a data field and select "Create Calculated Field"
- B) Go to the Data menu and select "Create Calculated Field"
- C) Use the Analysis menu and select "Create Calculated Field"
- D) Drag and drop fields into the calculated field box
- **Answer: C**
38. **Which func on in Tableau returns the sum of a measure?**
- A) SUM()
- B) TOTAL()
- C) COUNT()
- D) AVG()
- **Answer: A**
39. **What does the ZN() func on do in Tableau?**
- A) Converts null values to zero
- B) Calculates the Z-score
- C) Normalizes data
- D) Finds the number of zero values in a field
- **Answer: A**
40. **How do you perform a condi onal calcula on in Tableau?**
- A) Using IF statements
- B) Using SUM statements
- C) Using COUNT statements
- D) Using AVG statements
- **Answer: A**
41. **Which func on calculates the average of a measure?**
- A) SUM()
- B) AVG()
- C) COUNT()
- D) MIN()
- **Answer: B**
42. **How can you round numbers in Tableau?**
- A) Using the ROUND() func on
- B) Using the SUM() func on
- C) Using the ZN() func on
- D) Using the COUNT() func on
- **Answer: A**
43. **What does the MIN() func on return in Tableau?**
- A) The minimum value of a measure
- B) The maximum value of a measure
- C) The sum of a measure
- D) The average of a measure
- **Answer: A**
44. **Which func on would you use to count the number of records in a dataset?**
- A) SUM()
- B) COUNT()
- C) AVG()
- D) MIN()
- **Answer: B**
45. **What does the MAX() func on return in Tableau?**
- A) The maximum value of a measure
- B) The minimum value of a measure
- C) The sum of a measure
- D) The average of a measure
- **Answer: A**
46. **Which func on is used to calculate the difference between two dates in Tableau?**
- A) DATEDIFF()
- B) DATEADD()
- C) NOW()
- D) TODAY()
- **Answer: A**
47. **How do you concatenate strings in Tableau?**
- A) Using the + operator
- B) Using the & operator
- C) Using the CONCAT() func on
- D) Using the || operator
- **Answer: C**
48. **What does the MEDIAN() func on calculate in Tableau?**
- A) The sum of a measure
- B) The average of a measure
- C) The median value of a measure
- D) The minimum value of a measure
- **Answer: C**
### String Calcula ons in Tableau
49. **Which func on is used to convert text to uppercase in Tableau?**
- A) UPPER()
- B) LOWER()
- C) PROPER()
- D) CAPITALIZE()
- **Answer: A**
50. **How do you find the length of a string in Tableau?**
- A) LENGTH()
- B) SIZE()
- C) CHARLEN()
- D) STRLEN()
- **Answer: A**
51. **Which func on is used to replace part of a string in Tableau?**
- A) SUBSTITUTE()
- B) REPLACE()
- C) SWAP()
- D) CHANGE()
- **Answer: B**
52. **How do you concatenate two strings in Tableau?**
- A) Using the + operator
- B) Using the & operator
- C) Using the CONCAT() func on
- D) Using the || operator
- **Answer: C**
53. **Which func on converts a string to lowercase in Tableau?**
- A) UPPER()
- B) LOWER()
- C) PROPER()
- D) CAPITALIZE()
- **Answer: B**
54. **How do you extract a substring from a string in Tableau?**
- A) Using the MID() func on
- B) Using the SUBSTRING() func on
- C) Using the LEFT() or RIGHT() func on
- D) All of the above
- **Answer: D**
55. **Which func on is used to find the posi on of a substring in a string?**
- A) POSITION()
- B) FIND()
- C) LOCATE()
- D) SEARCH()
- **Answer: B**
56. **What does the TRIM() func on do in Tableau?**
- A) Removes whitespace from the beginning and end of a string
- B) Removes characters from a string
- C) Adds whitespace to a string
- D) Splits a string into parts
- **Answer: A**
57. **How do you pad a string in Tableau?**
- A) Using the PAD() func on
- B) Using the SPACE() func on
- C) Using the RPAD() and LPAD() func ons
- D) Using the FILL() func on
- **Answer: C**
58. **Which func on converts the first le er of each word in a string to uppercase in Tableau?**
- A) UPPER()
- B) LOWER()
- C) PROPER()
- D) CAPITALIZE()
- **Answer: C**
59. **How do you remove leading and trailing spaces from a string in Tableau?**
- A) Using the TRIM() func on
- B) Using the STRIP() func on
- C) Using the CLEAN() func on
- D) Using the REMOVE() func on
- **Answer: A**
60. **Which func on is used to find the ASCII value of a character in Tableau?**
- A) CHAR()
- B) CODE()
- C) ASCII()
- D) VALUE()
- **Answer: C**
### Date Calcula ons in Tableau
61. **Which func on returns the current date and me in Tableau?**
- A) TODAY()
- B) NOW()
- C) CURRENT_DATE()
- D) CURRENT_TIME()
- **Answer: B**
62. **How do you extract the year from a date field in Tableau?**
- A) Using the YEAR() func on
- B) Using the DATEPART() func on
- C) Using the DATE() func on
- D) Using the EXTRACT() func on
- **Answer: A**
63. **Which func on adds a specified number of days to a date in Tableau?**
- A) DATEADD()
- B) DATEDIFF()
- C) DATEPART()
- D) DATESUB()
- **Answer: A**
64. **How do you calculate the difference between two dates in Tableau?**
- A) Using the DATEADD() func on
- B) Using the DATEDIFF() func on
- C) Using the DATEPART() func on
- D) Using the DATE() func on
- **Answer: B**
65. **Which func on extracts the month from a date field in Tableau?**
- A) MONTH()
- B) DATEPART()
- C) EXTRACT()
- D) PART()
- **Answer: A**
66. **How do you convert a string to a date in Tableau?**
- A) Using the DATE() func on
- B) Using the STRING() func on
- C) Using the DATETIME() func on
- D) Using the CONVERT() func on
- **Answer: A**
67. **Which func on returns the day of the week from a date in Tableau?**
- A) DAY()
- B) DATEPART()
- C) WEEKDAY()
- D) EXTRACT()
- **Answer: C**
68. **How do you calculate the number of months between two dates in Tableau?**
- A) Using the DATEADD() func on
- B) Using the DATEDIFF() func on
- C) Using the DATEPART() func on
- D) Using the MONTH() func on
- **Answer: B**
69. **Which func on extracts the quarter from a date field in Tableau?**
- A) QUARTER()
- B) DATEPART()
- C) EXTRACT()
- D) PART()
- **Answer: A**
70. **How do you convert a date to a string in Tableau?**
- A) Using the STRING() func on
- B) Using the DATESTR() func on
- C) Using the CONVERT() func on
- D) Using the DATETIME() func on
- **Answer: B**
71. **Which func on extracts the week number from a date field in Tableau?**
- A) WEEK()
- B) DATEPART()
- C) EXTRACT()
- D) PART()
- **Answer: A**
72. **How do you calculate the number of weeks between two dates in Tableau?**
- A) Using the DATEADD() func on
- B) Using the DATEDIFF() func on
- C) Using the DATEPART() func on
- D) Using the WEEK() func on
- **Answer: B**
### Level of Detail (LOD) Expressions in Tableau
73. **What does LOD stand for in Tableau?**
- A) Level of Detail
- B) Level of Data
- C) Level of Dimension
- D) Level of Display
- **Answer: A**
74. **Which type of LOD expression calculates a value using a specified dimension?**
- A) FIXED
- B) INCLUDE
- C) EXCLUDE
- D) SUM
- **Answer: A**
75. **What does an INCLUDE LOD expression do?**
- A) Includes addi onal dimensions in the calcula on
- B) Excludes dimensions from the calcula on
- C) Fixes the level of detail to a specific dimension
- D) Aggregates data to the highest level
- **Answer: A**
76. **Which LOD expression excludes a specified dimension from the calcula on?**
- A) FIXED
- B) INCLUDE
- C) EXCLUDE
- D) SUM
- **Answer: C**
77. **What is the syntax for a FIXED LOD expression in Tableau?**
- A) { FIXED [Dimension] : AGG([Measure]) }
- B) { INCLUDE [Dimension] : AGG([Measure]) }
- C) { EXCLUDE [Dimension] : AGG([Measure]) }
- D) { LOD [Dimension] : AGG([Measure]) }
- **Answer: A**
78. **How do you calculate the average sales per region using LOD expressions?**
- A) { FIXED [Region] : AVG([Sales]) }
- B) { INCLUDE [Region] : SUM([Sales]) }
- C) { EXCLUDE [Region] : SUM([Sales]) }
- D) { FIXED [Region] : SUM([Sales]) }
- **Answer: A**
79. **Which LOD expression would you use to calculate total sales excluding product category?**
- A) { FIXED [Category] : SUM([Sales]) }
- B) { INCLUDE [Category] : SUM([Sales]) }
- C) { EXCLUDE [Category] : SUM([Sales]) }
- D) { LOD [Category] : SUM([Sales]) }
- **Answer: C**
80. **What is the primary purpose of using LOD expressions in Tableau?**
- A) To filter data
- B) To perform calcula ons at different levels of granularity
- C) To create visualiza ons
- D) To format data
- **Answer: B**
81. **Which LOD expression would you use to include city in the calcula on of average sales per
region?**
- A) { FIXED [Region] : AVG([Sales]) }
- B) { INCLUDE [City] : AVG([Sales]) }
- C) { EXCLUDE [City] : AVG([Sales]) }
- D) { INCLUDE [Region, City] : AVG([Sales]) }
- **Answer: B**
82. **How do you create an LOD expression in Tableau?**
- A) By using the Analysis menu and selec ng "Create LOD Expression"
- B) By wri ng the expression directly in the calculated field editor
- C) By using the Data menu and selec ng "LOD Expression"
- D) By using the Show Me panel
- **Answer: B**
83. **Which type of LOD expression would you use to calculate the sum of sales at the country
level?**
- A) { FIXED [Country] : SUM([Sales]) }
- B) { INCLUDE [Country] : SUM([Sales]) }
- C) { EXCLUDE [Country] : SUM([Sales]) }
- D) { LOD [Country] : SUM([Sales]) }
- **Answer: A**
84. **What does the EXCLUDE LOD expression do in Tableau?**
- A) Excludes specific dimensions from the calcula on
- B) Fixes the level of detail to a specific dimension
- C) Includes addi onal dimensions in the calcula on
- D) Aggregates data to the highest level
- **Answer: A**
### Modern Data Analy c Tools
85. **Which of the following is a popular data visualiza on tool?**
- A) Tableau
- B) Microso Power BI
- C) QlikView
- D) All of the above
- **Answer: D**
86. **What is the primary use of R in data analy cs?**
- A) Data entry
- B) Data visualiza on
- C) Sta s cal analysis
- D) Data storage
- **Answer: C**
87. **Which tool is known for its advanced sta s cal analysis capabili es?**
- A) Tableau
- B) R
- C) Excel
- D) Google Sheets
- **Answer: B**
88. **Which data analy cs tool is part of the Microso Office suite?**
- A) Tableau
- B) Power BI
- C) QlikView
- D) Looker
- **Answer: B**
89. **What is the primary use of Python in data analy cs?**
- A) Data storage
- B) Data visualiza on
- C) Data cleaning and analysis
- D) Data entry
- **Answer: C**
90. **Which tool is known for its interac ve dashboards and reports?**
- A) Tableau
- B) Excel
- C) R
- D) Hadoop
- **Answer: A**
91. **Which modern data analy cs tool is cloud-based and allows for real- me collabora on?**
- A) Tableau
- B) Power BI
- C) Google Data Studio
- D) QlikView
- **Answer: C**
92. **What is the primary advantage of using Hadoop in data analy cs?**
- A) Real- me data visualiza on
- B) Handling and processing large datasets
- C) Data entry and storage
- D) Sta s cal analysis
- **Answer: B**
93. **Which tool provides machine learning capabili es for data analy cs?**
- A) Tableau
- B) Power BI
- C) Google Cloud Pla orm
- D) Excel
- **Answer: C**
94. **Which data analy cs tool integrates seamlessly with Google products?**
- A) Tableau
- B) Looker
- C) Power BI
- D) QlikView
- **Answer: B**
95. **What is the primary use of SQL in data analy cs?**
- A) Data storage
- B) Data retrieval and manipula on
- C) Data visualiza on
- D) Sta s cal analysis
- **Answer: B**
96. **Which tool is known for its drag-and-drop interface for crea ng visualiza ons?**
- A) Tableau
- B) R
- C) Hadoop
- D) Python
- **Answer: A**
97. **Which modern data analy cs tool focuses on business intelligence and enterprise repor ng?**
- A) Tableau
- B) Power BI
- C) QlikView
- D) SAS
- **Answer: B**
98. **Which open-source tool is widely used for data analysis and visualiza on?**
- A) Excel
- B) Power BI
- C) R
- D) Tableau
- **Answer: C**
99. **Which tool is best for crea ng real- me interac ve dashboards?**
- A) Tableau
- B) R
- C) Excel
- D) Hadoop
- **Answer: A**
100. **Which modern data analy c tool is part of Google Cloud Pla orm and is used for big data
analysis?**
- A) Tableau
- B) Power BI
- C) BigQuery
- D) Looker
- **Answer: C**
These 100 MCQs cover a range of topics related to Tableau, data visualiza on, and modern data
analy c tools, providing a comprehensive review of key concepts and func onali es. Let me know if
you need any further details or addi onal ques ons!
