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 .