Exam 8: Excel : Datasets and Tables

Which table style option is useful to display aggregated data when it is checked?

Excel indicates where page breaks will occur by placing temporary ________ (such as Page 1, Page 2)on your display.

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

You can add a row to a data table as long as you put in the row immediately below the table.

If you use the Color Scale conditional formatting, you are limited to how many colors (and their gradations?)

Excel uses solid blue lines to indicate automatic page breaks.

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

In Normal view or Page Layout view the data to be printed has a dark blue border.

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description: I. Text Contains II. Duplicate Values III. Unique Values IV. Equal To V. Clear Format A. Formats cells that have exactly the same value B. Formats any cell that has content that matches the first content in the first selected cell C. Removes any conditional formatting D. Formats cells that have no matching values E. Formats cells that have the value

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

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

You can freeze as many columns and rows at the same time as you desire.

What is not true about using the AND function in a custom conditional formatting rule?

You can select multiple print areas.

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

What is not true about creating a data table?

Using the data bars conditional formatting, how is the highest value represented?

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

The ________ wildcard symbol is often used in filters and can represent any number of characters.

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