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
This note was uploaded on 04/01/2012 for the course BIOL 202 taught by Professor Buckley during the Spring '12 term at University of Massachusetts Boston.
 Spring '12
 Buckley

Click to edit the document details