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

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

A) Year to Date
B) Today
C) Current
D) none of the above

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) 1
B) 1Table
C) NewTable
D) Table1

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

Table names cannot include underscores .

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

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

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

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

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

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.

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

You can split the worksheet window into ____ separate panes.

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

You can access the Sort buttons in the ____ group on the HOME tab by clicking the Sort & Filter button and clicking a sort option.

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

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

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

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

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?

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

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