Back to lesson
1. What happens when you create a table in Excel?
Filters are automatically added to the header row.
Alternate row color banding is added to the table.
Nothing. You have to set all the characteristics, such as the ones above, manually.
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?
A1 style formulas can't be used in tables.
A1 style formulas function as normal, but are automatically run down the entire column.
A1 style formulas are replaced by the new formula style and automatically run down the entire column.
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?
Ensuring a VLOOKUP is always pointed at the entirety of the target data.
Alternate row color banding.
Adding filters to a list of data.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement