Exam 5: Working With Excel Tables, Pivot-tables, and Pivot-charts

Typically,you want to sort by the numbers,text,or dates stored in the cells,which are all ____________________.

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

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

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

-The QuickFix button shown in the accompanying figure enables you to undo table formatting if,for example,you had not intended new data to be part of an existing table._________________________

Press ____ to return to cell A1 in a worksheet.

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

-Records have been filtered in the list shown in the accompanying figure.

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

A(n)____________________ is an interactive table that enables you to group and summarize an Excel list into a concise,tabular format for easier reporting and analysis.

The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.

Using Excel,you can ____.

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

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

You can use a table's sizing handle to add columns or rows to a table.

In laying out the PivotTable on the worksheet,you can drag the Condition field button from the Row Labels box to the Column Labels box.The PivotTable is rearranged so that the Condition field is a ____ label.

Jamie wants to use her PivotTable to show the total value of the cars for a series of car dealerships but she wants to filter the display to show only those dealers whose total stock of cars is greater than $1 million.How would she accomplish this?

A PivotTable summarizes data in different categories using functions such as ____.

A dark,horizontal line appears ____ the column headers to indicate which row is frozen.

The simplest and most convenient way to add a record to a table is to enter the data in the first blank row below the last record.