Question 1

-The box that is covering columns A,B,and C in the figure above is the PivotTable ____________________ area.

Accepted Answer

report

Question 2

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A collection of related fields that are grouped together

Accepted Answer

A)  custom list
B)  field
C)  record
D)  freeze
E)  criteria filterF) data definition tableG) filterH) PivotTableI) field nameJ) sort

Question 3

Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person,place,or thing.

Accepted Answer

The answer of Each column in a range represents a(n)____________________...

Question 4

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

Question 5

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)  custom list
B)  field
C)  record
D)  freeze
E)  criteria filterF) data definition tableG) filterH) PivotTableI) field nameJ) sort

Question 6

You can drag one field to the FILTERS area of the PivotTable Fields pane to
change what values are displayed in the PivotTable.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  custom list
B)  field
C)  record
D)  freeze
E)  criteria filterF) data definition tableG) filterH) PivotTableI) field nameJ) sort

Question 8

The ____ report layout displays one column for each field and leaves space for column headers.

Accepted Answer

A)  Outline
B)  Design
C)  Tabular
D)  Headers

Question 9

With the Last Quarter criteria filter,quarters are defined as,for example,____.

Accepted Answer

A)  April, May, June
B)  March, April, May
C)  May, June, July
D)  March, April, May, June

Question 10

Excel can summarize data in a range of data by inserting subtotals.

Accepted Answer

A) True 
 B)False

Question 11

A table name cannot include ____.

Accepted Answer

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

Question 12

The ____ criteria filter requires the records displayed to have the current date.

Accepted Answer

A)  Current Date
B)  This Date
C)  This
D)  Today

Question 13

You are a student who is new to the more advanced features of Excel.
-Which of the following is true about Excel tables (as opposed to structured ranges of data) ?

Accepted Answer

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

Question 14

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 15

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

Question 16

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

Accepted Answer

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

Question 17

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

Question 18

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)  custom list
B)  field
C)  record
D)  freeze
E)  criteria filterF) data definition tableG) filterH) PivotTableI) field nameJ) sort

Question 19

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
-Ted wants to be able to use his PivotTable to combine items into groups.Which of the following is 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 cannot be grouped automatically using the Grouping dialog box.
D)  If items are numbers, they cannot be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu. B

Question 20

Each column represents a $\underline {   \text { record } }$ that describes some attribute or characteristic of a person,place,or thing.____________________

Accepted Answer

A) True 
 B)False  False

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

-The box that is covering columns A,B,and C in the figure above is the PivotTable ____________________ area.

Correct Answerverifiedreport

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A collection of related fields that are grouped together

Correct AnswerverifiedShow Answer

Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person,place,or thing.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You can drag one field to the FILTERS area of the PivotTable Fields pane to change what values are displayed in the PivotTable.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____ report layout displays one column for each field and leaves space for column headers.

Correct AnswerverifiedShow Answer

With the Last Quarter criteria filter,quarters are defined as,for example,____.

Correct AnswerverifiedShow Answer

Excel can summarize data in a range of data by inserting subtotals.

Correct AnswerverifiedShow Answer

A table name cannot include ____.

Correct AnswerverifiedShow Answer

The ____ criteria filter requires the records displayed to have the current date.

Correct AnswerverifiedShow Answer

You are a student who is new to the more advanced features of Excel. -Which of the following is true about Excel tables (as opposed to structured ranges of data) ?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. -Ted wants to be able to use his PivotTable to combine items into groups.Which of the following is true?

Correct AnswerverifiedB

Each column represents a record ‾\underline { \text { record } } record ​ that describes some attribute or characteristic of a person,place,or thing.____________________

Correct AnswerverifiedFalse

Correct Answer
verified
report

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Each column represents a $\underline { \text { record } }$ that describes some attribute or characteristic of a person,place,or thing.____________________

Correct Answer
verified
False