Exam 5: Excel 1: 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?

In PivotTable terminology, the fields that you summarize are known as ____________________ fields.

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

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

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. ____________________

The Subtotal command inserts a subtotal row into the range for each group of data and adds a grand total row below the last row of data. ____________________

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 use his PivotTable to combine items into groups. Which of the following is true?

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

You can drag one field to the Filters area of the PivotTable Fields pane to  change what values are displayed in the PivotTable.

The ____ report layout displays one column for each field and leaves space for column headers.

The ____ criteria filter requires the records displayed to have the current date.

Each column represents a record that describes some attribute or characteristic of a person, place, or thing. ____________________

To add a sort field in the Sort dialog box, click the ____ button.

Each column in a range represents a(n)____________________ that describes some attribute or characteristic of a person, place, or thing.

To delete records that are incorrect, out of date, or no longer needed, select a cell in each record you want to delete, click the Delete button arrow in the Cells group on the ____ tab, and then click Delete Table Rows.

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

When related fields are grouped together in a row, they form a(n)____________________, a collection of fields that describes a person, place, or thing.

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

You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab.

When you want to see all the data in a filtered table, you can ____________________, or remove, the filters.