This preview shows page 1. Sign up to view the full content.
Unformatted text preview: perform a calculation Function Words that Excel recognizes as part of a calculation, such as SUM, to total a range of values or AVG to find the average of a range Label A text box used to define data series, axes, a chart title, or other chart elements Legend (Key) A chart label that lists the data series and color codes Mixed cell reference A cell reference where either the column letter or row number is absolute but other is relative Reference A cell address, a range such as A5:G5, or a named range, used in a formula Reference operator Used to indicate a range of cells, such as a colon (:) to reference the cell area A5:G6, or a comma (,) to reference multiple cells or ranges = formula prefix ( ) range of numbers : through Relative cell reference A cell reference that changes based on the location of the formula Syntax A rule used in Excel to perform calculation without errors...
View Full
Document
 Spring '12
 Buckley

Click to edit the document details