DATA ANALYSIS
Intro to Filtering, Pivot
Tables and Charts
Latest Assessment
MODULE 2 Q & A
2024
, 1. What is the advantage of using Excel tables over regular
ranges?
a) They can filter, sort and see totals
b) They can add columns to the existing data
c) They can create pivot tables and charts
d) **All of the above** (According to , Excel tables have
all these features)
2. What is a pivot table in Excel?
a) A table that summarizes data in flexible ways
b) A table that rotates data by 90 degrees
c) A table that links data from multiple sources
d) A table that performs calculations on data
e) **A and D** (According to , pivot tables can aggregate
and analyze data)
3. What is a slicer in Excel?
a) A tool that cuts data into smaller pieces
b) **A tool that filters data in multiple pivot tables**
(According to , slicers can apply filters to one or more
pivot tables)
c) A tool that creates charts from data
d) A tool that formats data in different ways
4. What is the difference between a pivot chart and a
regular chart in Excel?
a) A pivot chart is based on a pivot table, while a regular
chart is based on a range of cells
b) A pivot chart can be updated by changing the fields in
the pivot table, while a regular chart needs to be modified
manually
c) A pivot chart can show different views of the same data,
Intro to Filtering, Pivot
Tables and Charts
Latest Assessment
MODULE 2 Q & A
2024
, 1. What is the advantage of using Excel tables over regular
ranges?
a) They can filter, sort and see totals
b) They can add columns to the existing data
c) They can create pivot tables and charts
d) **All of the above** (According to , Excel tables have
all these features)
2. What is a pivot table in Excel?
a) A table that summarizes data in flexible ways
b) A table that rotates data by 90 degrees
c) A table that links data from multiple sources
d) A table that performs calculations on data
e) **A and D** (According to , pivot tables can aggregate
and analyze data)
3. What is a slicer in Excel?
a) A tool that cuts data into smaller pieces
b) **A tool that filters data in multiple pivot tables**
(According to , slicers can apply filters to one or more
pivot tables)
c) A tool that creates charts from data
d) A tool that formats data in different ways
4. What is the difference between a pivot chart and a
regular chart in Excel?
a) A pivot chart is based on a pivot table, while a regular
chart is based on a range of cells
b) A pivot chart can be updated by changing the fields in
the pivot table, while a regular chart needs to be modified
manually
c) A pivot chart can show different views of the same data,
