Exam 8: Excel : Datasets and Tables

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.

The ________ symbol is used in structured references to refer to the current row.

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

A(n)________ is a range of organized, related data.

Excel will allow you to sort on ________ levels.

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

Match the following terms with their description: I. Print area II. Print order III. Page break IV. Freezing V. Conditional formatting A. Where data will print on the next page B. The range of cells that will be printed C. Rules used to emphasize cells D. Keeps certain rows or columns on the screen at all times E. Sequence of printed pages

Match the following table style options with their description: I. Header Row II. Total Row III. First Column IV. Last Column V. Banded Rows A. The formatting of this row\these rows take\takes priority over column formatting. B. Alternate fill colors distinguish one row from another row. C. Makes sure that the row headings stand out D. Displays the field names when checked E. Often used for aggregated data

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

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

Match the following terms with their description: I. Unqualified reference II. Fully qualified structured reference III. Structured reference IV. SUBTOTAL function V. Total row A. Uses a field name as the reference in a table B. Contains the table name C. Field headings without row references D. Displays below the last row in a table E. Calculates an aggregate value

When you use the Freeze Panes option you freezing both columns and rows.

In Page Break Preview, the area to be printed has a light blue background.

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

Which of the following is not a conditional formatting option?

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

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

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

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 the default data table style?