EXCEL FORMULAS AND FUNCTIONS

It is a symbol used in Excel that tells Excel that you are going to perform a formula.

• =
• -
• +
• *

A symbol used in adding cells in a formula.

• -
• +
• /
• *

A symbol used for exponents.

• ^
• /
• *
• %

A symbol used to indicate subtraction in a formula.

• -

• +

• /

• *

A symbol used to represent multiplication in Excel formulas.

• ^

• /

• %

• *

A symbol used to denote division in a formula.

• /

• *

• +

• -

When creating a formula, instead of typing the cell address you can do this simple technique.

• Type the cell address manually.
• Point and Click on the cell to reference it in the formula.

• Drag and drop

• Copy and paste the cell address from another location.

Create a formula with the given data, so that the answer will be “8”.

• =A1+B1

• A1XB1        

• =A1*B1     

• =A1xB1

Create a formula that compute 12% tax on C1.

• 9*12%

• =C1*.12      

• =9*.12

• =C1+12%

A formula with 2 or more operation in one formula

• Quadratic expression
• Linear equation
• Simple formula
• Complex formula