Empowerment Technology
by:
Roel D. Madarcos
LETS REVIEW!
1. What is the importance of using mail
merge?
2. What are the steps in creating mail
merge?
2. What are the materials that we can
integrate in MS Word?
Scenario:
Greta conducted a research about
Out of School Youth in Barangay New
Barbacan, Roxas, Palawan. In his
research he gathered the following
data.
Questions:
1. What software or application did
Greta used to come up with her
survey result? Why?
LESSON OBJECTIVES:
1. Familiarize the basic parts of Microsoft
excel
2. Use the most commonly used functions
available in Microsoft Excel
3. Use Microsoft excel as a viable tool in
market research and product
development
4. Value the importance of Microsoft excel
ADVANCED
SPREADSHEET SKILLS
Activity
Instructions:
[Link] your partner (your seatmate).
[Link] Microsoft excel.
[Link] Excel in 60 seconds.
With your partner, name each part of Microsoft Excel application.
1 Box
Name
Formula
2 Bar
Row
Column3Heading
H
e
a
4
d
i
n
g
5 Tab
Sheet Cell
6
Microsoft Excel?
• It is a program designed to create
spreadsheets which can later be
used to analyze statistical data.
Common Parts of Microsoft Excel
Name Box Column Heading Formula Bar
Row
Formula Bar – this is where the
H
Sheet
Cell Tabs–
– this used to
is where youdisplay the
type any
e Name Cell–
Column
Sheet
Name
formula
Row Boxor –the
Tab–
Box
Heading
Column this––place
Heading–
text isused
Headingisthis
where where
the
to
is
entered.
rows – box
the at
display
wherename
Always
containing
column
a
ofthe
start Row
worksheet
information
Formula
active
with Heading–
Bar
cell
EQUAL
you
or
is
text.
numbers.– are
used
being
sign adisplayed.
whenrow
currently
Formula
to also
enter
using a
d
information
the
the containing
top
name of
worksheet
of
working
appears is
each
activeheld
letters.
that
innumber
cell. in
column
cell a
is
is
i
containing
text or formula a
a formula.
spreadsheet
containing
currently
being a letter.
working.
displayed.
n
g
Cell
5
Sheet Tab
Microsoft Excel Common
Functions
a. COUNT – a function used to
count cells with content in a range.
b. SUM – a function used to
compute for the summation of the
number of range
Microsoft Excel Common
Functions
c. AVERAGE– a function used to
compute for the average of the
number of range.
Microsoft Excel Conditional
Functions
a. COUNTIF – a function used to
count the cells with a specified
content within a range
COUNTIF SYNTAX
=COUNTIF(range, criteria)
▪ Range – the cells where the
counting will take place
▪ Criteria – the label or value that
determines if it is to be counted
Microsoft Excel Conditional
Functions
b. AVERAGEIF - a function used to
compute for the average if a
certain condition is met.
AVERAGEIF SYNTAX
=AVERAGEIF(range, criteria, average range)
▪ Range – the range of cells where
you want to look for criteria
AVERAGEIF SYNTAX
▪ Criteria – the label or value that
determines if a cell is part of the
range to be averaged.
▪ Average Range – the actual
range of cells that will be
averaged, if omitted the range
will be used instead.
Microsoft Excel Conditional
Functions
c. SUMIF - a function used to
compute for the summation of a
range if a certain condition is met.
SUMIF SYNTAX
=SUMIF(range, criteria, sum range)
▪ Range – the range of cells where
you want to look for criteria
SUMIF SYNTAX
▪ Criteria – the label or value that
determines if a cell is part of the
range to be summed.
▪ Average Range – the actual
range of cells that will be
summed, if omitted the range will
be used instead.
ACTIVITY:
Instructions:
1. Look for Excel_Activity file located in Local Disk D.
Open it.
2. Read the instructions and write the formula needed
to perform computation.
3. Each task is equivalent to 5 points.
4. Do this activity in 5 minutes.
5. Save your activity with your name as the filename
for checking of output later.
6. You will be graded based on the rubrics presented.
Rubric for Today’s Activity
SCORE DESCRIPTION
5 Formula contain no errors.
4 Formula have one (1) error.
3 Formula have two (2) errors
2 Formula have three (3) errors
1 Formula have four or more errors.
GENERALIZAITON:
What is the importance or advantages
of using spreadsheet than in manual
computation?
Short Quiz (1-5)
1. In which part of Microsoft Excel is the
active cell being displayed?
a. Name Box
b. Column Heading
c. Row Heading
d. Cell
Short Quiz (1-5)
2. It refers to the column at the top that
contains the letters.
a. Name Box
b. Column Heading
c. Row Heading
d. Cell
Short Quiz (1-5)
3. A function used to compute for the
average of the number of a range.
a. Average
b. Sum
c. AverageIf
d. SumIF
Short Quiz (1-5)
4. It is a program designed to create a
spreadsheet.
a. Microsoft Excel
b. Spreadsheet
c. Worksheet
d. Summation
Short Quiz (1-5)
5. It is where the formula or text is
being copy or entered.
a. Formula Bar
b. Sheet Tab
c. Worksheet
d. Summation
Answer
1. In which part of Microsoft Excel is the
active cell being displayed?
a. Name Box
b. Column Heading
c. Row Heading
d. Cell
Answer
2. It refers to the column at the top that
contains the letters.
a. Name Box
b. Column Heading
c. Row Heading
d. Cell
Answer
3. A function used to compute for the
average of the number of a range.
a. Average
b. Sum
c. AverageIf
d. SumIF
Answer
4. It is a program designed to create a
spreadsheet.
a. Microsoft Excel
b. Spreadsheet
c. Worksheet
d. Summation
Answer
5. It is where the formula or text is
being copy or entered.
a. Formula Bar
b. Sheet Tab
c. Worksheet
d. Summation
Answer
5. It is where the formula or text is
being copy or entered.
a. Formula Bar
b. Sheet Tab
c. Worksheet
d. Summation
Additional Activities for Application
• Create a spreadsheet of your
weekly allowance by using the
functions of Ms Excel.
• Send your output through email @
[Link]@[Link]