Exam 4: Datasets and Tables

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

The Table Styles ________ shows you all the table styles which are available.

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

By how many levels will Excel allow you to sort?

If you wanted to sort the days of the week in their natural order,not alphabetically,you would set up a(n)________ sort.

You can add a row to a data table as long as you put in the row immediately below the table.

Which of the following is not a way to bring up the Go To dialog box?

Before you freeze panes make sure the active cell is one row above and one column to the left of the rows and columns you want to freeze.

When you have frozen rows and columns,what happens when you press the Ctrl+Home combination?

Using the Print ________ can help you save paper.

The ________ wildcard symbol is often used in filters and can represent any number of characters.

Which of the following is not a conditional formatting option?

It is impossible to create a data table from random,unorganized data.

It is a good practice to print column and row labels on each page.

You can see how many records meet the conditions of the filter by looking at the ________ bar.

When you set up various conditions with the purpose of only showing a subset of data,that process is called ________.

________ references help to clarify what type of data is being used in any calculations.

If you need to perform complex filters on your data you will want to use the ________ AutoFilter dialog box.

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

What feature in Excel automatically displays a list of field headings when you begin to create a structured reference?