Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)   Begins With
B)   Includes
C)   Contains
D)   Custom FilterE) B) and C)
F) None of the above

Question 3

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

Accepted Answer

The answer of When you include table names in a...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)   You must convert the table back to a range, add the field, then recreate the table.
B)   You can add it to the right of the data table and Excel will extend the table to include the new field.
C)   You cannot add a new field to an existing data table.
D)   You must insert the new field somewhere inside the existing table, then move the columns to the order you desire.E) B) and D)
F) A) and D)

Question 6

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

Accepted Answer

A)   Reference AutoComplete
B)   Formula AutoComplete
C)   AutoComplete
D)   Nothing automatically displays a list of field headings.E) A) and B)
F) All of the above

Question 7

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

Accepted Answer

The answer of In a structured reference, when you use...

Question 8

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

Accepted Answer

A)   Where data will print on the next page
B)   The range of cells that will be printed
C)   Rules used to emphasize cells
D)   Keeps certain rows or columns on the screen at all times
E)   Sequence of printed pagesF) A) and E)
G) A) and D)

Question 9

Selecting a range automatically makes it a data table.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

The answer of In a data table each row is...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)   Uses a field name as the reference in a table
B)   Contains the table name
C)   Field headings without row references
D)   Displays below the last row in a table
E)   Calculates an aggregate valueF) A) and C)
G) C) and E)

Question 13

What is not true about creating a data table?

Accepted Answer

A)   Each record should be unique somehow.
B)   For efficiency, make sure your data table does not exceed 256 rows.
C)   It is best to put individual data tables on separate sheets.
D)   Delete any blank columns in your table.E) A) and C)
F) None of the above

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Where does Excel display the Total row in a table?

Accepted Answer

A)   At the top of the table
B)   After each subtotal in the table
C)   Two rows below the last row in the table
D)   Below the last row in the tableE) A) and B)
F) All of the above

Question 16

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

Accepted Answer

A) True 
 B)False

Exam 9: Excell: Datasets and Tables

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Selecting a range automatically makes it a data table.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

What is not true about creating a data table?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Where does Excel display the Total row in a table?

Correct Answer
verified

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

Correct Answer
verified

Exam 9: Excell: Datasets and Tables

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Selecting a range automatically makes it a data table.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is not true about creating a data table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Where does Excel display the Total row in a table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified