FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Excel 1: 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 start with the specified text string.

A) Origin
B) Begins With
C) Initial
D) Start

E) A) and B)
F) C) and D)

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

The fields you use to order your data are called sort ____.

To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab.

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

An easy way to sort data when there is only one sort field is to use the Sort A to Z or Sort Z to A buttons.

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

Case-Based Critical Thinking Questions Case 5-2 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?

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

Which of the following is a valid table name?

Case-Based Critical Thinking Questions Case 5-2 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. If Cali wants to find all of his campers named Cathy, Carla, and Carey, what should she do?

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

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

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.

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