a predifined formula that uses the values in the cells you select to calculate its answer.
a feature that temporarily performs the following calculations on a range of cells without making you write a formula: AVERAGE, COUNT, COUNT A , MAX, MIN, OR SUM.
Data arranged in columns and specially formatted with column headers that contain commands that allow you to sort, filter, and perform other functions on the table.
a text note attached to a worksheet cell.
the text box located to the left of the formula bar.
a graphic that allows you to compare and contrast data in a visual format.
a chart placed as an object within a worksheet
a chart that occupies its own worksheet.
to position data points on a graph
a key that identifies wach of the data series in a chart
the horizontal scale of a chart on which categories are plotted
the vertical scale of a chart on which the value of each category is plotted.
for most charts, these are the information in a worksheet row. If you select multiple rows of data for a chart, you'll create multiple categories.
lines of measurement along the value and category axes