Question 1

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 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

A table name cannot include ____.

Accepted Answer

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

Question 5

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 6

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 7

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

Question 8

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 9

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 10

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 11

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 12

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 13

-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 14

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 15

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 16

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

Accepted Answer

report

Question 17

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 18

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 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

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

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

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

Correct AnswerverifiedShow Answer

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

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

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

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

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

Correct AnswerverifiedFalse

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

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

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

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

Correct AnswerverifiedShow Answer

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

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

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

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

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

Correct Answerverifiedreport

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

Correct AnswerverifiedShow Answer

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

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified
False

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
report

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified