Exam 4: Datasets and Tables

You can select multiple print areas.

When you set up various conditions with the purpose of only showing a subset of data, that process is called ________.

Excel uses dashed blue lines to indicate manual page breaks.

If you wanted several cells to be filled with a certain color where the width of the fill color in the cell represents that cell's value compared to the values in the other cells, you would use the Data ________ conditional formatting option.

On which tab will you find options if you have to print a large dataset?

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

In Page Break Preview, the area to be printed has a light blue background.

In a structured reference, when you use field headings without row references it is called a(n)________ reference.

In a data table calculated columns will copy down the table automatically.

How does Excel indicate that a column has been selected in a structured reference?

Table ________ add color and borders to a table.

When you include table names in a structure reference it is called a(n)________ structured reference.

What data does Excel print by default?

Rows and/or columns which have been deleted in a data table can be brought back with the Undo command.

Which wildcard character only replaces one character with one other character?

By default, what is the first table on a worksheet named?

This could be a valid formula in Excel: =[@Cost]-[@Pre_Paid_Taxes].

What is not true about tables in Excel?

The ________ symbol is used in structured references to refer to the current row.

Which one of the following filter options is not found on the number filter submenu?