DATA ANALYSIS
Introduction to
Spreadsheets Latest
Assessment
MODULE 1 Q & A
2024
,1. What is the advantage of using Excel tables over regular
ranges?
A) Excel tables can filter, sort and see totals automatically
B) Excel tables can create pivot tables and charts easily
C) Excel tables can add columns with calculations to the
existing data
D) All of the above
Answer: D) All of the above
Rationale: According to the edX course "Introduction to
Data Analysis using Excel", Excel tables have many
benefits over regular ranges, such as filtering, sorting,
totaling, creating pivots and charts, and adding calculated
columns .
2. What is the purpose of using pivot tables in Excel?
A) To perform data analysis using Excel's most popular
features
B) To create flexible data aggregations from a range with
rows and columns
C) To summarize data in flexible ways, enabling quick
exploration and insights
D) All of the above
Answer: D) All of the above
Rationale: According to the Coursera course "Introduction
to Data Analysis Using Excel", pivot tables are one of the
top tools for data analysis in Excel, as they allow users to
create flexible data aggregations, summarize data in
various ways, and gain insights from the accumulated data .
, 3. What is the difference between a pivot table and a pivot
chart in Excel?
A) A pivot table is a table that summarizes data, while a
pivot chart is a chart that visualizes data
B) A pivot table is a chart that visualizes data, while a pivot
chart is a table that summarizes data
C) A pivot table and a pivot chart are the same thing, just
with different names
D) None of the above
Answer: A) A pivot table is a table that summarizes data,
while a pivot chart is a chart that visualizes data
Rationale: According to the Microsoft Community Hub
article "Introduction to Data Analysis using Excel", a pivot
table is a tool that summarizes data from a range or a table,
while a pivot chart is a tool that displays data graphically
using the same fields and calculations as the pivot table .
4. How can you filter data using slicers in multiple pivot
tables in Excel?
A) By creating a slicer for each pivot table and linking
them together
B) By creating one slicer for all the pivot tables and
selecting the desired values
C) By creating a slicer for one pivot table and copying it to
the other pivot tables
D) None of the above
Answer: B) By creating one slicer for all the pivot tables
and selecting the desired values
Rationale: According to the edX course "Introduction to
Data Analysis using Excel", slicers are interactive filters
Introduction to
Spreadsheets Latest
Assessment
MODULE 1 Q & A
2024
,1. What is the advantage of using Excel tables over regular
ranges?
A) Excel tables can filter, sort and see totals automatically
B) Excel tables can create pivot tables and charts easily
C) Excel tables can add columns with calculations to the
existing data
D) All of the above
Answer: D) All of the above
Rationale: According to the edX course "Introduction to
Data Analysis using Excel", Excel tables have many
benefits over regular ranges, such as filtering, sorting,
totaling, creating pivots and charts, and adding calculated
columns .
2. What is the purpose of using pivot tables in Excel?
A) To perform data analysis using Excel's most popular
features
B) To create flexible data aggregations from a range with
rows and columns
C) To summarize data in flexible ways, enabling quick
exploration and insights
D) All of the above
Answer: D) All of the above
Rationale: According to the Coursera course "Introduction
to Data Analysis Using Excel", pivot tables are one of the
top tools for data analysis in Excel, as they allow users to
create flexible data aggregations, summarize data in
various ways, and gain insights from the accumulated data .
, 3. What is the difference between a pivot table and a pivot
chart in Excel?
A) A pivot table is a table that summarizes data, while a
pivot chart is a chart that visualizes data
B) A pivot table is a chart that visualizes data, while a pivot
chart is a table that summarizes data
C) A pivot table and a pivot chart are the same thing, just
with different names
D) None of the above
Answer: A) A pivot table is a table that summarizes data,
while a pivot chart is a chart that visualizes data
Rationale: According to the Microsoft Community Hub
article "Introduction to Data Analysis using Excel", a pivot
table is a tool that summarizes data from a range or a table,
while a pivot chart is a tool that displays data graphically
using the same fields and calculations as the pivot table .
4. How can you filter data using slicers in multiple pivot
tables in Excel?
A) By creating a slicer for each pivot table and linking
them together
B) By creating one slicer for all the pivot tables and
selecting the desired values
C) By creating a slicer for one pivot table and copying it to
the other pivot tables
D) None of the above
Answer: B) By creating one slicer for all the pivot tables
and selecting the desired values
Rationale: According to the edX course "Introduction to
Data Analysis using Excel", slicers are interactive filters
