Question

Lana is trying to insert a table, but she does not like any standard table options that she is given. Which best describes what she should do to draw a custom table? She should go to the Design tab and select Chart. She should go to the Insert tab and select Chart. She should go to the Insert tab and select Table. She should go to the Design tab and select Table.

Answer 1

Answer:

The best way to define it is: It’s a built-in feature of Excel that allows you to take data and re-arrange it.

It creates a table that allows you to choose what and how you want to view your data.

Why use Pivot Tables?

For starters, they improve the ability to draw actionable conclusions from your data. This is especially true of large sets of data with many different attributes.