Microsoft Excel Functions: Formula Basics, Operators and Functions (Part 3)
Explore “Formula Basics, Operators and Functions” in this Microsoft Excel Functions lesson. Part 3 of the five-part series brings together the source material and lesson topics. Use the contents links to find a section, read the notes, and consult the complete original teaching slides below.
Lesson topics
- Understanding Formula Basics
- Algebraic Functions
- Algebraic Function
Contents
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Read the original source document
Microsoft Excel – Presentation 01: original teaching slides for this study series.
Understanding Formula Basics
Understanding Formula Basics Mathematical operators, such as + (for addition) and * (for multiplication) Cell references (including named cells and ranges) Values or text Worksheet functions (such as SUM or AVERAGE)
Operator | Name
Operator | Name + | Addition | Subtraction | Multiplication / | Division ^ | Exponentiation & | Concatenation Operators Used in Formulas
Operator | Name
Operator | Name = | Logical comparison (equal to) > | Logical comparison (greater than) < | Logical comparison (less than) >= | Logical comparison (greater than or equal to) <= | Logical comparison (less than or equal to) <> | Logical comparison (not equal to) Logic Operators Used in Formulas
Operator | What it Does
Operator | What it Does : (Colon) | Specifies a range. , (comma) | Specifies the union of two ranges. This operator combines multiple range references into a single reference. (space) | Specifies the intersection of two ranges. This operator produces cells that are common to two ranges. Reference Operators for Ranges
Function Arguments
Function Arguments No arguments One argument A fixed number of arguments An indeterminate number of arguments Optional arguments
REQUEST THE COMPLETE DOCUMENT ON WHATSAPP
Algebraic Functions
Algebraic Functions Logic Functions Lookup Function Statistic Function Financial Function Text Function Date & Time Function
Operator Name | Description
Operator Name | Description Sum | Add Selected array in one cell Product | Multiply of two or more references Quotient | Divide two or more references (Subtraction) | Subtraction of references Algebraic Function
Algebraic Function
Algebraic Function =QUOTIENT(First_Reference,Second_Reference) Multiplication =PRODUCT(Start_Cell:End_Cell) =SUM(Start_Cell:End_Cell) Subtraction =First_Reference – Second_Reference
Review questions and answers
What are the key points about Understanding Formula Basics?
Understanding Formula Basics Mathematical operators, such as + (for addition) and * (for multiplication) Cell references (including named cells and ranges) Values or text Worksheet functions (such as SUM or AVERAGE)
What are the key points about Operator | Name?
Operator | Name + | Addition | Subtraction | Multiplication / | Division ^ | Exponentiation & | Concatenation Operators Used in Formulas
What are the key points about Operator | What it Does?
Operator | What it Does : (Colon) | Specifies a range. , (comma) | Specifies the union of two ranges. This operator combines multiple range references into a single reference. (space) | Specifies the intersection of two ranges. This operator produces cells that are common to two ranges. Reference Operators for Ranges
What are the key points about Function Arguments?
Function Arguments No arguments One argument A fixed number of arguments An indeterminate number of arguments Optional arguments
What are the key points about Algebraic Functions?
Algebraic Functions Logic Functions Lookup Function Statistic Function Financial Function Text Function Date & Time Function
More lessons from this document
- Microsoft Excel – Presentation 01 — Part 1
- Microsoft Excel – Presentation 01 — Part 2
- Microsoft Excel – Presentation 01 — Part 3
- Microsoft Excel – Presentation 01 — Part 4
- Microsoft Excel – Presentation 01 — Part 5
Conclusion
The important points in Understanding Formula Basics should be reviewed alongside the definitions, examples and comparisons given above. Continue with the other four articles to cover the rest of the source material.