Microsoft Office Tutorials and References
In Depth Information
Session 3.1
Functions are organized by
the category i n the Function
Library goup. Select a
function to open the Funcion
Arguments dialog box.
The Insert Function but ton
opens the Insert Function
dialog box from which you
can select a function.
An absolute reference
remains fixed when the cell
formula is copied to a new
location, and has $ in front
of the column letter and the
row number. $D$5 is the
absolute reference to
cell D5.
A relative reference is
interpreted in relation to
the location of the cell
containing the formula. L19
is the relative reference to
cell L19.
Search JabSto ::

Custom Search