Quiz

  1. 1
    Intermediate

    What happens when you create a table in Excel?

  2. 2
    Intermediate

    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
    Intermediate

    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?