Spreadsheet
FUNCTIONS
Week 2: Computer 5
OPENING PRAYER | 2ND, 3RD, AND 4TH PERIOD
Leader: Let us remember that we are in the
Holy Presence of God. In the name of the
Father and of the Son and of the Holy Spirit.
ALL: Amen.
Leader: Oh, Most High and Glorious God…
ALL: Enlighten the darkness of my heart and
give me true faith, certain hope, and perfect
charity. Sense and knowledge Lord that I
may carry out your Holy and true command.
OPENING PRAYER
Leader: Glory to the Father and to the Son and to the
Holy Spirit.
ALL: As it was in the beginning, is now and will be forever.
Amen!
All:
Leader:
Our Lady of Lourdes Pray for us.
St. Francis of Assisi Help us to become like christ
St. Pio of Pietrelcina Teach us to love the Crucified Christ.
Bl. Jose Maria of Manila Strengthen us to become Christ's
witnesses..
Leader: In the name of the Father and of the Son and of
the Holy Spirit.
All: Amen.
CLASSROOM RULES
THINGS WE NEED TO REMEMBER:
Work Be nice
Sit properly and
quietly
respectful
TODAY, WE WILL
Use Average and Count function in
computing
Identify common errors in formula
BEFORE WE START!
HTTPS://DRIVE.GOOGLE.COM/DRIVE/FOLDERS/1SUF1WI
OVNPUGUHH9T44JCQUAK__4JEKG?USP=SHARING
UNDERSTANDING COMMON ERRORS IN FORMULAS
ACTIVITY 1
Finding common error
1. Open the file Excel_CommonErrors_Practice.xlsx
2. Find the errors in the following. Change the
content that is causing the error
3. Save your work.
2ND QUARTER LESSONS
2ND QUARTER LESSONS
In Excel, a formula is an expression that
operates on values in a range of cells or
a cell.
For example,
=A1+A2+A3, which finds the sum of the range of
values from cell A1 to cell A3.
2ND QUARTER LESSONS
Functions are predefined formulas in Excel.
They eliminate laborious manual entry of
formulas while giving them human-friendly
names.
For example,
=SUM(A1:A3).
The function sums all the values from A1 to A3.
2ND QUARTER LESSONS
THE COUNT FUNCTION
Count and CountA
COUNT function is generally used to count
a range of cells containing numbers or date
excluding blanks and texts.
THE COUNT FUNCTION
Count and CountA
COUNTA will count everything-- numbers,
dates text, or a range containing a mixture
of these items, but will not count the blank
cells.
ACTIVITY 2
Use COUNTA function
1. Open the file Eli's Palamig Sales Inventory.xlsx
2. In cell B23, count the total menu item in Column A.
Type =COUNTA(A4:A18) and then press Enter.
Question: How many menu items are there? __________
3. Save your work and close the file.
THE COUNT FUNCTION
COUNTIF is a function used to count cells that meet
a single criterion.
COUNTIF can be used to count cells with dates,
numbers, or text that match a specific criteria.
The syntax for this function is =COUNTIF(range,
criteria)
THE COUNT FUNCTION
For example:
=COUNTIF(A1:A6, "RED")
This syntax means that from the cell range
A1:A6, count only if the cell content is RED.
THE COUNT FUNCTION
For example:
=COUNTIF(A1:A6, "RED")
This syntax means that from the cell range
A1:A6, count only if the cell content is RED.
ACTIVITY 3
Use COUNTIF function
1. Open the file Eli's Palamig Sales Inventory.xlsx
2. Count how many items met or exceed the target quantity.
3. In cell C19, type =COUNTIF(C4:C18, "YES").
4. In cell E20, repeat step 2 for Jan 2 (Tue) quantity.
5. In cell C20, count how many items did not meet the target
quantity.
AVERAGE
The function is used to calculate the arithmetic mean of a
given set of arguments in Excel.
For example, if the range A1:A20 contains numbers, the
formula =AVERAGE(A1:A20) returns the average of those
numbers.
ACTIVITY 4
Use AVERAGE function
1. Open the file Eli's Palamig Sales Inventory.xlsx
2. In cell D20, get the average of the values under
Quantity for Monday by typing
=AVERAGE(D4:D18)
3. Do the same thing for Tuesday to Sunday
HOMEWORK
Homework:
Computing Average
Submit the
excel/spreadsheet file
Deadline: October 5, 2022
PETA 2nd Quarter
Creating an Inventory of Capital
Expenses and Sales using Spreadsheet
Application.
DEscription
You and your friends plan to put up a short-term
Ornamental Plant business for the summer.
For this activity, you will be asked to create an inventory
of capital expenses and sales per week for a month
using the Spreadsheet Application.
A.Your Excel file should contain two sheet tabs.
1. Capital Expenses tab
2. Sales tab
DEscription
How to submit?
Send your EXCEL FILE through our
Schoology.
file name: <lastname_firstname>
Submission: October 26, 2022
CLOSING PRAYER
Leader: Let us remember that we are in the Holy Presence of
God. In the name of the Father and of the Son and of the Holy
Spirit.
ALL: Amen.
Leader: O how good, how wonderful it is
ALL: When brothers and sisters live as one.
