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?

To split a single column into multiple columns based on delimiters or fixed width you may use which option?

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?

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