Microsoft Excel Managing Tables and Table Data 2

Question 1

How do calculated columns work in Excel Tables?

Accepted Answer

A formula in one cell automatically fills the entire column

Answer

Formulas auto-propagate through the entire Table column using structured references.

Question 2

How do structured references differ from cell references?

Accepted Answer

Use table and column names like Table1[@Sales] instead of B2

Answer

Structured references use descriptive names making formulas readable and resilient to changes.

Question 3

What does Resize Table do?

Accepted Answer

Adjusts table boundaries to include more or fewer rows/columns

Answer

Resize Table modifies the table range to include or exclude rows and columns.

Question 4

What does Convert to Range do?

Accepted Answer

Removes Table functionality while preserving data and formatting

Answer

Convert to Range removes all Table features but keeps cell data and visual formatting.

Question 5

How do Table column filter dropdowns work?

Accepted Answer

Click header dropdown for sort, text/number filters, and checkbox selection

Answer

Each column header has a dropdown with sorting, value selection, and advanced filters.

Excel Practice Test