Question 1

You can create at most one Excel table in a worksheet.

Accepted Answer

A) True 
 B)False  False

Question 2

-The entry 20000 is the ________________ for the first condition.

Accepted Answer

criterion

Question 3

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion._________________________

Accepted Answer

A) True 
 B)False  False

Question 4

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.

Accepted Answer

The answer of The benefit of a(n)____________________ is that it...

Question 5

The second sort field in a sort is called the ____________________ field.

Accepted Answer

The answer of The second sort field in a sort...

Question 6

-Referring to the figure above,the phrase "is greater than" is the criteria for the first condition.________________

Accepted Answer

A) True 
 B)False

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used to group and summarize a list into a concise,tabular format

Accepted Answer

A) table 
B) field 
C) record 
D) freeze 
E) sort field
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
K)custom list
L)criteria filter 
A) table 
B) field 
C) record 
D) freeze 
E) sort field
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
K)custom list
L)criteria filter

Question 8

The ____ condition requires that only one of the selected criteria be true for a record to be displayed.

Accepted Answer

A)  NAND 
B)  OR 
C)  AND 
D)  IF 
A)  NAND 
B)  OR 
C)  AND 
D)  IF

Question 9

In addition to data fields,a PivotTable uses ____________________ fields to groups values such as department,model,year,and vehicle type in an automobile-related sheet,for example.

Accepted Answer

The answer of In addition to data fields,a PivotTable uses...

Question 10

Separate the data (including the header row)from other information in the worksheet by at least ________________ blank row and one blank column.

Accepted Answer

The answer of Separate the data (including the header row)from...

Question 11

After data is filtered,you can ____ it.

Accepted Answer

A)  sort 
B)  chart 
C)  copy 
D)  all of the above 
A)  sort 
B)  chart 
C)  copy 
D)  all of the above

Question 12

You can use the ____ tab to change the SUM function to a different summary function,in a PivotTable.

Accepted Answer

A)  New Function 
B)  Change Function 
C)  Summarize Values by 
D)  Summary function 
A)  New Function 
B)  Change Function 
C)  Summarize Values by 
D)  Summary function

Question 13

To show items hidden in a PivotTable,you click the Show tab and check the check box for the item you want to show.

Accepted Answer

A) True 
 B)False

Question 14

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box,and checking the ____ check box.

Accepted Answer

A)  Exact match 
B)  Match entire cell contents 
C)  Complete cell 
D)  Precise match to entire cell 
A)  Exact match 
B)  Match entire cell contents 
C)  Complete cell 
D)  Precise match to entire cell

Question 15

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To temporarily hide all the records that do not meet your criteria

Accepted Answer

A) table 
B) field 
C) record 
D) freeze 
E) sort field
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
K)custom list
L)criteria filter 
A) table 
B) field 
C) record 
D) freeze 
E) sort field
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
K)custom list
L)criteria filter

Question 16

Case-Based Critical Thinking Questions
Case 5-1
You are tutoring a fellow student who is new to the more advanced features of Excel..
-Which of the following is NOT a feature that is unique to Excel tables (as opposed to structured ranges of data)?

Accepted Answer

A)  You can format quickly using a table style. 
B)  You can enter a formula in one table cell that is automatically copied to all other cells in that table column. 
C)  You can add new rows and columns that automatically expand the range. 
D)  You can freeze the top row of the worksheet. 
A)  You can format quickly using a table style. 
B)  You can enter a formula in one table cell that is automatically copied to all other cells in that table column. 
C)  You can add new rows and columns that automatically expand the range. 
D)  You can freeze the top row of the worksheet.

Question 17

You can format cells in a PivotTable the same way as you do cells in the worksheet.

Accepted Answer

A) True 
 B)False

Question 18

-In the accompanying figure,"Installation," "Sculpture," and "Textile" are all part of the list of ____ options.

Accepted Answer

