Exam 9: Excell: Datasets and Tables

Match the following Conditional Formatting Options with their description: i. Highlight Cells Rules II. Top / Bottom Rules III. Data bars IV. Color Scales v. Icon Sets

Data ________ define how information is stored, organized, and accessed.

Data ________ is the method used to organize data points in a dataset.

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

Which conditional formatting option is not found in the Quick Analysis Gallery?

Match the following terms with their description: i. Field II. Record III. Table IV. Table style v. Total row

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

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

Match the following Subtotal Function with their Table Numbers: i. AVERAGE II. MAX III. MIN IV. SUM v. COUNTA

Which of the following is not a characteristic of a table?

If you need to perform complex filters on your data you will want to use the ________ AutoFilter dialog box.

________ page breaks can be inserted if the automatic page breaks would occur at undesirable places.

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

After a table has been named, that name can be used in functions instead of cell references.

You can sort cells by their fill color.

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

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

By how many levels will Excel allow you to sort?

The filter "Begins With..." option is found on which type of filter?

When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?