Question

Formulae are self defined instructions for performing calculations such as:

• A. Average
• B. Maximum
• C. Minimum
• D. Multiplication

Answer 1

Answer:

D. Multiplication

 Formula and Functions

• Formulae are self defied instructions for performing calculations
• Functions are predefined formulas in Excel
• Formulas start with an equal sign
• Formula contains the address of the cells and operands.

Example

          Operator        Meaning        Example

                +              Addition         =A5+A9

                 -               Subtraction    =A5-A9

                 *              Multiplication   =A5*A9

                 /              Division             =A5/A9

                 ^             Exponents         =A5^A9

• we use cell  references (cell addresses  such as A5,A7, or B9) in formulas instead of the actual values of the cells.