FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Working With Excel Tables, Pivottables, and Pivotcharts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A)  Or
B)  Both 
C)  And
D)  Either

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

Correct Answer

verified

Show Answer

Question 32

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

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

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

The ____ criteria filter requires the records displayed to start with the specified text string.

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) ? 

To create a custom list,in the Sort & Filter group on the Home tab,click the Sort button.Click the Order arrow,and then click Custom List.____________________

____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.

You cannot change data directly in the PivotTable.Instead,you must edit the Excel table,and then ____,or update,the PivotTable to reflect the updated data.

If a column consists of day or month labels,you can sort them in their correct chronological order using one of the predefined custom lists.____________________

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.

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. -Ted wants to be able to analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable? 

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

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

You can use a table's sizing handle to add columns or rows to a table.

Case 5-1 You are a student who is new to the more advanced features of Excel. -If Cali wants to find all of his campers named Cathy,Carla,and Carey,what should she do? 

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.

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

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

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

Ascending order arranges labels alphabetically from A to Z.____________________