Back to lesson
1. When you create a table in Excel, what happens?
Nothing, you have to set all the characteristics above manually.
Filters are automatically added to the header row.
Alternate row color banding is added to the table.
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 cannot be used in tables.
A1 style formulas are replaced by the new formula style and automatically run down the entire column
A1 style formulas function as normal, but are automatically run down the entire column
3. 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?
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