The part of a PivotTable report that contains summary data. Values in each cell of the values area represent a summary of data from the source records or rows.
A field from a source list, table, or database that contains data that is summarized in a PivotTable report or PivotChart report. A value field usually contains numeric data, such as statistics or sales amounts.
A control on a menu, toolbar, or dialog box that displays a list of options when you click the small arrow next to the list box.
In line and area charts, lines that extend from a data point to the category (x) axis. Useful in area charts to clarify where one data marker ends and the next begins.
For automatic subtotals and worksheet outlines, the subtotal rows or columns that are totaled by summary data. Detail data is typically adjacent to and either above or to the left of the summary data.
The range of cells that you select to hold the summarized data in a consolidation. The destination area can be on the same worksheet as the source data or on a different worksheet. A worksheet can contain only one consolidation.
Cells that contain formulas that refer to other cells. For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5.
The Sheet.xlt template that you create to change the default format of new worksheets. Excel uses the template to create a blank worksheet when you add a new worksheet to a workbook.