Question 1

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

Accepted Answer

A)  Display Function 
B)  Insert Function 
C)  Add Function 
D)  New Function 
A)  Display Function 
B)  Insert Function 
C)  Add Function 
D)  New Function

Question 2

To freeze a row,select the cell below the row(s)you want to freeze,click the ____________________ button in the Window group and then click Freeze Top Row.

Accepted Answer

The answer of To freeze a row,select the cell below...

Question 3

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The field you use to order your data

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 4

-In the figure above,if you only want to set one criterion for this filter,you'll ____.

Accepted Answer

A)  leave the lower boxes empty 
B)  enter "0" into the lower boxes 
C)  enter "none" into the lower boxes 
D)  access a pull-down menu of options 
A)  leave the lower boxes empty 
B)  enter "0" into the lower boxes 
C)  enter "none" into the lower boxes 
D)  access a pull-down menu of options

Question 5

A(n)____________________ filter allows you to filter the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.

Accepted Answer

The answer of A(n)____________________ filter allows you to filter the...

Question 6

To add a sort field in the Sort dialog box,click the ____ button.

Accepted Answer

A)  Add Level 
B)  Add Field 
C)  New Sort Field 
D)  New Level 
A)  Add Level 
B)  Add Field 
C)  New Sort Field 
D)  New Level

Question 7

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

Accepted Answer

A)  Hiding 
B)  Freezing 
C)  Showing 
D)  Sealing 
A)  Hiding 
B)  Freezing 
C)  Showing 
D)  Sealing

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To keep headings visible as you work with the data in a large 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

Question 9

When you filter your data,all records that do not meet your criteria are temporarily hidden from view.

Accepted Answer

A) True 
 B)False

Question 10

Criteria filters allow you to specify relationships other than those that are based on a(n)"____" the criterion.

Accepted Answer

A)  in 
B)  like 
C)  greater than 
D)  equals 
A)  in 
B)  like 
C)  greater than 
D)  equals

Question 11

When you delete a record from a table,a dialog box displays to confirm the delete operation.

Accepted Answer

A) True 
 B)False

Question 12

Each column represents a record that describes some attribute or characteristic of a person,place,or thing._________________________

Accepted Answer

A) True 
 B)False

Question 13

Case-Based Critical Thinking Questions
Case 5-1
You are tutoring a fellow student who is new to the more advanced features of Excel..
-Your tutee has a lot of familiarity with ranges from an earlier Excel class,but he knows that there is an alternative that will give him access to additional features that he does not have with a cell range.What is that option?

Accepted Answer

A)  Convert the range to a table. 
B)  Convert the range to an index. 
C)  Convert the range to a PivotChart. 
D)  The tutee is wrong;the range has any many features as any Excel alternative. 
A)  Convert the range to a table. 
B)  Convert the range to an index. 
C)  Convert the range to a PivotChart. 
D)  The tutee is wrong;the range has any many features as any Excel alternative.

Question 14

Critical Thinking Case-Based Questions
Case 5-3
As she prepares her assignment for her Business Management class,Jamie goes to her friend Charlie for help with PivotTables because he has had a lot of experience with them in his job.
-Which of the following is NOT a true statement Charlie can make to Jamie about PivotTables?

Accepted Answer

A)  To remove a field from a PivotTable,you click the field's check box in the PivotTable Field list. 
B)  You can rename a value label by typing the new text directly in any cell where the value label appears in the PivotTable. 
C)  Removing a field from the PivotTable changes the underlying Excel table. 
D)  All of the above statements are true. 
A)  To remove a field from a PivotTable,you click the field's check box in the PivotTable Field list. 
B)  You can rename a value label by typing the new text directly in any cell where the value label appears in the PivotTable. 
C)  Removing a field from the PivotTable changes the underlying Excel table. 
D)  All of the above statements are true.

Question 15

You can calculate sort statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table._________________________

Accepted Answer

A) True 
 B)False

Question 16

When the Subtotals feature "outlines" your worksheet,by default,the highest level is active._________________________

Accepted Answer

A) True 
 B)False

Question 17

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A column within an Excel range

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 18

The fields you use to order the data in a list are sort fields._________________________

Accepted Answer

A) True 
 B)False

Question 19

You can use up to ____ sort fields in a single sort.

Accepted Answer

A)  12 
B)  24 
C)  32 
D)  64 
A)  12 
B)  24 
C)  32 
D)  64

Question 20

Case-Based Critical Thinking Questions
Case 5-2
Simon has just discovered the power of using text filters to control which records display in his worksheet,and he has begun to use them often to find precisely the records he needs.The following questions are based on a staff directory table that includes First Name,Last Name,Office Number,Department Name,and Phone Number.
-If Simon wants to find all of his colleagues whose last names end in "berg" (such as Goldberg and Steenberg),what should he do?

Accepted Answer

A)  Create a text filter using the Ends With operator to display all records that have dberg as the last characters in the text value. 
B)  Create a text filter using the Contains operator to display all records that include berg in the text value. 
C)  Create a text filter using the Ends With operator to display all records that have berg as the last characters in the text value. 
D)  Create a text filter using the Contains operator to display all records that have berg as the last characters in the text value. 
A)  Create a text filter using the Ends With operator to display all records that have dberg as the last characters in the text value. 
B)  Create a text filter using the Contains operator to display all records that include berg in the text value. 
C)  Create a text filter using the Ends With operator to display all records that have berg as the last characters in the text value. 
D)  Create a text filter using the Contains operator to display all records that have berg as the last characters in the text value.

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

To freeze a row,select the cell below the row(s)you want to freeze,click the ____________________ button in the Window group and then click Freeze Top Row.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The field you use to order your data

-In the figure above,if you only want to set one criterion for this filter,you'll ____.

A(n)____________________ filter allows you to filter the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.

To add a sort field in the Sort dialog box,click the ____ button.

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To keep headings visible as you work with the data in a large worksheet

When you filter your data,all records that do not meet your criteria are temporarily hidden from view.

Criteria filters allow you to specify relationships other than those that are based on a(n)"____" the criterion.

When you delete a record from a table,a dialog box displays to confirm the delete operation.

Each column represents a record that describes some attribute or characteristic of a person,place,or thing._________________________

You can calculate sort statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table._________________________

When the Subtotals feature "outlines" your worksheet,by default,the highest level is active._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A column within an Excel range

The fields you use to order the data in a list are sort fields._________________________

You can use up to ____ sort fields in a single sort.

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 click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

To freeze a row,select the cell below the row(s)you want to freeze,click the ____________________ button in the Window group and then click Freeze Top Row.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The field you use to order your data

-In the figure above,if you only want to set one criterion for this filter,you'll ____.

A(n)____________________ filter allows you to filter the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.

To add a sort field in the Sort dialog box,click the ____ button.

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To keep headings visible as you work with the data in a large worksheet

When you filter your data,all records that do not meet your criteria are temporarily hidden from view.

Criteria filters allow you to specify relationships other than those that are based on a(n)"____" the criterion.

When you delete a record from a table,a dialog box displays to confirm the delete operation.

Each column represents a record that describes some attribute or characteristic of a person,place,or thing._________________________

You can calculate sort statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table._________________________

When the Subtotals feature "outlines" your worksheet,by default,the highest level is active._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A column within an Excel range

The fields you use to order the data in a list are sort fields._________________________

You can use up to ____ sort fields in a single sort.

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