SpreadSheets PAGE (3 of 6)

 

Formulas

Composition

Cell Referencing

Ranges

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).

Cell Copying

Functions

Excel contains a complete library of pre-defined functions which can be accessed through the Function Wizard:

Function Wizard Button

Function Wizard: Step 1

Macros

Excel© Database

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.