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

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

On the far right, in the figure above, there is the PivotTable field list. The items listed there, such as Day and Segment are ____ in the table.

The entry 20000 is the ____________________ for the first condition.

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.

To get to the screen shown in the figure above, you would click the INSERT tab on the Ribbon, and then, in the ____ group, click the PivotTable button.

The first sort field in a sort is called the major sort field.

What is a PivotTable? Describe its use in Excel, including the definition of value fields and category fields.

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.

You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.

The box that is covering columns A, B, and C in the figure above is the PivotTable ____________________ area.

In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.

Ascending order arranges labels alphabetically from A to Z.

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

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. Which of the following is a true statement Carter can make to Ted about PivotTables?

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 whose last names end in "son" (such as Samson and Colson), what should he do?

In the figure above, if you only want to set one criterion for this filter, you will ____.

The ____________________ criteria filter requires that the records displaying begin with the specified text string.

A(n) ____________________ is a graphical representation of the data in a PivotTable.

Before you complete a sort, you need to decide whether you want to put the list in ascending or descending order.