Toggle navigation
GoSkills
Courses
Courses
Train your organization
Supercharge your organization with expert-led business and productivity courses.
Learn more
Learn on your own
Earn certifications for the most in-demand skills with unlimited access to all GoSkills courses.
Learn more
Explore our courses
Browse our award-winning library of 110+ business and productivity courses delivered in bite-sized lessons.
Explore courses
LMS
Course builder
Resources
Pricing
Organization pricing
Individual pricing
Pricing
Search
Sign up
Log in
Log in
Signup
Quiz
1
Intermediate
When you create a table in Excel, what happens?
Nothing, you have to set all the characteristics above manually.
Alternate row color banding is added to the table.
Filters are automatically added to the header row.
Don’t know
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?
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
Don’t know
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?
Ensuring a VLOOKUP is always pointed at the entirety of the target data
Adding filters to a list of data
Alternate row color banding
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement