1. 1

    What happens when you create a table in Excel?

  2. 2

    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?

  3. 3

    Formatting a range of data as an Excel table can apply color banding and immediately add a name to the table (covering the entire table range), and also add filters. Which outcome is the most difficult to replicate on a range of data not set up as an official Excel table?