Exam 9: Excell: Datasets and Tables

By default, Excel prints page in what order?

The print ________ is the range of cells that will be printed.

Which of the following is not a conditional formatting option?

Excel uses dashed blue lines to indicate manual page breaks.

You can manually adjust a page break by pointing to the page break line and waiting for the four-headed arrow to appear, then drag the page break to your desired location.

A(n) ________ is a range of organized, related data.

Locking is the process of making sure that certain rows or columns are visible at all times.

________ is the process of keeping rows and / or columns visible onscreen at all times even when you scroll through a large dataset.

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

Table ________ add color and borders to a table.

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

________ references help to clarify what type of data is being used in any calculations.

"John Smith" is a good example of a field.

It is a good practice to print column and row labels on each page.

You can see how many records meet the conditions of the filter by looking at the ________ bar.

The Print ________ defines what cells will print.

In conditional formatting what happens if the cell value does not pass the logical test?

In a structured reference what do you use to indicate a column heading or field name?

If you wanted every cell that has a value over $1,251 to have a purple fill, you would use what feature in Excel?

When you enter a structured reference in a formula Excel copies that formula down the rest of the column automatically.