What VLOOKUP parameter provides the multicolumn range or name of the range or date table to be searched?

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?

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

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?