Excel Formulas and Functions

Presentation

•

Computers

•

5th - 6th Grade

•

Medium

Nitu Kedia

Used 460+ times

FREE Resource

12 Slides • 5 Questions

Excel Formulas and Functions

Pay attention to the next 9 slides.

You will complete a short quiz at the end.

What is a function?

They are provided by Excel to help you perform operations.

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.

Functions are written like code.

=AVERGAE (D4:D14) / calculates the average of the numbers from cell D4 to D14.

Several types of functions

Logical
Text
Financial
Date and Time
Math

What is a formula?

An equation that is used to perform a calculation.

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.

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.

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.

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.

Multiple Choice

=C4+C5

What is the result?

Open Ended

The cash is missing for 'Computers For Dummies'. Write a formula to calculate it.

Type response here

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

บทเรียนวิชาคอมพิวเตอร์พื้นฐาน

Presentation

•

14 questions

Prefixes and Suffixes + Spiral Review

Presentation

•

5th Grade

11 questions

Y6 - Chapter 1 - Know Your Computer

Presentation

•

6th Grade

12 questions

Mrs. Johnson's Cell Lesson

Presentation

•

6th Grade

16 questions

Science Review 5.6A

Presentation

•

5th Grade

15 questions

Collecting Data

Presentation

•

6th Grade

16 questions

Algebra 1 FSA EOC Practice Test ~ Non-Calculator

Presentation

•

10th - 11th Grade

10 questions

untitled

Presentation

•

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Discover more resources for Computers

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade