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 41

Multiple Choice

Review LaterAdd Note

Review Later

When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.

A) menu
B) status bar
C) wizard
D) dialog box

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

____ order arranges labels in reverse alphabetical order, from Z to A.

A) Reverse
B) Major
C) Ascending
D) Descending

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

When you create a table, if your data does not contain column headers, Excel adds headers with default names.

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

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

Excel assigns the name ____ to the first Excel table created in a workbook.

Every ____ consists of an object that contains a button for each unique value in that field.

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

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

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

Table names cannot include underscores .

The process of hiding certain records and viewing the ones you want is called ____________________ your data.

You can split the worksheet window into ____ separate panes.

When you create a PivotTable , you need to specify where to find the data for the PivotTable.

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 use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?

With the Last Quarter criteria filter, quarters are defined as, for example, ____.

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.

The ____ criteria filter requires the records displayed to be since January 1 of the current year to the current date.

To freeze a row, select the cell below the row(s) you want to freeze, click the ____________________ button in the Window group and then click Freeze Top Row.