What happens when you create a table in Excel?

Answer 1

Filters are automatically added to the header row.

Answer 2

Nothing. You have to set all the characteristics, such as the ones above, manually.

Answer 3

Alternate row color banding is added to the table.

Answer 4

Don’t know

Answer 5

A1 style formulas can't be used in tables.

Answer 6

A1 style formulas function as normal, but are automatically run down the entire column.

Answer 7

A1 style formulas are replaced by the new formula style and automatically run down the entire column.

Answer 8

Don’t know

Answer 9

Ensuring a VLOOKUP is always pointed at the entirety of the target data.

Answer 10

Adding filters to a list of data.

Answer 11

Alternate row color banding.

Answer 12

Don’t know

Excel tables come with a new style of formulas called Structured Table Referencing. What happens when a classic A1 style of formulas that you are used to writing is entered in an Excel table cell?