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 Flashcards

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A unique label that describes the contents of data in a column

A) custom list
B) field
C) record
D) freeze
E) criteria filter
F) data definition table
G) filter
H) PivotTable
I) field name
J) sort

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

To create a table,click the ____ tab on the Ribbon and then,in the Tables group,click the Table button.

A) DESIGN
B) HOME
C) INSERT
D) VIEW

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

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

Which of the following is a valid table name?

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. -Which of the following is a true statement Carter can make to Ted about PivotTables?

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

A(n)____________________ is an interactive table that enables you to group and summarize an Excel list into a concise,tabular format for easier reporting and analysis.

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

You can split the worksheet window into ____ separate panes.

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. -If Ted decides that he wants to work with nonnumeric data in his PivotTable,what function must he use to produce summaries?

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

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 analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?

In Excel,a collection of similar data can be structured in a(n) ____ of rows and columns.

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?

You can create at most one Excel table in a worksheet.

The first sort field in a sort is called the $\underline { \text { major } }$ sort field.____________________

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

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

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

-In the figure above,the 300 indicates the amount.Records with the following values meet the criteria: ____.