Search for courses or lessons
Redeem a coupon
Start free trial
What happens when you create a table in Excel?
Alternate row color banding is added to the table
Nothing. You have to set all the characteristics, such as the ones above, manually
Filters are automatically added to the header row
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
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 that updates automatically when new rows are inserted
Adding filters to a list of data
Ensuring a VLOOKUP is always pointed at the entirety of the target data
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement