Which option allows you to choose different Chart style options?

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

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

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

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

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

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?

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

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

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

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?