FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 8: Excel : Datasets and Tables

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Short Answer

Review LaterAdd Note

Review Later

Excel will allow you to sort on ________ levels.

Correct Answer

verified

64, sixty-...

View Answer

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Current cell
B) Current table
C) Current column
D) Current row

E) B) and C)
F) None of the above

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

Which of the following is not a conditional formatting option?

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.

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.

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

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

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

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

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

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

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

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

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

What is the default data table style?

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

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

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.