State whether true or false:

When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.

Which scoping method should be used to conditionally format a set of fields in the values area for all levels in the hierarchy of data?

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.

How should blank cells be inserted on a Worksheet?

Which Lookup function should be used when the comparison values are located in a column to the left of the data that is to be found?

Which keyboard shortcut should be used to minimize or restore the ribbon?

How do you create a range for a sum function that anchors itself on A1, but will increase in range downwards as you drag and drop the formula?

Cell A1 contains the formula =$F39. Copying that formula to cell B2 will result in:

What's one way of clearing the effect of a slicer that you've applied?

What is the maximum number of columns allowable in an Excel worksheet?

In a selected column-layout PivotChart, what's one way to swap which fields are listed across the horizontal axis, and which fields are listed in the legend?