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

Require manual entry in each cell

Answer

Only basic math

Answer

PivotTable feature only

Question 2

How do structured references differ from cell references?

Accepted Answer

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

Answer

Use numbers instead of letters

Answer

Another name for absolute references

Answer

Only work in VBA

Question 3

What does Resize Table do?

Accepted Answer

Adjusts table boundaries to include more or fewer rows/columns

Answer

Changes font size

Answer

Changes column widths proportionally

Answer

Scales for printing

Question 4

What does Convert to Range do?

Accepted Answer

Removes Table functionality while preserving data and formatting

Answer

Converts to chart

Answer

Exports to file

Answer

Converts to text

Question 5

How do Table column filter dropdowns work?

Accepted Answer

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

Answer

Type criteria in header

Answer

View tab filter button

Answer

VBA only

Question 6

What is the Table Name used for?

Accepted Answer

Unique identifier used in structured references and formulas

Answer

Watermark on table

Answer

Sheet tab name

Answer

Cannot be changed