What happens when you create a table in Excel?

Answer 1

Filters are automatically added to the header row

Answer 2

Alternate row color banding is added to the table

Answer 3

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

Answer 4

Don’t know

Answer 5

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

Answer 6

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

Answer 7

A1 style formulas can't be used in tables

Answer 8

Don’t know

Answer 9

Adding filters to a list of data

Answer 10

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

Answer 11

Alternate row color banding that updates automatically when new rows are inserted

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?