Question 1

To what does the @ symbol refer in a structured reference?

Accepted Answer

A)  Current cell
B)  Current table
C)  Current column
D)  Current rowE) All of the above
F) A) and B) D

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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) None of the above
F) B) and C)

Question 4

Use the Sort by ________ Color if you want to sort records by the color of the text.

Accepted Answer

The answer of Use the Sort by ________ Color if...

Question 5

Match between columns
                        Premises: Data bars
Icon Sets
Top/Bottom Rules
Highlight Cells Rules
Color Scales

Accepted Answer

The Answer of Formats cells with gradients of color depending is...

Question 6

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

Accepted Answer

The answer of To go to the first unfrozen cell...

Question 7

Which table style option shows the field names when it is checked?

Accepted Answer

A)  Header Row
B)  Total Row
C)  First Column
D)  Banded ColumnsE) A) and B)
F) A) and C)

Question 8

In a structured reference what do you use to indicate a column heading or field name?

Accepted Answer

A)  Brackets []
B)  Parenthesis () 
C)  Curly brackets {}
D)  Quotes ""E) C) and D)
F) A) and C)

Question 9

Match between columns
                        Premises: Last Column
First Column
Header Row
Banded Rows
Total Row

Accepted Answer

The Answer of Displays the field names when checked and is...

Question 10

Using the Print ________ can help you save paper.

Accepted Answer

The answer of Using the Print ________ can help you...

Question 11

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 D)
F) A) and C)

Question 12

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

Accepted Answer

The answer of The Table Styles ________ shows you all...

Question 13

In a data table you can use ________ references in place of cell references inside the formulas.

Accepted Answer

structured

Question 14

In conditional formatting what happens if the cell value does not pass the logical test?

Accepted Answer

A)  The cell is formatted however you have determined for the FALSE result.
B)  The cell is formatted with Excel's default FALSE format.
C)  The cell is not formatted.
D)  A small green triangle displays in the top-left corner of the cell.E) A) and B)
F) B) and C)

Question 15

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) All of the above
F) A) and D)

Question 16

Which of the following is not a characteristic of a table?

Accepted Answer

A)  Can contain multiple ranges
B)  Helps to manage information
C)  Helps to analyze information
D)  Contains related dataE) A) and C)
F) B) and C)

Question 17

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

Accepted Answer

A)  First Quarter
B)  Tomorrow
C)  Between
D)  Last MonthE) A) and B)
F) A) and C)

Question 18

The print ________ is the range of cells that will be printed.

Accepted Answer

The answer of The print ________ is the range of...

Question 19

Which of the following is not a conditional formatting option?

Accepted Answer

A)  Data bars
B)  Color Scales
C)  Icon Sets
D)  Table formatE) A) and B)
F) C) and D)

Question 20

To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.

Accepted Answer

A) True 
 B)False

Exam 4: Datasets and Tables

To what does the @ symbol refer in a structured reference?

Correct Answer
verified
D

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

Correct Answer
verified

Where does Excel display the Total row in a table?

Correct Answer
verified

Use the Sort by ________ Color if you want to sort records by the color of the text.

Correct Answer
verified

Match the following Conditional Formatting Options with their description:

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

Correct Answer
verified

Which table style option shows the field names when it is checked?

Correct Answer
verified

In a structured reference what do you use to indicate a column heading or field name?

Correct Answer
verified

Match the following table style options with their description:

Using the Print ________ can help you save paper.

Correct Answer
verified

What is not true about creating a data table?

Correct Answer
verified

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

Correct Answer
verified

In a data table you can use ________ references in place of cell references inside the formulas.

Correct Answer
verified
structured

In conditional formatting what happens if the cell value does not pass the logical test?

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 of the following is not a characteristic of a table?

Correct Answer
verified

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

Correct Answer
verified

The print ________ is the range of cells that will be printed.

Correct Answer
verified

Which of the following is not a conditional formatting option?

Correct Answer
verified

To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.

Correct Answer
verified

Exam 4: Datasets and Tables

To what does the @ symbol refer in a structured reference?

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

Where does Excel display the Total row in a table?

Correct AnswerverifiedShow Answer

Use the Sort by ________ Color if you want to sort records by the color of the text.

Correct AnswerverifiedShow Answer

Match the following Conditional Formatting Options with their description:

To go to the first unfrozen cell you would press Ctrl+________ at the same time.

Correct AnswerverifiedShow Answer

Which table style option shows the field names when it is checked?

Correct AnswerverifiedShow Answer

In a structured reference what do you use to indicate a column heading or field name?

Correct AnswerverifiedShow Answer

Match the following table style options with their description:

Using the Print ________ can help you save paper.

Correct AnswerverifiedShow Answer

What is not true about creating a data table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a data table you can use ________ references in place of cell references inside the formulas.

Correct Answerverifiedstructured

In conditional formatting what happens if the cell value does not pass the logical test?

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 of the following is not a characteristic of a table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The print ________ is the range of cells that will be printed.

Correct AnswerverifiedShow Answer

Which of the following is not a conditional formatting option?

Correct AnswerverifiedShow Answer

To print row labels on the left side of each page you would select the row(s)that contain the labels in the rows to repeat at left box.

Correct AnswerverifiedShow Answer

Correct Answer
verified
D

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
structured

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified