The text, date, number, or logical input that completes a condition that a field must meet for searching or filtering. For example, the field Author with the condition <b>equals</b> must include a value, such as <b>John</b>, to be complete.
In line charts with multiple data series, bars that indicate the difference between data points in the first and last series.
Optional text for a trendline, including either the regression equation or the R-squared value, or both. A trendline label can be formatted and moved; it cannot be sized.
A graphic representation of trends in data series, such as a line sloping upward to represent increased sales over a period of months. Trendlines are used for the study of problems of prediction, also called regression analysis.
Arrows that show the relationship between the active cell and its related cells. Tracer arrows are blue when pointing from a cell that provides data to another cell, and red if a cell contains an error value, such as #DIV/0!.
One of the five calculation types Query defines for you: Sum, Avg, Count, Min, and Max.
A special row in an Excel table that provides a selection of aggregate functions useful for working with numerical data.
