DATA ANALYSIS Intro to Filtering, Pivot Tables and Charts Latest Assessment MODULE 2 Q & A 2026 (Complete And Verified Study material) (13pages) LEARNEXAMS

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,