precedents

Cells that are referred to by a formula in another cell. For example, if cell D10 contains the formula =B5, cell B5 is a precedent to cell D10.

point

A zero-dimensional figure; while usually left undefined, has four main representions - the dot, the node, the location, and the ordered pair of numbers.

plot area

In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles.

PivotTable subtotal

A row or column that uses a summary function to display the total of detail items in a PivotTable field.

PivotTable report

An interactive, cross-tabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.

PivotTable list

A Microsoft Office Web Component that allows you to create a structure similar to an Excel PivotTable report. Users can view the PivotTable list in a Web browser and change its layout in a manner similar to an Excel PivotTable report.

PivotTable grand totals

Total values for all cells in a row or all cells in a column of a PivotTable report. Values in a grand total row or column are calculated by using the same summary function used in the data area of the PivotTable report.

PivotTable data

In a PivotTable report, the summarized data that's calculated from the data fields of a source list or table.