Question 1

You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

Accepted Answer

A)  Home 
B)  View 
C)  Table Tools Design 
D)  PivotTable 
A)  Home 
B)  View 
C)  Table Tools Design 
D)  PivotTable

Question 2

What are the steps for sorting data using multiple fields?

Accepted Answer

Click any cell in a table or range.In th

Question 3

The ____ criteria filter requires the records displayed to start with the specified text string.

Accepted Answer

A)  Origin 
B)  Begins With 
C)  Initial 
D)  Start 
A)  Origin 
B)  Begins With 
C)  Initial 
D)  Start

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Indicates the sequence in which you want data ordered

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 5

A table name can include all of the following EXCEPT ____

Accepted Answer

A)  numbers 
B)  spaces 
C)  underscores 
D)  letters 
A)  numbers 
B)  spaces 
C)  underscores 
D)  letters

Question 6

Table names cannot include underscores._________________________

Accepted Answer

A) True 
 B)False

Question 7

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.
-To find anyone whose department name is either Transaction Processing,Processing Operations,or Records Processing,what should he do?

Accepted Answer

A)  Create a text filter using the Contains operator to display all records that have Operations anywhere in the text value. 
B)  Create a text filter using the Ends With operator to display all records that have Processing as the last characters in the text value. 
C)  Create a text filter using the Begins With operator to display all records that have Processing as the first characters in the text value. 
D)  Create a text filter using the Contains operator to display all records that have Processing anywhere in the text value. 
A)  Create a text filter using the Contains operator to display all records that have Operations anywhere in the text value. 
B)  Create a text filter using the Ends With operator to display all records that have Processing as the last characters in the text value. 
C)  Create a text filter using the Begins With operator to display all records that have Processing as the first characters in the text value. 
D)  Create a text filter using the Contains operator to display all records that have Processing anywhere in the text value.

Question 8

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

Accepted Answer

A)  Remove Level 
B)  Delete Level 
C)  Descend Level 
D)  Delete Field 
A)  Remove Level 
B)  Delete Level 
C)  Descend Level 
D)  Delete Field

Question 9

In addition to displaying subtotals,the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

Accepted Answer

A)  headers 
B)  outlines 
C)  shadows 
D)  defines 
A)  headers 
B)  outlines 
C)  shadows 
D)  defines

Question 10

The Summary command automatically inserts a subtotal line into the list for each group of data in the list._________________________

Accepted Answer

A) True 
 B)False

Question 11

The header row must be row 1.

Accepted Answer

A) True 
 B)False

Question 12

If you freeze the top row in a worksheet and press Ctrl+Home,you will return to the cell directly above the frozen row.

Accepted Answer

A) True 
 B)False

Question 13

The ____________________ criteria filter requires that the records displaying begin with the specified text string.

Accepted Answer

The answer of The ____________________ criteria filter requires that the...

Question 14

PivotTable data can be a(n)____.

Accepted Answer

A)  an Access database file 
B)  an Excel table in the current workbook 
C)  an Excel range in the current workbook 
D)  any of the above 
A)  an Access database file 
B)  an Excel table in the current workbook 
C)  an Excel range in the current workbook 
D)  any of the above

Question 15

You can sort by ____.

Accepted Answer

A)  cell color 
B)  font color 
C)  cell icon 
D)  all of the above 
A)  cell color 
B)  font color 
C)  cell icon 
D)  all of the above

Question 16

A(n)____________________ list indicates the sequence in which you want data ordered.

Accepted Answer

The answer of A(n)____________________ list indicates the sequence in which...

Question 17

The first sort field in a sort is called the major sort field._________________________

Accepted Answer

A) True 
 B)False

Question 18

By default,the PivotTable report uses the ____ function for numbers in the Values area.

Accepted Answer

A)  COUNT 
B)  AVERAGE 
C)  MIN 
D)  SUM 
A)  COUNT 
B)  AVERAGE 
C)  MIN 
D)  SUM

Question 19

-In the figure above,the 20,000 indicates the price of a piece of artwork.Records with artwork with the following values meet the criteria: ____.

Accepted Answer

A)  $19,999 
B)  $20,000 
C)  $20,001 
D)  all of the above 
A)  $19,999 
B)  $20,000 
C)  $20,001 
D)  all of the above

Question 20

If a column consists of day or month labels,you can sort them in their correct chronological order using one of the predefined custom lists._________________________

Accepted Answer

A) True 
 B)False

You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

What are the steps for sorting data using multiple fields?

The ____ criteria filter requires the records displayed to start with the specified text string.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates the sequence in which you want data ordered

A table name can include all of the following EXCEPT ____

Table names cannot include underscores._________________________

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

In addition to displaying subtotals,the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

The Summary command automatically inserts a subtotal line into the list for each group of data in the list._________________________

The header row must be row 1.

If you freeze the top row in a worksheet and press Ctrl+Home,you will return to the cell directly above the frozen row.

The ____________________ criteria filter requires that the records displaying begin with the specified text string.

PivotTable data can be a(n)____.

You can sort by ____.

A(n)____________________ list indicates the sequence in which you want data ordered.

The first sort field in a sort is called the major sort field._________________________

By default,the PivotTable report uses the ____ function for numbers in the Values area.

-In the figure above,the 20,000 indicates the price of a piece of artwork.Records with artwork with the following values meet the criteria: ____.

If a column consists of day or month labels,you can sort them in their correct chronological order using one of the predefined custom lists._________________________

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 a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab.

What are the steps for sorting data using multiple fields?

The ____ criteria filter requires the records displayed to start with the specified text string.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Indicates the sequence in which you want data ordered

A table name can include all of the following EXCEPT ____

Table names cannot include underscores._________________________

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

In addition to displaying subtotals,the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

The Summary command automatically inserts a subtotal line into the list for each group of data in the list._________________________

The header row must be row 1.

If you freeze the top row in a worksheet and press Ctrl+Home,you will return to the cell directly above the frozen row.

The ____________________ criteria filter requires that the records displaying begin with the specified text string.

PivotTable data can be a(n)____.

You can sort by ____.

A(n)____________________ list indicates the sequence in which you want data ordered.

The first sort field in a sort is called the major sort field._________________________

By default,the PivotTable report uses the ____ function for numbers in the Values area.

-In the figure above,the 20,000 indicates the price of a piece of artwork.Records with artwork with the following values meet the criteria: ____.

If a column consists of day or month labels,you can sort them in their correct chronological order using one of the predefined custom lists._________________________

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