Unit 4 Lesson 2 (Part 2): Spreadsheet Functions

Question 1

-a specific format that a function needs to follow to work properly

-starts with an equal sign (=) followed by the name of the function you want to use

Answer 1

Syntax

Question 2

order of the syntax

Answer 2

=SUM(A1:A20)

1. Eual sign
2. Function name
3. Argument

Question 3

Commonly used functions:

a function that adds all the values of the cells in the argument

Answer 3

SUM

Question 4

Commonly used functions:

• a function that computes the average value of the cells in the argument
• it computes the sum first and divides it by the number of cells in the argument

Answer 4

AVERAGE

Question 5

Commonly used functions:

• a function that checks the number of cells in the range given
• this function is useful if you need to count items

Answer 5

COUNT

Question 6

Commonly used functions:

a function that looks for the highest value in the range

Answer 6

MAX

Question 7

Commonly used functions:

a function that looks for the lowest value in the range

Answer 7

MIN