What causes the Auto Outline feature to group some columns and rows, but not others?

Let's say you have a PivotTable with separate rows of sales from January to December. What's a quick way to further summarize the monthly data?

Which feature lets you see two sheets of a workbook on screen simultaneously, so you don't have to switch back and forth?

To store a macro in a workbook or template, what file extension must you save the file in?

Which of the following is an example of how you would use a data table?

One column of your PivotTables lists 500 dates over 2 years. How can you interactively filter the table to show just a range of dates?

How can you delete the contents of a cell and its formatting at the same time?

What is the setting that is the default macro security setting?

To insert a chart for data in a table, select any cell in the table and then choose ____

Which table option gives you different background color for odd/even rows?

To create a drop down list box which only allows you to choose the value defined in range O1:O12 you need to setup: