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

To calculate subtotal for a table,the first step is to use the ____ button on the Table Tools Design tab.

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

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 Ted decides that he wants to work with nonnumeric data in his PivotTable,what function must he use to produce summaries? 

The fields you use to order your data are called sort ____.

____ order arranges labels in reverse alphabetical order,from A to Z 

The entry 20000 is the ____________________ for the first condition.

To create a table,click the ____ tab on the Ribbon and then,in the Tables group,click the Table button.

To freeze a row,select the cell below the row(s)you want to freeze,click the ____________________ button in the Window group and then click Freeze Top Row.

By default,the PivotTable report uses the ____ function for numbers in the Values area.

The ____ condition requires that all of the selected criteria be true for the record to be displayed.

In Excel,a collection of similar data can be structured in a(n)____ of rows and columns.

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

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 split the worksheet window into ____ separate panes.

____ order arranges labels in reverse alphabetical order,from Z to A.