FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

A table name cannot include ____.

A) numbers
B) spaces
C) underscores
D) letters

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

Matching

Review LaterAdd Note

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

Each column in a range represents a(n) ____________________ that describes some attribute or characteristic of a person, place, or thing.

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 named Cathy, Carla, and Carey, what should she do?

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

To calculate subtotal for a table, the first step is to use the ____ button on the TABLE TOOLS DESIGN tab.

To delete records that are incorrect, out of date, or no longer needed, select a cell in each record you want to delete, click the Delete button arrow in the Cells group on the ____ tab, and then click Delete Table Rows.

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

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

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

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

The Subtotal command inserts a subtotal row into the range for each group of data and adds a grand total row below the last row of data.

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

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

What are the steps for sorting data using multiple fields?

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 be able to use his PivotTable to combine items into groups. Which of the following is true?

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. To find anyone whose Camp is either Day Camp , or Overnight Camp , or Nature Camp , what should he do?

When you want to see all the data in a filtered table, you can ____________________, or remove, the filters.

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.