|SpreadSheets||PAGE (3 of 6)|
B2 * C3 - D4 + F5
Relative references automatically adjust for the new location, so a copied or moved formula refers to different cells than in the original formula.
$B$2 * C$3 - $D4 + F5
When you move or copy a formula with an absolute reference, the reference is to the exact cells as in the original formula.
Ranges of cells can be specified as parameters to functions by separating the beginning and ending cells of the range with a colon, e.g., (B2:B5), (C3:G3).
The result of copying depends upon cell references within a formula.
Cell references within a formula are automatically adjusted by the number of rows or columns over which the formula is being copied. The difference of the number of rows and columns between the copied cell location and the destination cell location is added to the corresponding row or column references in the relative referenced cells in the formula.
Absolute cell references, (and partial absolute references), are copied verbatim without adjustment of the dollar sign, (absolute), preceded cell references.
Excel contains a complete library of pre-defined functions which can be accessed through the Function Wizard:
Allows a subset of the spreadsheet to be specified as a database for the performing of database operation, e.g., searching, querying, sorting, & subsetting.
© CS Dept Va Tech, 1999.
All rights reserved.