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 FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to group and summarize a list into a concise,tabular format

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

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

You can use the ____ tab to change the SUM function to a different summary function,in a PivotTable.

A) New Function
B) Change Function
C) Summarize Values by
D) Summary function

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

-The entry 20000 is the ________________ for the first condition.

To show items hidden in a PivotTable,you click the Show tab and check the check box for the item you want to show.

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

You can format cells in a PivotTable the same way as you do cells in the worksheet.

Custom filters enable you to specify various conditions in addition to those that are based on an "equals" criterion._________________________

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

Case-Based Critical Thinking Questions Case 5-1 You are tutoring a fellow student who is new to the more advanced features of Excel.. -Which of the following is NOT a feature that is unique to Excel tables (as opposed to structured ranges of data) ?

The benefit of a(n)____________________ is that it summarizes large amounts of data into a readable format.

-Referring to the figure above,the phrase "is greater than" is the criteria for the first condition.________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To temporarily hide all the records that do not meet your criteria

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

Jamie wants to be able to analyze date data in her PivotTable by month.What must she do with the date field in her PivotTable?

-In the accompanying figure,"Installation," "Sculpture," and "Textile" are all part of the list of ____ options.

After data is filtered,you can ____ it.

Separate the data (including the header row)from other information in the worksheet by at least ________________ blank row and one blank column.

You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box,and checking the ____ check box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A range of related data managed independently from the data in other rows and columns in the worksheet

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