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

What are the guidelines for creating an effective structured range of data?

A table name cannot include ____.

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.

What are the steps for sorting data using multiple fields?

Excel can summarize data in a range of data by inserting subtotals.

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?

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?

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

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.

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.

After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records.

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.

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

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

A(n) ____________________ list indicates the sequence in which you want data ordered.

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?

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

To calculate subtotal for a table, the first step is to use the ____ button on the TABLE TOOLS DESIGN tab.