

Excel Formulas and Functions
Presentation
•
Computers
•
5th - 6th Grade
•
Medium
Nitu Kedia
Used 460+ times
FREE Resource
12 Slides • 5 Questions
1
Excel Formulas and Functions

2
Pay attention to the next 9 slides.
You will complete a short quiz at the end.
3
What is a function?
They are provided by Excel to help you perform operations.
4
What are the functions of a spreadsheet?
A function is built into the spreadsheet.
All functions allow simple or complex operations.
Each function has specific rules that need to be followed.
5
Functions are written like code.
=AVERGAE (D4:D14) / calculates the average of the numbers from cell D4 to D14.
6
7
Several types of functions
Logical
Text
Financial
Date and Time
Math
8
9
What is a formula?
An equation that is used to perform a calculation.
10
Formulas
Always start with an equal sign.
followed by values or operators such as the +, -, *, / signs. =D4+D5 will add the numbers 15+17 to make 32.
11
12
Multiple Choice
Which are the three essential elements to enter a function?
Equal sign, function name and cell reference.
Function name, data and cell reference.
Equal sign, cell reference and formula.
13
Multiple Choice
How does a function work in a spreadsheet?
Accepts values, performs calculations and displays a chart.
Accepts values, performs calculations and displays a result.
Performs calculations, displays results and accepts numbers.
14
Multiple Choice
These are examples of types of functions in a spreadsheet:
Function sum, function currency and function count.
Text functions, function currency and logical functions.
Logical functions, text functions and financial functions.
15
Multiple Choice
=C4+C5
What is the result?
32
12
17
15
16
Open Ended
The cash is missing for 'Computers For Dummies'. Write a formula to calculate it.
17
All done!
I will check your answers and give you feedback. THANK YOU!
Excel Formulas and Functions

Show answer
Auto Play
Slide 1 / 17
SLIDE
Similar Resources on Wayground
10 questions
6.1 Comparing Functions R.O.C. RECAP
Presentation
•
KG
16 questions
2nd Term - Types of Chart
Presentation
•
6th Grade
14 questions
MS POWERPOINT PRESENTATION
Presentation
•
6th Grade
15 questions
Emails
Presentation
•
6th Grade
14 questions
MESOPOTAMIA
Presentation
•
5th Grade
13 questions
Genetics and Heredity Vocabulary
Presentation
•
4th - 6th Grade
13 questions
Exploring the Functions of the Digestive System
Presentation
•
6th Grade
13 questions
atividade curso
Presentation
•
KG
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