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?

Which of the following is not a predefined replacement for the [format] portion of the following expression? FORMAT (expression, [format])

By default, all cells in a workbook are:

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:

Which option allows you to choose different Chart style options?

What could you do to stop the pivot table from losing the column width upon refreshing?