Question 1

In a data table calculated columns will copy down the table automatically.

Accepted Answer

A) True 
 B)False

Question 2

Which wildcard character only replaces one character with one other character?

Accepted Answer

A)  Question Mark ?
B)  Asterisk *
C)  Number sign #
D)  Tilde ~E) A) and B)
F) A) and C)

Question 3

Match between columns
                        Premises: Unique Values
Equal To
Duplicate Values
Text Contains
Clear Format

Accepted Answer

The Answer of Formats cells that have the value and is...

Question 4

Match between columns
                        Premises: Icon set
Sorting
Color scale
Filtering
Data bars

Accepted Answer

The Answer of Using conditions to limit the visible data is...

Question 5

Records are individual pieces of information.

Accepted Answer

A) True 
 B)False

Question 6

Locking is the process of making sure that certain rows or columns are visible at all times.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Excel will allow you to sort on ________ levels.

Accepted Answer

64,sixty-f...

Question 9

If you wanted several cells to be filled with a certain color where the width of the fill color in the cell represents that cell's value compared to the values in the other cells,you would use the Data ________ conditional formatting option.

Accepted Answer

The answer of If you wanted several cells to be...

Question 10

By default Excel prints page in what order?

Accepted Answer

A)  Top-left section,top-right section,bottom-left section,and bottom-right section
B)  All the odd numbered pages,then all the even numbered pages
C)  All the even numbered pages,then all the odd numbered pages
D)  Top-left section,bottom-left section,top-right section,and bottom-right sectionE) C) and D)
F) A) and B)

Question 11

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

Question 12

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

Question 13

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

Accepted Answer

A)  Top/Bottom Rules
B)  Highlight Cells Rules
C)  Between Values Rules
D)  Color ScalesE) A) and B)
F) A) and C)

Question 14

Match between columns
                        Premises: AVERAGE
COUNTA
MIN
MAX
SUM

Accepted Answer

The Answer of 105 and 101 and 109 and 103 is...

Question 15

Match between columns
                        Premises: Fully qualified structured reference
SUBTOTAL function
Structured reference
Total row
Unqualified reference

Accepted Answer

The Answer of Calculates an aggregate value and Uses a is...

Question 16

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

Accepted Answer

A)  Current cell
B)  Current table
C)  Current column
D)  Current rowE) B) and C)
F) A) and D)

Question 17

If you wanted every cell that has a value over $1,251 to have a purple fill,you would use what feature in Excel?

Accepted Answer

A)  Conditional formatting
B)  AutoFill formatting
C)  AutoComplete formatting
D)  Aggregate Cell formattingE) C) and D)
F) None of the above

Question 18

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

Accepted Answer

A)  Greater Than...
B)  Between...
C)  Below Average
D)  Bottom 10...E) B) and D)
F) All of the above

Question 19

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

Question 20

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

Accepted Answer

A) True 
 B)False

Exam 4: Datasets and Tables

By default Excel prints page in what order?

Correct Answer
verified

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

Correct Answer
verified

Where does Excel display the Total row in a table?

Correct Answer
verified

Match the following terms with their description:

If you wanted every cell that has a value over $1,251 to have a purple fill,you would use what feature in Excel?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Records are individual pieces of information.

Correct Answer
verified

Locking is the process of making sure that certain rows or columns are visible at all times.

Correct Answer
verified

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

Correct Answer
verified

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

Correct Answer
verified

Which wildcard character only replaces one character with one other character?

Correct Answer
verified

Match the following Subtotal Function with their Table Numbers:

Excel will allow you to sort on ________ levels.

Correct Answer
verified
64,sixty-f...
View Answer

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

Correct Answer
verified

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:

In a data table calculated columns will copy down the table automatically.

Correct Answer
verified

If you wanted several cells to be filled with a certain color where the width of the fill color in the cell represents that cell's value compared to the values in the other cells,you would use the Data ________ conditional formatting option.

Correct Answer
verified

Match the following terms with their description:

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

Correct Answer
verified

Exam 4: Datasets and Tables

By default Excel prints page in what order?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Where does Excel display the Total row in a table?

Correct AnswerverifiedShow Answer

Match the following terms with their description:

If you wanted every cell that has a value over $1,251 to have a purple fill,you would use what feature in Excel?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Records are individual pieces of information.

Correct AnswerverifiedShow Answer

Locking is the process of making sure that certain rows or columns are visible at all times.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which conditional formatting option would you choose if you wanted to apply formatting to cells whose value falls between two numbers?

Correct AnswerverifiedShow Answer

Which wildcard character only replaces one character with one other character?

Correct AnswerverifiedShow Answer

Match the following Subtotal Function with their Table Numbers:

Excel will allow you to sort on ________ levels.

Correct Answerverified64,sixty-f...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Match the following Conditional Formatting Options in the Quick Analysis Gallery with their description:

In a data table calculated columns will copy down the table automatically.

Correct AnswerverifiedShow Answer

If you wanted several cells to be filled with a certain color where the width of the fill color in the cell represents that cell's value compared to the values in the other cells,you would use the Data ________ conditional formatting option.

Correct AnswerverifiedShow Answer

Match the following terms with their description:

Even if panes are frozen pressing Ctrl+Home will still make A1 the active cell.

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
64,sixty-f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified