Quiz

  1. 1
    Intermediate

    When you create a table in Excel, what happens?

  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, immediately adds a name to the table (which always covers the entire table range), and also adds filters. Which of is the most difficult to replicate on a range of data that is not set up as an official Excel table?