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

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?

Free

(Multiple Choice)

5.0/5

(36)

Question 1

Correct Answer:

Verified

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

Free

(True/False)

4.8/5

(30)

Question 2

Correct Answer:

Verified

False

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

Free

(Short Answer)

4.8/5

(33)

Question 3

Correct Answer:

Verified

report

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

(Multiple Choice)

4.9/5

(34)

Question 4

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.

(Multiple Choice)

4.8/5

(29)

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

(Multiple Choice)

5.0/5

(45)

Question 6

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

(Multiple Choice)

4.8/5

(31)

Question 7

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

(Multiple Choice)

4.8/5

(41)

Question 8

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

(Multiple Choice)

4.8/5

(30)

Question 9

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

(Multiple Choice)

4.9/5

(30)

Question 10

A table name cannot include ____.

(Multiple Choice)

4.9/5

(26)

Question 11

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

(Multiple Choice)

4.8/5

(32)

Question 12

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

(Multiple Choice)

4.9/5

(40)

Question 13

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

(Short Answer)

4.9/5

(25)

Question 14

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

(Multiple Choice)

4.9/5

(43)

Question 15

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

(Multiple Choice)

5.0/5

(34)

Question 16

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

(True/False)

4.9/5

(38)

Question 17

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

(True/False)

4.8/5

(33)

Question 18

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

(Multiple Choice)

4.8/5

(45)

Question 19

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

(Short Answer)

4.8/5

(31)

Question 20

Showing 1 - 20 of 100

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?

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

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

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

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.

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

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

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

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

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

A table name cannot include ____.

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

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

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

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

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

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

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

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

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

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?

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

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

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

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.

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

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

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

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

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

A table name cannot include ____.

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

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

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

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

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

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

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

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

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

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

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