Question 1

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

Accepted Answer

A)  Hiding 
B)  Freezing 
C)  Showing 
D)  Sealing

Question 2

Case 5-2
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.
-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.

Question 3

The second sort field in a sort is called the ____________________ field.

Accepted Answer

The answer of The second sort field in a sort...

Question 4

You can calculate sort statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table. ____________________

Accepted Answer

A) True 
 B)False

Question 5

Ascending order arranges labels alphabetically from A to Z.____________________

Accepted Answer

A) True 
 B)False

Question 6

Case 5-1
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 7

You can use a table's sizing handle to add columns or rows to a table.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Question 10

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.

Accepted Answer

A)  Filtering 
B)  Formatting 
C)  Editing 
D)  Text

Question 11

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

Accepted Answer

A) True 
 B)False

Question 12

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

Question 13

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 14

Case 5-1
You are a student who is new to the more advanced features of Excel.
-If Cali wants to find all of his campers named Cathy,Carla,and Carey,what should she do?

Accepted Answer

A)  Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value. 
B)  Create a text filter using the Contains operator to display all records that have Ca at the beginning of the text value. 
C)  Create a text filter using the Begins With operator to display all records that have Car at the beginning of the text value. 
D)  Create a text filter using the Contains operator to display all records that include Ca in the text value.

Question 15

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

Question 16

Excel assigns the name ____ to the first Excel table created in a workbook.

Accepted Answer

A)  1 
B)  1Table 
C)  NewTable 
D)  Table1

Question 17

To create a custom list,in the Sort & Filter group on the Home tab,click the Sort button.Click the Order arrow,and then click Custom List.____________________

Accepted Answer

A) True 
 B)False

Question 18

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion.____________________

Accepted Answer

A) True 
 B)False

Question 19

When you create a table,if your data does not contain column headers,Excel adds headers with default names.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 5: Working With Excel Tables, Pivottables, and Pivotcharts

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

The second sort field in a sort is called the ____________________ field.

You can calculate sort statistics (including sum,average,count,maximum,and minimum)on all the columns in an Excel table. ____________________

Ascending order arranges labels alphabetically from A to Z.____________________

Case 5-1 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) ?

You can use a table's sizing handle to add columns or rows to a table.

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

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

You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option.

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

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

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.

Case 5-1 You are a student who is new to the more advanced features of Excel. -If Cali wants to find all of his campers named Cathy,Carla,and Carey,what should she do?

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

Excel assigns the name ____ to the first Excel table created in a workbook.

To create a custom list,in the Sort & Filter group on the Home tab,click the Sort button.Click the Order arrow,and then click Custom List.____________________

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion.____________________

When you create a table,if your data does not contain column headers,Excel adds headers with default names.

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