What happens when you create a table in Excel?

Answer 1

Alternate row color banding is added to the table

Answer 2

Filters are automatically added to the header row

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 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 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?