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 51

Short Answer

Review LaterAdd Note

Review Later

When related fields are grouped together in a row, they form a(n) ____________________, a collection of fields that describes a person, place, or thing.

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is a valid table name?

A) %_table
B) $Table2
C) _Newtable
D) 2Table

E) None of the above
F) B) and D)

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

The ____ criteria filter requires the records displayed to have the specified text string anywhere.

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

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

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

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

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

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

You can calculate sort statistics (including sum, average, count, maximum, and minimum) on all the columns in an Excel table.

When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.

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

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

In addition to data fields, a PivotTable uses ____________________ fields to group values such as department, model, year, and vehicle type in an automobile-related sheet, for example.

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

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

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

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

The ____ report layout displays one column for each field and leaves space for column headers.

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