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

Data becomes read-only

Answer

Data moves to new worksheet

Answer

Formulas convert to values

Question 2

How does multi-level sorting work in Excel?

Accepted Answer

Each level sorts within groups created by the previous level

Answer

Only one level allowed

Answer

Multiple sorts overwrite each other

Answer

Each level sorts independently

Question 3

What is the Total Row in an Excel Table?

Accepted Answer

A summary row with dropdown aggregate functions for each column

Answer

Shows table dimensions

Answer

Header row duplicate

Answer

Locks table from editing

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 is slower

Answer

Only works with Tables

Answer

Identical functionality

Question 5

What are Slicers for Tables?

Accepted Answer

Visual filter buttons for interactive single-click filtering

Answer

Split tables into pieces

Answer

Remove unwanted columns

Answer

PivotTable only

Question 6

How does SUBTOTAL differ from regular aggregate functions?

Accepted Answer

Ignores hidden/filtered rows and supports 11 different functions

Answer

SUBTOTAL is slower

Answer

Only numeric data

Answer

No difference