Search for courses or lessons
Redeem a coupon
Start free trial
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?
Header rows on our tables
Blank rows and columns
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)
What is the quickest way to select all the data in our worksheet that we want to include in our PivotTable?
Select any cell in the worksheet, select Insert > PivotTable and everything will automatically be selected
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
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement