

Google Sheets: Working with functions
Presentation
•
Other
•
9th - 12th Grade
•
Practice Problem
•
Easy
Carolyn Vanterpool
Used 10+ times
FREE Resource
17 Slides • 6 Questions
1
Google Sheets: Working with functions

2
objectives
Define Function
know the parts of a function
Describe common functions
Enter functions in a spreadsheet
3
Instructions
Watch the Video and answer the questions that follows.
4
5
Multiple Select
Why is it important to use functions?
They save you time
The make the work more complicated.
6
7
Multiple Select
Google sheets have functions that allow you to calculate difficult problems
true
false
8
Multiple Choice
Why is a function better to use that a formula?
Functions are more tedious and really long
functions makes it more difficult to calculate many cells
Functions make calculations simple and easy
9
10
Multiple Choice
What is the first step to creating a function?
Create a formula using cell reference
Selecting the cell range
clicking the function icon toolbar
11
12
Function Structure
like formulas, a function must also start with an equal sign in the first character of a cell
13
=SUM
The function name indicates the operation to be performed, such as sum.
14
Function Structure
Arguments are the information you want to use in the function's calculations
can refer to both individual cells and cell ranges
can include one argumnt or multiple arguments
Should be in parenthesis because it tells the formula which cells or numbers to use when calculating the results.
15
Open Ended
What is the proper structure of a function?
16
Common Functions
There are hundreds of functions taht you can use. They are grouped into many different categories such as financial, statistical, date and time, and math functions.
17
Some of the most common Functions you will use are
=SUM which adds all the values in a range of cell
=AVERAGE which calculates the average of the rante of cells by summing the cells and dividing that value by the numbr os cells used to find the sum.
=COUNT which counts the cells with numerical values in the range of cells
=MIN finds the smallest value in a range of cell
=MAX finds the largest value in a range of cell
18
Common Functions
Blank cells or cells without text or data in it are always ignored.
19
Summary
In this lesson, you learned about functions, their structure and how to enter functions in a spreadsheet
20
Assignment
Unit 3 Lesson 18 My check register
Posted in Google Classroom
21
common functions
22
23
Open Ended
What is a cell Range?
Google Sheets: Working with functions

Show answer
Auto Play
Slide 1 / 23
SLIDE
Similar Resources on Wayground
18 questions
Basic negation French
Presentation
•
9th - 12th Grade
17 questions
Set SMART Goals
Presentation
•
9th - 12th Grade
17 questions
Family Roles
Presentation
•
9th - 12th Grade
21 questions
Paycheck
Presentation
•
9th - 12th Grade
20 questions
GENERAL KNOWLEDGE
Presentation
•
9th Grade - University
16 questions
Time Connectives and Conjunctions
Presentation
•
10th - 12th Grade
18 questions
Early Cold War
Presentation
•
9th - 12th Grade
18 questions
Points, Lines, Planes, and Angles
Presentation
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Safety Day 2026 – Student Review
Quiz
•
9th Grade
21 questions
Continents and Oceans
Quiz
•
6th Grade
20 questions
Parts of Speech
Quiz
•
5th Grade
16 questions
Subject & Predicate
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
12 questions
Map Skills
Quiz
•
3rd Grade
22 questions
Continents and Oceans
Quiz
•
5th Grade
15 questions
Rounding Decimals
Quiz
•
5th Grade
Discover more resources for Other
10 questions
Safety Day 2026 – Student Review
Quiz
•
9th Grade
20 questions
REGULAR Present tense verbs
Quiz
•
8th - 9th Grade
26 questions
SLIME!!!!!
Quiz
•
KG - 12th Grade
20 questions
Cell organelles and functions
Quiz
•
10th Grade
10 questions
Test Your Knowledge on Bullying
Quiz
•
9th Grade
12 questions
Absolute Value Equations
Quiz
•
9th Grade
20 questions
Position vs. Time Graphs
Quiz
•
9th Grade
20 questions
Function or Not a Function
Quiz
•
8th - 9th Grade