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

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

In Excel,a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

When you click in each cell in the Total row,a(n)____ appears that you can click to open a list of the most commonly used functions.

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.

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

Table names cannot include underscores.____________________

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? 

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

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

Which of the following is a valid table name? 

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

The ____________________ command automatically inserts a subtotal line into the range for each group of data.

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

When you delete a record from a table,a dialog box displays to confirm the delete operation.

If you freeze the top row in a worksheet and press Ctrl+Home,you will return to the cell A1.

A table name cannot include ____.

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 use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million.How would he accomplish this? 

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

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

Case 5-1 You are a student who is new to the more advanced features of Excel. -You have a lot of familiarity with ranges from an earlier Excel class,but you know that there is an alternative that will give you access to additional features that you do not have with a cell range.What is that option?