One of the benefits of live preview is that it _____.

A(n) ____ is an entry in a cell that contains text such as 2016 sales or travel expenses.

In pivottables, ____ fields correspond to columns in the original data.

The summary function that calculates the smallest data value in a pivottable report is ____.

Panes created using the vertical split bar scroll together horizontally. ________________________

Identify all the arguments and the correct order of arguments needed to execute the IF() function.

If there are duplicate items in a list, the COUNT function will not include the duplicates in the total count of items.

Which button allows you to copy cell formats from one cell to another?

Your PivotTable shows 20 products listed down column A. How can you make only the first 10 visible, and the rest of the products hidden?

What company distributes Excel?