Unit 4: Spreadsheet Skills
Lesson 2
Inserting Formulas and Functions
Empowerment Technologies
Senior High School Applied - Academic
What do you think will
happen if you have a lot of
data but you need to
make computations
manually?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 2
In your opinion,
how useful are
spreadsheets
for
computations?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 3
● Identify the different operators
used in a spreadsheet.
Learning
● Identify the different parts of
Objectives function.
At the end of the
● Demonstrate the creation of a
lesson, you should be formula using a function.
able to do the
following: ● Use the function library to insert a
function.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 44
What words
come to mind
when you see
these images on
a computer
screen?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 55
Spreadsheet
1. What is a spreadsheet? What are its main
features?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 6
Spreadsheet
2. In your opinion, in what tasks or jobs would a
spreadsheet application be useful? Share an
example.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 7
Spreadsheet
3. How can you use a spreadsheet application in
your daily life or in your chosen field?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 8
What is Microsoft
Excel?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 9
Microsoft Excel is a
spreadsheet
application used to
perform mathematical
equations without
manual computation.
It shows only the
results to the given
operations and data.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 10
What are the
different
operators used
in a
spreadsheet?
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 11
Types of Operators
● Arithmetic
● Comparison
● Text
Concatenation
● Reference
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 12
12
How can we create a simple and
basic formula using those operators?
13
Factors to consider
before creating
formula:
1. Locate the cell
reference of each
piece of data or
use the point-click
method
2. Use Fill Handle to
copy formulas
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 14
14
Creating a basic formula
1. Select the cell where
formula will be entered.
2. Type the equal sign and
select the cell that has
the value/s to be
computed using the
point-click method.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 15
15
Creating a basic formula
3. Add the operator needed
in the formula (arithmetic,
comparison, concatenation,
or reference).
4. Select another cell with a
desired value (use point-
click method) and hit Enter.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 16
16
How can we use functions as part of
the Excel formula?
17
Spreadsheet
Functions
● predefined
operations using
different formulas
● named after their
function
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 18
Parts of a Function
● Equal Sign
● Function name
● Argument
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 19
Did you know?
● Creating formulas with functions
added has the same procedure as
formulas using operating symbols.
● The only difference is you use
function names instead of operating
symbols (as in the image given on
the previous slide)
20
Commonly Used Functions
● SUM
● AVERAGE
● COUNT
● MIN
● MAX
● CONCATENATE
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 21
21
Are there other functions used
besides those given above?
22
Function Library
Different functions
are available in the
function library,
which can be found
inside the
Formulas tab.
ENGAGE EXPLORE EXPLAIN EXTEND EVALUATE 23
Wrap Up
There are four types of operators for spreadsheets,
namely Arithmetic Operators, Comparison Operators,
Text Concatenation Operator, and Reference
Operators.
You need to use cell names in order to have a cell
reference that you can use to create your formula.
The Fill Handle can be used to easily copy and apply
one formula to other cells, thus saving time.
24
Wrap Up
A syntax must be followed for a function to work in a
spreadsheet. The function syntax starts with an equal sign
(=) followed by the function name and then the
argument enclosed in parentheses.
The commonly used functions are SUM, AVERAGE,
COUNT, MIN, and MAX.
The Function Library can be found on the Formulas tab in
the Ribbon. It contains different functions under different
categories.
25
Bibliography
“Calculation operators and precedence in Excel.” Office Support.
https://support.office.com/en-us/article/calculation-operators-and-precedence-
in-excel-48be406d-4975-4d31-b2b8-7af9e0e2878a (accessed April 1 2020).
“Create a formula by using a Function.” Excel. https://support.office.com/en-
us/article/create-a-formula-by-using-a-function-4c6b47d3-1c39-49ec-b79e-
8f209e4cab7e (accessed April 1 2020).
“Creating Formulas with Functions.” MIT, August 24, 1999.
http://www.mit.edu/~mbarker/formula1/f1help/01-intr8.htm
“Excel 2013: Functions.” GCFGlobal.org.
https://edu.gcfglobal.org/en/excel2013/functions/1/ (accessed April 1 2020).
26
Bibliography
“Excel 2013: Simple Formulas.” GCFGlobal.org.
https://edu.gcfglobal.org/en/excel2013/simple-formulas/1/ (accessed April 1
2020).
“Excel: Intro to Formulas.” GCFGlobal.org. https://edu.gcfglobal.org/en/excel/intro-
to-formulas/1/ (accessed April 1 2020).
“Using Microsoft Excel: What Is a Function?” Research Guides. M Library, June 17,
2019.
https://guides.lib.umich.edu/c.php?g=283162&p=1888331
27
