Exam 9: Excell: Datasets and Tables

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

Match the following terms with their description: i. Print area II. Print order III. Page break IV. Freezing v. Conditional formatting

Which one of the following filter options is not found on the text filter submenu?

Match the following terms with their description: i. Unqualified reference II. Fully qualified structured reference III. Structured reference IV. SUBTOTAL function v. Total row

In a structured reference, when you use field headings without row references it is called a(n) ________ reference.

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

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

What is not true about creating a data table?

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

You can freeze as many columns and rows at the same time as you desire.

When you include table names in a structure reference it is called a(n) ________ structured reference.

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

Selecting a range automatically makes it a data table.

Where does Excel display the Total row in a table?

What is true about adding a new field to the right side of an existing data table?

Rows and / or columns which have been deleted in a data table can be brought back with the Undo command.