.png){kind=logo}
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 .
.png)