Question

Name the table which is an interactive way to quickly summarise large amounts of data. State any three reasons why this table is designed.

Hint:

The table is the Pivot Table. Give any three reasons such as querying large data easily, custom calculations and expanding or collapsing levels.

Answer 1

Step 1: Name the table:
The table that gives an interactive way to summarise large amounts of data quickly is the Pivot Table. It carries 1 mark.

Step 2: Reason 1: Querying large data:
A pivot table lets the user query large amounts of data in user friendly ways. No complex formula is needed.

Step 3: Reason 2: Custom calculations:
The user can create custom calculations and formulas inside the table. Totals, averages and counts can be changed easily.

Step 4: Reason 3: Expanding and collapsing levels:
Levels of data can be expanded or collapsed to focus on the results. The user can go from a summary down to the details of an area of interest.

Step 5: Marks check:
Name = 1 mark. Three reasons at 1 mark each = 3 marks. Total = 4 marks.

Final Answer:
The table is the Pivot Table. It is designed for querying large data in user friendly ways, for custom calculations, and for expanding and collapsing levels of data.