Data Quiz

One way to make sure the header row always displays when scrolling the worksheet is to

• Freeze the Row
• Split the worksheet

How can you reorganize a worksheet?

• Sort the data
• Freeze the rows or columns

What can be used to narrow down the data in your worksheet?

• Filter
• Sort

To ungroup data, all that is necessary is click the Ungroup command.

• True
• False

The Subtotal command allows you to automatically create groups and use common functions like _____, _______, and ________ to help summarize your data.

• Sum, COUNT, and AVERAGE
• Freeze, Sort, Filter

What must be done before subtotaling data?

• Ensure the data is correctly sorted.
• Ensure the data is correctly filtered

Using the subtotal command creates a(n) _______ for the worksheet.

• Group
• Outline

Data in your worksheet can be formatted as a table.

• True
• False

Charts allow you to illustrate your workbook data 

• Graphically
• Visually

In order to use charts effectively, you'll need to understand how different charts are used.

• True
• False