100 MCQs – Data Visualization (with Answers)
1) What is Tableau primarily used for?
a) Coding Applications
b) Creating Databases
c) Data Visualization
d) Antivirus Scanning
✅ Answer: c
2) Which of the following is an advantage of Tableau?
a) Requires complex coding
b) Only works offline
c) Easy drag-and-drop interface
d) No support for real-time data
✅ Answer: c
3) The Tableau Analytics Platform provides:
a) Only chart creation
b) A centralized solution for data analysis
c) Video editing features
d) Code compilation tools
✅ Answer: b
4) Data preparation in Tableau includes:
a) Running Python scripts
b) Cleaning and organizing data
c) Designing databases
d) Compiling programs
✅ Answer: b
5) Which element is part of Tableau Workspace?
a) Control panel
b) Data pane
c) Settings manager
d) Debug window
✅ Answer: b
6) What are dimensions in Tableau?
a) Numerical values
b) Categorical fields
c) Aggregated values
d) Statistical metrics
✅ Answer: b
7) Which of the following is a Tableau measure?
a) Product name
b) Category
c) Sales amount
d) Country
✅ Answer: c
8) What type of data does Tableau NOT support?
a) Boolean
b) XML tree
c) Date
d) Geographic
✅ Answer: b
9) A data connector in Tableau is used to:
a) Create animations
b) Encrypt files
c) Link to external data sources
d) Draw images
✅ Answer: c
10) Which operation stacks data vertically in Tableau?
a) Join
b) Sort
c) Union
d) Filter
✅ Answer: c
11) Joins in Tableau combine tables:
a) Vertically
b) Horizontally
c) Using scripts
d) Randomly
✅ Answer: b
12) Which Tableau file format is used for data extracts?
a) .csv
b) .hyper
c) .docx
d) .exe
✅ Answer: b
13) What is a benefit of using extracts over live connections?
a) Slower performance
b) Real-time updates
c) Faster querying
d) Requires internet
✅ Answer: c
14) What does metadata in Tableau refer to?
a) Actual data
b) Programming code
c) Information about data structure
d) Data storage files
✅ Answer: c
15) What feature in Tableau suggests chart types?
a) Data lens
b) Show Me
c) Chart Wizard
d) Style Panel
✅ Answer: b
16) A Tableau dashboard is a collection of:
a) SQL queries
b) Charts and filters
c) Raw data
d) Programs
✅ Answer: b
17) A Tableau story helps users:
a) Encrypt dashboards
b) Add programming code
c) Present a data-driven narrative
d) Lock files
✅ Answer: c
18) Which of the following is a correct join type in Tableau?
a) Multi-stage
b) Half join
c) Inner join
d) Full link
✅ Answer: c
19) What kind of chart is best for trend analysis?
a) Bar Chart
b) Pie Chart
c) Line Chart
d) Heat Map
✅ Answer: c
20) Highlight tables in Tableau use:
a) 3D graphics
b) Shapes
c) Color
d) Animations
✅ Answer: c
21) Heat maps in Tableau help to identify:
a) Passwords
b) Trends in text files
c) Density and performance visually
d) Email attachments
✅ Answer: c
22) A bullet chart compares actual vs:
a) Average
b) Maximum
c) Target
d) Count
✅ Answer: c
23) Which chart best shows cumulative values over time?
a) Donut chart
b) Scatter plot
c) Waterfall chart
d) Tree map
✅ Answer: c
24) How do you apply a filter in Tableau?
a) Open settings
b) Drag a field to Filters shelf
c) Use SQL query
d) Press F12
✅ Answer: b
25) A dual-axis chart is used to:
a) Merge dashboards
b) Compare two measures
c) Sort data
d) Create filters
✅ Answer: b
26) Which feature provides additional details on hover?
a) Chart Editor
b) Dashboard pane
c) Tooltip
d) Layer
✅ Answer: c
27) In a hierarchy, data is drilled down from:
a) Smaller to larger levels
b) Alphabetically
c) Higher to more detailed levels
d) Random order
✅ Answer: c
28) How is a line chart different from a bar chart?
a) Used for grouping
b) Shows numeric data only
c) Best for comparing dates
d) Better for trends over time
✅ Answer: d
29) Which chart uses rectangles with color intensity?
a) Pie chart
b) Heat map
c) Line chart
d) Histogram
✅ Answer: b
30) To create a hierarchy in Tableau:
a) Use SQL
b) Right-click and drag subfields
c) Insert a macro
d) Use formula editor
✅ Answer: b
31) Which of the following supports drill-downs in Tableau?
a) Sorting
b) Grouping
c) Hierarchies
d) Filtering
✅ Answer: c
32) What does the ‘Show Me’ panel recommend?
a) Joins
b) Chart types
c) Data connectors
d) Security settings
✅ Answer: b
33) Which chart would best show monthly sales growth?
a) Bullet
b) Bar
c) Line
d) Pie
✅ Answer: c
34) What is NOT a type of bar chart in Tableau?
a) Horizontal
b) Vertical
c) Rotational
d) Column
✅ Answer: c
35) To create a chart in Tableau, use:
a) Rows and columns shelf
b) Dashboard filter
c) Legend tab
d) Script runner
✅ Answer: a
36) Which of the following helps in sorting data visually?
a) Measures pane
b) Filter dialog
c) Sorting tool
d) Worksheet title
✅ Answer: c
37) What does a cumulative sum show?
a) Individual values
b) Frequency
c) Running total
d) Minimums only
✅ Answer: c
38) How can you edit a legend in Tableau?
a) Right-click → Edit
b) Use script
c) Modify SQL
d) Hide it permanently
✅ Answer: a
39) Which chart uses reference lines and bars?
a) Bullet chart
b) Pie chart
c) Tree map
d) Highlight table
✅ Answer: a
40) Which field category is typically aggregated in Tableau?
a) Dimensions
b) Strings
c) Measures
d) Dates
✅ Answer: c
41) Which feature allows changing field names in Tableau?
a) Metadata editing
b) SQL Query Editor
c) Format pane
d) Table manager
✅ Answer: a
42) What is the default data structure in Tableau?
a) Object graph
b) Data table
c) Data warehouse
d) Form
✅ Answer: b
43) To update charts with live data, you should use:
a) Data Extract
b) Static File
c) Live Connection
d) Export Wizard
✅ Answer: c
44) Which file type supports faster querying offline?
a) .doc
b) .csv
c) .hyper
d) .json
✅ Answer: c
45) How are unions applied in Tableau?
a) Horizontally
b) Merged by key
c) Stacked vertically
d) Using SQL scripts
✅ Answer: c
46) Which component is NOT part of Tableau workspace?
a) Shelves
b) Data pane
c) Query runner
d) Show Me panel
✅ Answer: c
47) Tableau is most commonly used in which field?
a) Medicine
b) Mechanical Engineering
c) Data Analysis
d) Law
✅ Answer: c
48) Which chart is best for target comparisons?
a) Bullet
b) Pie
c) Tree
d) Line
✅ Answer: a
49) Which feature displays additional info on data points?
a) Tooltip
b) Legend
c) Sort
d) Title
✅ Answer: a
50) The layout that combines charts on a single screen is:
a) Worksheet
b) Chart pane
c) Dashboard
d) Connection view
✅ Answer: c
51) Which Tableau component allows combining multiple charts?
a) Sheet
b) Data Source
c) Dashboard
d) Pane
✅ Answer: c
52) Which of the following is an example of a dimension?
a) Revenue
b) Quantity
c) Region
d) Profit
✅ Answer: c
53) What happens when you drag a dimension into the Rows shelf?
a) It creates a filter
b) It plots a measure
c) It creates headers for rows
d) It hides data
✅ Answer: c
54) What is the result of applying a left join in Tableau?
a) Only matching records
b) All left table records + matched right table
c) Right table only
d) Top 10 records
✅ Answer: b
55) Which feature helps in renaming Tableau fields?
a) Format pane
b) Axis editor
c) Metadata management
d) Data label
✅ Answer: c
56) Which data type is suitable for time-based trend charts?
a) String
b) Date
c) Boolean
d) Integer
✅ Answer: b
57) Highlight tables help emphasize:
a) Data source names
b) Charts inside dashboards
c) Specific values using color
d) Animation effects
✅ Answer: c
58) Which chart uses multiple axes in Tableau?
a) Tree map
b) Pie chart
c) Dual-axis chart
d) Scatter plot
✅ Answer: c
59) Which element appears when hovering over a data point?
a) Mark
b) Filter bar
c) Tooltip
d) Data label
✅ Answer: c
60) Which chart type is ideal for displaying proportions?
a) Bar chart
b) Pie chart
c) Line chart
d) Heat map
✅ Answer: b
61) The visual shelf used to create chart layouts is:
a) Data pane
b) Filters pane
c) Rows/Columns shelf
d) Formatting bar
✅ Answer: c
62) What is Tableau’s 'Show Me' panel based on?
a) Predefined chart styles
b) Selected fields
c) Data extract size
d) Data format
✅ Answer: b
63) To connect Tableau to MySQL, use:
a) REST API
b) Data connector
c) Flat file
d) Web table
✅ Answer: b
64) Tableau filters can be applied at which level?
a) Chart only
b) Data only
c) Sheet, dashboard, or data source
d) Server only
✅ Answer: c
65) What is required to perform a union?
a) Matching keys
b) Equal column structure
c) Common primary key
d) Python code
✅ Answer: b
66) The chart best suited for comparing categories is:
a) Line chart
b) Bar chart
c) Heat map
d) Pie chart
✅ Answer: b
67) Cumulative data can be visualized using:
a) Highlight tables
b) Pie charts
c) Waterfall charts
d) Donut charts
✅ Answer: c
68) Which chart allows time-series trend analysis?
a) Tree map
b) Line chart
c) Bullet chart
d) Scatter plot
✅ Answer: b
69) Which Tableau feature allows conditional formatting?
a) Data Source
b) Format pane
c) Set
d) Filter
✅ Answer: b
70) Which of the following is NOT a Tableau join type?
a) Outer Join
b) Inner Join
c) Cross Join
d) Left Join
✅ Answer: c
71) To display multiple charts in one view, use:
a) Worksheet
b) Metadata
c) Dashboard
d) Filter
✅ Answer: c
72) Which element contains dimension and measure fields?
a) Axis
b) Worksheet
c) Data Pane
d) Format tab
✅ Answer: c
73) What do small circles on a line chart represent?
a) Filters
b) Markers (data points)
c) Zoom controls
d) Chart labels
✅ Answer: b
74) Which chart is good for displaying targets vs actuals?
a) Heat map
b) Bullet chart
c) Line chart
d) Pie chart
✅ Answer: b
75) The canvas for chart creation is called:
a) Worksheet
b) Storyline
c) Show Me
d) Pane
✅ Answer: a
76) What type of data is ideal for geographic visualization?
a) Integer
b) String
c) Geographic
d) Date
✅ Answer: c
77) Which chart is best suited for sales per region?
a) Line chart
b) Bullet chart
c) Bar chart
d) Waterfall chart
✅ Answer: c
78) Which operation is NOT available in Tableau?
a) Drill-down
b) Predictive modeling
c) Data encryption
d) Aggregation
✅ Answer: c
79) The process of hiding unused fields is called:
a) Filtering
b) Sorting
c) Metadata cleanup
d) Collapsing
✅ Answer: c
80) Which field is usually displayed on the X-axis?
a) Measure
b) Date/Dimension
c) Tooltip
d) Legend
✅ Answer: b
81) What is the key difference between extract and live data?
a) Live is faster
b) Extract is dynamic
c) Extract is offline copy
d) Extract uses SQL
✅ Answer: c
82) The central panel for placing chart elements is called:
a) Dashboard
b) Canvas
c) Legend
d) Filter bar
✅ Answer: b
83) Which file format is NOT supported by Tableau?
a) Excel
b) PDF
c) SQL
d) JPG
✅ Answer: d
84) Which function adds color to highlight tables?
a) Color shelf
b) Label shelf
c) Tooltip
d) Size tab
✅ Answer: a
85) Which pane shows field names and types?
a) Metadata
b) Data pane
c) Format pane
d) Dashboard pane
✅ Answer: b
86) How do you compare two numerical values on one chart?
a) Tooltip
b) Pie chart
c) Dual-axis
d) Filters
✅ Answer: c
87) Which operation is used to remove unwanted data points?
a) Union
b) Drill-down
c) Filtering
d) Aggregation
✅ Answer: c
88) Which chart is NOT suitable for categorical comparison?
a) Line chart
b) Bar chart
c) Pie chart
d) Highlight table
✅ Answer: a
89) How do you identify outliers in Tableau?
a) Pie chart
b) Bar chart
c) Box plot
d) Line chart
✅ Answer: c
90) To combine sheets into a data story, use:
a) Data pane
b) Worksheet
c) Story
d) Filter pane
✅ Answer: c
91) What type of data supports drill-down in hierarchies?
a) Continuous data
b) Boolean data
c) Hierarchical data
d) Static data
✅ Answer: c
92) Which component supports interactivity in dashboards?
a) Legend
b) Filter actions
c) Show Me panel
d) Format pane
✅ Answer: b
93) Which join returns unmatched rows with NULL values?
a) Inner join
b) Left join
c) Full outer join
d) Union
✅ Answer: c
94) What are the two axes in dual-axis called?
a) Primary and secondary
b) X and Y
c) Top and bottom
d) Main and sub
✅ Answer: a
95) A dashboard layout includes:
a) SQL views
b) Charts, filters, containers
c) Table joins
d) Programming fields
✅ Answer: b
96) Which field type is used to categorize data?
a) Measures
b) Dimensions
c) Boolean
d) Geographic
✅ Answer: b
97) Which chart can handle large value distributions?
a) Box plot
b) Pie chart
c) Tree map
d) Highlight table
✅ Answer: a
98) The format pane helps adjust:
a) Field names
b) Data types
c) Font, colors, gridlines
d) Filters
✅ Answer: c
99) Which field typically uses aggregation functions like SUM()?
a) Dimension
b) Measure
c) Boolean
d) Date
✅ Answer: b
100) Which visualization emphasizes part-to-whole relationship?
a) Pie chart
b) Line chart
c) Bar chart
d) Bullet chart
✅ Answer: a