Exam 4: Datasets and Tables

To what does the @ symbol refer in a structured reference?

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

Excel will allow you to sort on ________ levels.

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

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

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.

By default Excel prints page in what order?

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

Records are individual pieces of information.

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

Where does Excel display the Total row in a table?

What is true about adding a new field to the right side of an existing data table?

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

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

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

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