Functions Flashcards
1
Q
Adds all the numbers in a range of cells
A
Sum
2
Q
Alternative for sum [instead of manually typing =SUM(number1,number2,..) then entering the cell range, or highlighting it]. It is only used below the range to be added.
A
AutoSum (Home > Editing > AutoSum (Ʃ)
3
Q
Entered after typing the function
A
(
4
Q
Shortcut for AutoSum
A
ALT + =
5
Q
Function to calculate the average
A
Average
6
Q
True or False. You can use the name of a cell or range for functions.
A
True.
7
Q
Returns the largest number in a set of values
A
Max
8
Q
Returns the smallest number in a set of values
A
Min
9
Q
Counts the number of cells in a range that contains numbers
A
Count
