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
Beginner
Before we set up our PivotTables, we should ensure that the data is in good form. Which of the following should NEVER be included in a PivotTable data source?
Blank rows and columns
Subtotals
Header rows on our tables
Don’t know
2
Beginner
Which of the following statements is true?
Data types should be consistent down all rows of a column including the header row
Data consistency is entirely optional in a column
Data types should be consistent down all rows of a column, with the exception of the header row (which will always be treated as text)
Don’t know
3
Beginner
What is the quickest way to select all the data in our worksheet that we want to include in our PivotTable?
Press CTRL + End, hold down the Shift key, and then press CTRL + Home
Select the top left cell, hold the left mouse button and scroll down and across until we get to the last used cell
Select any cell in the worksheet, select Insert > PivotTable and everything will automatically be selected
Don’t know
Back to the top
© 2024 GoSkills Ltd.
Skills for career advancement