Exam 4: Datasets and Tables

Records are individual pieces of information.

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

What cannot be found on the Manage Rules dialog box?

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

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

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

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

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

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

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

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

In a data table each row is considered a(n)________.

If you wanted to sort the days of the week in their natural order, not alphabetically, you would set up a(n)________ sort.

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.

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

By default Excel prints page in what order?

You cannot sort cells by their fill color.