Jayson's Blog #2 In CompSci for 3rd Rating

Functions And Formulas

www.slideshare.net

Formula - is used to perform calculations.

             - begins with an equal ( = ) sign.

                              - contain constants, cell references, ranges, 

and grouping symbols.

Operator Precedence in Excel Formulas

www.msoffice-tutorial-training.com

Function - predefined formula.

       - returns a value.

                                              - can be used together with other functions 

and other operations.

www.myonlinetraininghub.com

Errors

www.excel-easy.com

#NAME? - undefined range or cell name,

#REF! - invalid cell reference.

 #DIV/0!

• #N/A – missing data