FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Matching

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition.

Premises

Responses

A unique label that describes the contents of data in a column

sort field

PivotTable

field name

filter

sort

record

field

custom list

criteria filter

table

freeze

data definition table

Premises

A unique label that describes the contents of data in a column

Responses

sort field

PivotTable

field name

filter

sort

record

field

custom list

criteria filter

table

freeze

data definition table

Show Answer

Correct Answer

Premises

Responses

sort field

PivotTable

field name

filter

sort

record

field

custom list

criteria filter

table

freeze

data definition table

Premises

sort field

PivotTable

field name

filter

sort

record

field

custom list

criteria filter

table

freeze

data definition table

Responses

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

A) Category
B) View
C) Data
D) Home

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

When you click in each cell in the ____ row an arrow appears that you can click to open a list of the most commonly used functions.

A field name is also called a(n)____________________.

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.

To calculate subtotal for a table the first step is to use the ____ button on the Table Tools Design tab.

Identify the letter of the choice that best matches the phrase or definition.

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

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

The ____________________ criteria filter requires that the records displaying begin with the specified text string.

The item marked 5 in the accompanying figure is the PivotTable ____________________ area.

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

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.

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

Each column in a range represents a record that describes some attribute or characteristic of a person place or thing.

One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data.

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

Identify the letter of the choice that best matches the phrase or definition.

The Subtotals command offers summary information such as ____.