What is the second sort field called?
Give this one a try later!
Secondary Sort Field
What can you add to a Pivot table?
Give this one a try later!
Many levels of subtotals and totals
How do you resize the panes?
,Give this one a try later!
You drag the split bar
Excel adds header with what default name?
Give this one a try later!
Column1 and so on
What does the clear filter command do?
Give this one a try later!
Remove all filters and redisplay all the records
What does the Pivot table use as the column labels?
Give this one a try later!
The data from the Category field
The first row of the range contains field names called?
Give this one a try later!
, Header Row
How many slicers can you create for a Pivot chart or table?
Give this one a try later!
More than one
What does "freezing" do?
Give this one a try later!
Freezing a row or column lets you keep the headings visible as you work
with the data in a large worksheet
What does table styles provide?
Give this one a try later!
A way to quickly format an entire table using a preset style definition
When two or more worksheets have identical row and column layouts, you can?
Give this one a try later!
Give this one a try later!
Secondary Sort Field
What can you add to a Pivot table?
Give this one a try later!
Many levels of subtotals and totals
How do you resize the panes?
,Give this one a try later!
You drag the split bar
Excel adds header with what default name?
Give this one a try later!
Column1 and so on
What does the clear filter command do?
Give this one a try later!
Remove all filters and redisplay all the records
What does the Pivot table use as the column labels?
Give this one a try later!
The data from the Category field
The first row of the range contains field names called?
Give this one a try later!
, Header Row
How many slicers can you create for a Pivot chart or table?
Give this one a try later!
More than one
What does "freezing" do?
Give this one a try later!
Freezing a row or column lets you keep the headings visible as you work
with the data in a large worksheet
What does table styles provide?
Give this one a try later!
A way to quickly format an entire table using a preset style definition
When two or more worksheets have identical row and column layouts, you can?
Give this one a try later!
