Excel 2003 Tutorial III

Short Description
A function in Excel is a built-in formula that performs a mathematical operation or …. If the formula uses a built-in Excel function: …

Website: wwwlb.aub.edu.lb | Filesize: 178kb

Content
http://staff.aub.edu.lb/~acc/
This tutorial was adapted from a tutorial by
see its complete version at
http://www.fgcu.edu/support/office2000/excel/index.html
Excel 2003 - Tutorial III
Functions & Formulas Fundamentals
Formula Definition
Formula Syntax
Formula Bar
Function Definition
Function Syntax
Arguments
Operators
Operator Order
Function Wizards
Entering Multiple Formulas All At Once
Editing & Deleting Formulas
Errors in Formulas
Excel Functions Overview
Statistical Functions Overview
Math Functions Overview
Information Functions Overview
Overview of Logical Functions
Additional Readings
Text to SpeechAcademic Computing Center - AUB Excel 2003 - Tutorial III
http://staff.aub.edu.lb/~acc/
Last Updated: October 26, 2005 2 of 9
Functions & Formulas Fundamentals
The following definitions are necessary to understand the basics of creating Excel
formulas and functions.
Formula Definition
A formula allows you to calculate and analyze data in your worksheet. Formulas perform
calculations such as addition or multiplication; formulas can also combine values.
Formula Syntax
Formula syntax is the structure or order of the formula elements. All formulas begin with
an equal sign (=) in Excel followed by operands (the data to be calculated) and the
operators. Operands can be values that don’t change (constants), a range reference, a
label, a name, or a worksheet function.
Formula Bar
The Formula bar is an area located at the top of the worksheet window that is used to
enter or edit values or formulas in cells or charts. The Formula bar displays the constant
value or formula in the active cell. To display or hide the Formula bar; select from the
Menu bar, View > Formula.
Function Definition
A function in Excel is a built-in formula that performs a mathematical operation or…