Lesson 5: Inserting Formula and Functions

This lesson will teach you how to insert formulas and use the functions. You will also know the definition of formula, text, values and functions.

Objectives

  • Learn the definition of formulas, texts, values and functions
  • Identify the Formula tab commands
  • Learn the mathematical operation and corresponding keyboard sign
  • Learn to enter labels, data and formula
  • Learn how to use functions

Inserting Formula and Functions

Formula
It is used to calculate values. You may use an equal sign or the Autosum function to build formula. These are arithmetical calculations that can be performed in Excel. An Excel formula always begins with an equal (=) sign.
Texts
These are letters symbols, numbers and spaces or any combination that you enter into a cell.
Value
It is a number that you enter into a cell that you may use in a formula later. You may include in the value the numeric symbols such as decimal point, comma or currency.
Functions
These are built-in formulas you can use to make your worksheet construction easier.
ARITHMETIC OPERATION AND CORRESPONDING KEYBOARD SIGN
Sign Operation Example Function
+ Addition =B5+C5 Adds the values of cell B5 and C5
- Subtraction =B5-C5 Subtracts the value of cell C5 from B5
* Multiplication =B5*C5 Multiplies the value of cell B5 to C5
/ Division =B5/C5 Divides the value of cell B5 by the value of cell C5