Page 7 of 8PREVNEXT

Use Excel tables to manage information

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.


You can sort more than one column at a time.

True.

False.

You can filter more than one column at a time.

True.

False.

To fill a formula down a column, you copy and paste it from the first cell into the other cells in the column.

True.

False.

As you type a formula in a table, to see a list of the column names to enter into the formula, type a parenthesis (.

True.

False.

What does it mean when you see a small upward pointing arrow on the drop-down button at the top of a column?

The column is filtered.

The column is sorted.

Page 7 of 8PREVNEXT