Unit 4 Lesson 2 (Part 2): Spreadsheet Functions Flashcards
1
Q
-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
A
Syntax
2
Q
order of the syntax
A
n equal sign (=) followed by the name of the function
you want to use. The function name is followed by an open parenthesis then the argument, usually a range of cells and enclosed by a closing parenthesis
=SUM(A1:A20)
3
Q
Commonly used functions:
a function that adds all the values of the cells in the argument
A
SUM
4
Q
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
A
AVERAGE
5
Q
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
A
COUNT
6
Q
Commonly used functions:
a function that looks for the highest value in the range
A
MAX
7
Q
Commonly used functions:
a function that looks for the lowest value in the range
A
MIN
8
Q
A
9
Q
A
