Microsoft Excel Managing Tables and Data 2

Question 1

What happens when you convert a range to an Excel Table (Ctrl+T)?

Accepted Answer

Gains structured references, auto-filters, formatting, and dynamic expansion

Answer

Tables add auto-filters, structured references, automatic formatting, and auto-expansion.

Question 2

How does multi-level sorting work in Excel?

Accepted Answer

Each level sorts within groups created by the previous level

Answer

Multi-level sorting creates a hierarchy: first level sorts all data, subsequent levels sort within groups.

Question 3

What is the Total Row in an Excel Table?

Accepted Answer

A summary row with dropdown aggregate functions for each column

Answer

Total Row adds summary functions (SUM, AVERAGE, COUNT, etc.) at the bottom of each column.

Question 4

How does Advanced Filter differ from AutoFilter?

Accepted Answer

Can extract to another location, use complex AND/OR criteria, find unique records

Answer

Advanced Filter supports complex multi-field AND/OR criteria, copying results elsewhere, and unique records.

Question 5

What are Slicers for Tables?

Accepted Answer

Visual filter buttons for interactive single-click filtering

Answer

Slicers provide clickable buttons that instantly filter Table data.

Excel Practice Test