FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

The header row must be row 1.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Origin
B) Begins With
C) Initial
D) Start

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

The Summary command automatically inserts a subtotal line into the list for each group of data in the list._________________________

Table names cannot include underscores._________________________

The first sort field in a sort is called the major sort field._________________________

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

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

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

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

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

What are the steps for sorting data using multiple fields?

A table name can include all of the following EXCEPT ____

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

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

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

You can sort by ____.

Case-Based Critical Thinking Questions Case 5-2 Simon 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 staff directory table that includes First Name,Last Name,Office Number,Department Name,and Phone Number. -To find anyone whose department name is either Transaction Processing,Processing Operations,or Records Processing,what should he do?

-In the figure above,the 20,000 indicates the price of a piece of artwork.Records with artwork with the following values meet the criteria: ____.

PivotTable data can be a(n) ____.

If you freeze the top row in a worksheet and press Ctrl+Home,you will return to the cell directly above the frozen row.