Question 1

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

Accepted Answer

The answer of The ____________________ command automatically inserts a subtotal...

Question 2

The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet.

Accepted Answer

A)  Expansion 
B)  Outline 
C)  Summary 
D)  Function 
A)  Expansion 
B)  Outline 
C)  Summary 
D)  Function

Question 3

If Jamie decides that she wants to work with nonnumeric data in her PivotTable,what function must she use to produce summaries?

Accepted Answer

A)  SUM 
B)  AGGREGATE 
C)  TOTAL 
D)  COUNT 
A)  SUM 
B)  AGGREGATE 
C)  TOTAL 
D)  COUNT

Question 4

In Excel,a collection of similar data can be structured in a(n)____ of rows and columns.

Accepted Answer

A)  index 
B)  glossary 
C)  list 
D)  range 
A)  index 
B)  glossary 
C)  list 
D)  range

Question 5

When you clear a filter,all filters in the worksheet are cleared.

Accepted Answer

A) True 
 B)False

Question 6

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

Accepted Answer

A) True 
 B)False

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A unique label that describes the contents of data in a column

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 PivotTable button is available in the Tables group on the ____ tab.

Accepted Answer

A)  Format 
B)  Design 
C)  Home 
D)  Insert 
A)  Format 
B)  Design 
C)  Home 
D)  Insert

Question 9

You cannot change data directly in the PivotTable.Instead,you must edit the Excel table,and then ____,or update,the PivotTable to reflect the updated data.

Accepted Answer

A)  reset 
B)  refresh 
C)  renew 
D)  change 
A)  reset 
B)  refresh 
C)  renew 
D)  change

Question 10

Which of the following is NOT a valid table name?

Accepted Answer

A)  New_table 
B)  Table2 
C)  _Newtable 
D)  2Table 
A)  New_table 
B)  Table2 
C)  _Newtable 
D)  2Table

Question 11

After you filter a column,the ____ Filter command becomes available so you can remove the filter and redisplay all the records.

Accepted Answer

A)  Remove 
B)  Clear 
C)  Delete 
D)  Archive 
A)  Remove 
B)  Clear 
C)  Delete 
D)  Archive

Question 12

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Enables you to specify various conditions in addition to those that are based on an "equals" criterion

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 13

-Referring to the figure above,the icon shown in cell B118 is the ____ button.

Accepted Answer

A)  QuickCorrect 
B)  AutoSort 
C)  Quick Filter 
D)  AutoCorrect Options 
A)  QuickCorrect 
B)  AutoSort 
C)  Quick Filter 
D)  AutoCorrect Options

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Documentation that lists the fields to be maintained for each record

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 15

One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data.

Accepted Answer

A)  rearrange 
B)  hide 
C)  display 
D)  any of the above 
A)  rearrange 
B)  hide 
C)  display 
D)  any of the above

Question 16

The PivotTable Field List enables you to change,or pivot,the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

Accepted Answer

A) True 
 B)False

Question 17

When you have more than one sort field,you should use the Sort ____ to specify the sort criteria.

Accepted Answer

A)  menu 
B)  status bar 
C)  wizard 
D)  dialog box 
A)  menu 
B)  status bar 
C)  wizard 
D)  dialog box

Question 18

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

Accepted Answer

A)  Or 
B)  Both 
C)  And 
D)  Either 
A)  Or 
B)  Both 
C)  And 
D)  Either

Question 19

When you designate a range as a(n)____,Excel provides the same operations as are available for a structured range of data.

Accepted Answer

A)  table 
B)  catalogue 
C)  index 
D)  roster 
A)  table 
B)  catalogue 
C)  index 
D)  roster

Question 20

Jamie wants to be able to use her PivotTable to combine items into groups.Which of the following is NOT true?

Accepted Answer

A)  Items that appear as row labels cannot be grouped. 
B)  Items that appear as column labels can be grouped. 
C)  If items are dates,they can be grouped automatically using the Grouping dialog box. 
D)  If items are numbers,they can be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu. 
A)  Items that appear as row labels cannot be grouped. 
B)  Items that appear as column labels can be grouped. 
C)  If items are dates,they can be grouped automatically using the Grouping dialog box. 
D)  If items are numbers,they can be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu.

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet.

If Jamie decides that she wants to work with nonnumeric data in her PivotTable,what function must she use to produce summaries?

In Excel,a collection of similar data can be structured in a(n)____ of rows and columns.

When you clear a filter,all filters in the worksheet are cleared.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A unique label that describes the contents of data in a column

The PivotTable button is available in the Tables group on the ____ tab.

You cannot change data directly in the PivotTable.Instead,you must edit the Excel table,and then ____,or update,the PivotTable to reflect the updated data.

Which of the following is NOT a valid table name?

After you filter a column,the ____ Filter command becomes available so you can remove the filter and redisplay all the records.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Enables you to specify various conditions in addition to those that are based on an "equals" criterion

-Referring to the figure above,the icon shown in cell B118 is the ____ button.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Documentation that lists the fields to be maintained for each record

One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data.

The PivotTable Field List enables you to change,or pivot,the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

When you have more than one sort field,you should use the Sort ____ to specify the sort criteria.

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

When you designate a range as a(n)____,Excel provides the same operations as are available for a structured range of data.

Jamie wants to be able to use her PivotTable to combine items into groups.Which of the following is NOT true?

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

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet.

If Jamie decides that she wants to work with nonnumeric data in her PivotTable,what function must she use to produce summaries?

In Excel,a collection of similar data can be structured in a(n)____ of rows and columns.

When you clear a filter,all filters in the worksheet are cleared.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A unique label that describes the contents of data in a column

The PivotTable button is available in the Tables group on the ____ tab.

You cannot change data directly in the PivotTable.Instead,you must edit the Excel table,and then ____,or update,the PivotTable to reflect the updated data.

Which of the following is NOT a valid table name?

After you filter a column,the ____ Filter command becomes available so you can remove the filter and redisplay all the records.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Enables you to specify various conditions in addition to those that are based on an "equals" criterion

-Referring to the figure above,the icon shown in cell B118 is the ____ button.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Documentation that lists the fields to be maintained for each record

One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data.

The PivotTable Field List enables you to change,or pivot,the view of the data in the PivotTable by dragging the field buttons to different areas in the layout section.

When you have more than one sort field,you should use the Sort ____ to specify the sort criteria.

You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria.

When you designate a range as a(n)____,Excel provides the same operations as are available for a structured range of data.

Jamie wants to be able to use her PivotTable to combine items into groups.Which of the following is NOT true?

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