Question 1

What are the guidelines for creating an effective structured range of data?

Accepted Answer

* Enter field names in the top row of th

Question 2

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 3

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 analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?

Accepted Answer

A) He must aggregate the data by the date field. 
B) He must cluster the data by the date field. 
C) He must sort the data by the date field. 
D) He must group the data by the date field. 
A) He must aggregate the data by the date field. 
B) He must cluster the data by the date field. 
C) He must sort the data by the date field. 
D) He must group the data by the date field.

Question 4

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 5

To create a table,click the ____ tab on the Ribbon and then,in the Tables group,click the Table button.

Accepted Answer

A) DESIGN 
B) HOME 
C) INSERT 
D) VIEW 
A) DESIGN 
B) HOME 
C) INSERT 
D) VIEW

Question 6

You can create at most one Excel table in a worksheet.

Accepted Answer

A) True 
 B)False

Question 7

A data ____ table describes the fields you plan to maintain in a table.

Accepted Answer

A) structure 
B) definition 
C) map 
D) linked 
A) structure 
B) definition 
C) map 
D) linked

Question 8

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.
-If Ted decides that he wants to work with nonnumeric data in his PivotTable,what function must he use to produce summaries?

Accepted Answer

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

Question 9

Cali 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 camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number.
-To find anyone whose Camp is either Day Camp,or Overnight Camp,or Nature Camp,what should he do?

Accepted Answer

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

Question 10

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.
-Which of the following is a true statement Carter can make to Ted about PivotTables?

Accepted Answer

A) To remove a field from a PivotTable, you click the field's check box in the PivotTable Field list. 
B) You cannot rename a value label by typing the new text directly in any cell where the value label appears in the PivotTable. 
C) Removing a field from the PivotTable changes the underlying Excel table. 
D) To remove a field from a PivotTable, you click the field's check box in the PivotChart list. 
A) To remove a field from a PivotTable, you click the field's check box in the PivotTable Field list. 
B) You cannot rename a value label by typing the new text directly in any cell where the value label appears in the PivotTable. 
C) Removing a field from the PivotTable changes the underlying Excel table. 
D) To remove a field from a PivotTable, you click the field's check box in the PivotChart list.

Question 11

You can split the worksheet window into ____ separate panes.

Accepted Answer

A) two or four 
B) four or six 
C) six or eight 
D) between two and eight 
A) two or four 
B) four or six 
C) six or eight 
D) between two and eight

Question 12

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

Accepted Answer

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

Question 13

The first sort field in a sort is called the $\underline {  \text { major }  }$ sort field.____________________

Accepted Answer

A) True 
 B)False

Question 14

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 15

Which of the following is a valid table name?

Accepted Answer

A) %_table 
B) $Table2 
C) _Newtable 
D) 2Table 
A) %_table 
B) $Table2 
C) _Newtable 
D) 2Table

Question 16

-In the figure above,the 300 indicates the amount.Records with the following values meet the criteria: ____.

Accepted Answer

A) $298 
B) $299 
C) $300 
D) $301 
A) $298 
B) $299 
C) $300 
D) $301

Question 17

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) custom list 
B) field 
C) record 
D) freeze 
E) criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort 
A) custom list 
B) field 
C) record 
D) freeze 
E) criteria filter
F)data definition table
G)filter
H)PivotTable
I)field name
J)sort

Question 18

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

Accepted Answer

A) Top 10 
B) Between 
C) Aggregate 
D) Range 
A) Top 10 
B) Between 
C) Aggregate 
D) Range

Question 19

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 20

A(n)____________________ is an interactive table that enables you to group and summarize an Excel list into a concise,tabular format for easier reporting and analysis.

Accepted Answer

The answer of A(n)____________________ is an interactive table that enables...

What are the guidelines for creating an effective structured range of data?

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

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 analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?

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

To create a table,click the ____ tab on the Ribbon and then,in the Tables group,click the Table button.

You can create at most one Excel table in a worksheet.

A data ____ table describes the fields you plan to maintain in a table.

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. -If Ted decides that he wants to work with nonnumeric data in his PivotTable,what function must he use to produce summaries?

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. -Which of the following is a true statement Carter can make to Ted about PivotTables?

You can split the worksheet window into ____ separate panes.

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

The first sort field in a sort is called the $\underline { \text { major } }$ sort field.____________________

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

Which of the following is a valid table name?

-In the figure above,the 300 indicates the amount.Records with the following values meet the criteria: ____.

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 ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

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

A(n)____________________ is an interactive table that enables you to group and summarize an Excel list into a concise,tabular format for easier reporting and analysis.

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

What are the guidelines for creating an effective structured range of data?

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

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

To create a table,click the ____ tab on the Ribbon and then,in the Tables group,click the Table button.

You can create at most one Excel table in a worksheet.

A data ____ table describes the fields you plan to maintain in a table.

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. -Which of the following is a true statement Carter can make to Ted about PivotTables?

You can split the worksheet window into ____ separate panes.

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

The first sort field in a sort is called the major ‾\underline { \text { major } } major ​ sort field.____________________

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

Which of the following is a valid table name?

-In the figure above,the 300 indicates the amount.Records with the following values meet the criteria: ____.

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 ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

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

A(n)____________________ is an interactive table that enables you to group and summarize an Excel list into a concise,tabular format for easier reporting and analysis.

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

The first sort field in a sort is called the $\underline { \text { major } }$ sort field.____________________