Google Sheets: Working with functions

Google Sheets: Working with functions

objectives

• Define Function

• know the parts of a function

• Describe common functions

• Enter functions in a spreadsheet

Instructions

Watch the Video and answer the questions that follows.

Multiple Select

Why is it important to use functions?

• They save you time

• The make the work more complicated.

Multiple Select

Google sheets have functions that allow you to calculate difficult problems

• true

• false

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

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

Function Structure

like formulas, a function must also start with an equal sign in the first character of a cell

=SUM

The function name indicates the operation to be performed, such as sum.

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.

Open Ended

What is the proper structure of a function?

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.

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

Common Functions

Blank cells or cells without text or data in it are always ignored.

Summary

In this lesson, you learned about functions, their structure and how to enter functions in a spreadsheet

Assignment

Unit 3 Lesson 18 My check register

Posted in Google Classroom

common functions

Open Ended

What is a cell Range?