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