Question 1

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

Accepted Answer

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

Question 2

Ascending order arranges labels alphabetically from A to Z. ____________________

Accepted Answer

A) True 
 B)False

Question 3

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

Accepted Answer

A) Year to Date 
B) Today 
C) Current 
D) none of the above

Question 4

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

Accepted Answer

A) rows and headers 
B) grids and columns 
C) rows and columns 
D) footers and grids

Question 5

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

Accepted Answer

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

Question 6

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 7

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 8

Critical Thinking Case-Based Questions Case 5-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 use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?

Accepted Answer

A) He would develop a PivotTable using the aggregate filter. 
B) He would develop a PivotTable using the report filter. 
C) He would develop a PivotTable using the category filter. 
D) He would develop a PivotTable using the value filter.

Question 9

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 10

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 11

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

When you delete a record from a table, a dialog box displays to confirm the delete operation.

Accepted Answer

A) True 
 B)False

Question 13

Before you complete a sort, you need to decide whether you want to put the list in ascending or descending order.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

Accepted Answer

A) headers 
B) outlines 
C) shadows 
D) defines

Question 16

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

Question 17

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

Accepted Answer

A) Or 
B) Nand 
C) And 
D) If

Question 18

Every ____ consists of an object that contains a button for each unique value in that field.

Accepted Answer

A) piece 
B) slicer 
C) section 
D) part

Question 19

Case-Based Critical Thinking Questions 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. If Cali wants to find all of his campers whose last names end in "son" (such as Samson and Colson), what should he do?

Accepted Answer

A) Create a text filter using the Ends With operator to display all records that have cson as the last characters in the text value. 
B) Create a text filter using the Contains operator to display all records that include son in the text value. 
C) Create a text filter using the Ends With operator to display all records that have son as the last characters in the text value. 
D) Create a text filter using the Contains operator to display all records that have son as the last characters in the text value.

Question 20

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

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

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

Ascending order arranges labels alphabetically from A to Z. ____________________

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

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

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

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

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.

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

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

When you delete a record from a table, a dialog box displays to confirm the delete operation.

Before you complete a sort, you need to decide whether you want to put the list in ascending or descending order.

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

In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

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

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

Every ____ consists of an object that contains a button for each unique value in that field.

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