Republic of the Philippines
Department of Education
Region IV-B MIMAROPA
Division of Romblon
CAJIDIOCAN NATIONAL HIGH SCHOOL
Cajidiocan, Romblon
Learning Activity Sheet in TLE 7 (ICT)
4th Quarter – Week 4
Learning Objectives
The learners will be able to:
1. identify the formulas and functions in Excel,
2. use the formulas and functions in computation using Excel; and
3. appreciate the effect of using Excel formulas and functions to make work easy and fast.
______________________________________________________________________________________
Formulas and Functions in MS Excel
What is Excel Formula?
In Microsoft Excel, a formula is an expression that operates on values in a range of cells. These formulas
return a result, even when it is an error. Excel formulas enable you to perform calculations such as addition,
subtraction, multiplication, and division. In addition to these, you can find out averages and calculate
percentages in excel for a range of cells, manipulate date and time values, and do a lot more.
Formulas in Excel: An Overview
Choose a cell.
To enter an equal sign, click the cell and type =.
Enter the address of a cell in the selected cell or select a cell from the list.
You need to enter an operator.
Enter the address of the next cell in the selected cell.
Press Enter.
There is another term that is very familiar to Excel formulas, and that is
"function". The two words, "formulas" and "functions" are sometimes
interchangeable. They are closely related, but yet different. A formula
begins with an equal sign. Meanwhile, functions are used to perform
complex calculations that cannot be done manually. Functions in excel
have names that reflect their intended use.
The example on the right shows how we have used the multiplication
formula manually with the ‘*’ operator.
This example on the left shows how we have used the function -
‘PRODUCT’ to perform multiplication. As you can see, we didn’t
use the mathematical operator here.
Excel formulas and functions help you perform your tasks
efficiently, and it's timesaving. Let's proceed and learn the
different types of functions available in Excel and use relevant
formulas as and when required.
Republic of the Philippines
Department of Education
Region IV-B MIMAROPA
Division of Romblon
CAJIDIOCAN NATIONAL HIGH SCHOOL
Cajidiocan, Romblon
Excel Formulas and Functions
(for beginners)
1. SUM. The SUM() function, as the name suggests, gives the total
of the selected range of cell values. It performs the mathematical
operation which is addition.
As you can see, to find the total amount of sales for every unit,
we had to simply type in the function “=SUM(C2:C4)”. This
automatically adds up 300, 385, and 480. The result is stored in
C5.
2.AVERAGE. The AVERAGE() function focuses on calculating
the average of the selected range of cell values.
3. COUNT. The function COUNT() counts the total number of
cells in a range that contains a number. It does not include the cell,
which is blank, and the ones that hold data in any other format apart
from numeric.
If you are required to count all the cells with numerical values,
text, and any other data format, you must use the function
‘COUNTA()’. However, COUNTA() does not count any blank
cells.
To count the number of blank cells present in a range of cells,
COUNTBLANK() is used.
References
https://www.simplilearn.com/tutorials/excel-tutorial/excel-
formulas
Name: ____________________________________ Date: ___________
Grade & Section: ___________________ Score: WW: ___PT:___
Learning Activities (Week 4)
I. Directions: Read carefully and write the letter of your answer in the space provided before the
number.
___1. Which of the following are used to perform complex calculations that cannot be done manually.
a. Formulas b. Functions c. Cell d. Worksheet
___2. It refers to an expression that operates on values in a range of cells.
a. Worksheet b. Cell c. Functions d. Formulas
___3. It focuses on calculating the average of the selected range of cell values.
a. Formula b. SUM c. AVERAGE d. COUNT
Republic of the Philippines
Department of Education
Region IV-B MIMAROPA
Division of Romblon
CAJIDIOCAN NATIONAL HIGH SCHOOL
Cajidiocan, Romblon
___4. It counts the total number of cells in a range that contains a number.
a. Formula b. SUM c. AVERAGE d. COUNT
___5. It is used to perform multiplication.
a. Product b. SUM c. Quotient d. Difference
II. Directions: Fill-in-the-blanks with the correct word to complete each statement.
1. To enter an equal sign, click the ________ and type =.
2. Enter the _____________ of a cell in the selected cell or select a cell from the list.
3. You need to enter an ________________.
4. Enter the address of the next cell in the _________________cell.
5. Lastly, press ________.
III. Directions: Answer the following.
1. Differentiate formula and functions.
2. Describe the SUM function.
3. Describe the Average function.
4. Describe the Count function.
PT
IV. Directions: Using Cells A2 and A3, give the formula in getting the following. (5 Points each)
1. Product
2. Count
3. Average
4. SUM
