Chapter 4

Question 1

The Freeze Panes option keeps:

Answer 1

both rows and columns above and to the left of the active cell visible as you scroll.

Question 2

A page break:

Answer 2

indicates where data starts on a new printed page.

Question 3

Sorting values smallest to largest:

Answer 3

arranges numbers in sequential order.

Question 4

Filtering:

Answer 4

is the process of displaying only records that meet special conditions.

Question 5

A total row appears as the last row of a table to:

Answer 5

display summary statistics, such as a sum.

Question 6

Which of the following is NOT an advantage of an Excel table over a range of data?

Answer 6

rows can be added or deleted

Question 7

If you have table containing sales data, you could use _____ rules to identify the three highest sales.

Answer 7

top/bottom

Question 8

You can use _____ to highlight or emphasize cells that meet a specific condition.

Answer 8

conditional formating

Question 9

Each row in an Excel table:

Answer 9

represents a record

Question 10

A structured reference:

Answer 10

is a tag or use of a table element, such as a field heading