A)  selection 
B)  filtering 
C)  custom 
D)  query 
A)  selection 
B)  filtering 
C)  custom 
D)  query

Question 19

Jamie wants to be able to analyze date data in her PivotTable by month.What must she do with the date field in her PivotTable?

Accepted Answer

A)  She must aggregate the data by the date field. 
B)  She must cluster the data by the date field. 
C)  She must sort the data by the date field. 
D)  She must group the data by the date field. 
A)  She must aggregate the data by the date field. 
B)  She must cluster the data by the date field. 
C)  She must sort the data by the date field. 
D)  She must group the data by the date field.

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A range of related data managed independently from the data in other rows and columns in the worksheet

Accepted Answer

A) table 
B) field 
C) record 
D) freeze 
E) sort field
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
K)custom list
L)criteria filter 
A) table 
B) field 
C) record 
D) freeze 
E) sort field
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort
K)custom list
L)criteria filter

You can create at most one Excel table in a worksheet.

-The entry 20000 is the ________________ for the first condition.

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion._________________________

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.

The second sort field in a sort is called the ____________________ field.

-Referring to the figure above,the phrase "is greater than" is the criteria for the first condition.________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to group and summarize a list into a concise,tabular format

The ____ condition requires that only one of the selected criteria be true for a record to be displayed.

In addition to data fields,a PivotTable uses ____________________ fields to groups values such as department,model,year,and vehicle type in an automobile-related sheet,for example.

Separate the data (including the header row)from other information in the worksheet by at least ________________ blank row and one blank column.

After data is filtered,you can ____ it.

You can use the ____ tab to change the SUM function to a different summary function,in a PivotTable.

To show items hidden in a PivotTable,you click the Show tab and check the check box for the item you want to show.

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box,and checking the ____ check box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To temporarily hide all the records that do not meet your criteria

Case-Based Critical Thinking Questions Case 5-1 You are tutoring a fellow student who is new to the more advanced features of Excel.. -Which of the following is NOT a feature that is unique to Excel tables (as opposed to structured ranges of data)?

You can format cells in a PivotTable the same way as you do cells in the worksheet.

-In the accompanying figure,"Installation," "Sculpture," and "Textile" are all part of the list of ____ options.

Jamie wants to be able to analyze date data in her PivotTable by month.What must she do with the date field in her PivotTable?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A range of related data managed independently from the data in other rows and columns in the worksheet

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 5: Working With Excel Tables, Pivot-tables, and Pivot-charts

You can create at most one Excel table in a worksheet.

-The entry 20000 is the ________________ for the first condition.

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion._________________________

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.

The second sort field in a sort is called the ____________________ field.

-Referring to the figure above,the phrase "is greater than" is the criteria for the first condition.________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to group and summarize a list into a concise,tabular format

The ____ condition requires that only one of the selected criteria be true for a record to be displayed.

In addition to data fields,a PivotTable uses ____________________ fields to groups values such as department,model,year,and vehicle type in an automobile-related sheet,for example.

Separate the data (including the header row)from other information in the worksheet by at least ________________ blank row and one blank column.

After data is filtered,you can ____ it.

You can use the ____ tab to change the SUM function to a different summary function,in a PivotTable.

To show items hidden in a PivotTable,you click the Show tab and check the check box for the item you want to show.

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box,and checking the ____ check box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To temporarily hide all the records that do not meet your criteria

Case-Based Critical Thinking Questions Case 5-1 You are tutoring a fellow student who is new to the more advanced features of Excel.. -Which of the following is NOT a feature that is unique to Excel tables (as opposed to structured ranges of data)?

You can format cells in a PivotTable the same way as you do cells in the worksheet.

-In the accompanying figure,"Installation," "Sculpture," and "Textile" are all part of the list of ____ options.

Jamie wants to be able to analyze date data in her PivotTable by month.What must she do with the date field in her PivotTable?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A range of related data managed independently from the data in other rows and columns in the worksheet

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters