Exam 9: Excell: Datasets and Tables

Use the Sort by ________ Color if you want to sort records by the color of the text.

________ is the process of arranging records by the value of one or more fields within a table.

In the formula =SUBTOTAL(102,[PAID]), what does the word PAID represent?

What is not true about creating a data table?

A collection of fields about one person would be considered a(n) ________.

Using the Print ________ can help you save paper.

In a data table you can use ________ references in place of cell references inside the formulas.

Data ________ is the organization method used to manage multiple data points within a dataset.

Match the following table style options with their description: i. Header Row II. Total Row III. First Column IV. Last Column v. Banded Rows

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

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

By default, what is the first table on a worksheet named?

Filter arrows are always displayed in data tables.

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

Match the following Data Type Sort Options with their example: i. Sort Z to A II. Sort Oldest to Newest III. Sort Largest to Smallest IV. Sort A to Z v. Sort Newest to Oldest

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.

What is not true about tables in Excel?

To print row labels on the left side of each page you would select the row(s) that contain the labels in the rows to repeat at left box.

What data does Excel print by default?

The use of field headings without row references in a structured formula is called a qualified reference.