Common Formulas Flashcards
1
Q
Function:
SUM
A
Example:
=SUM(A1:A11)
Description:
Calculates the total of the values in the cell range A1 to A11
2
Q
Function:
AVERAGE
A
Example:
=AVERAGE(B14,B19,C15)
Description:
Calculates the average of the values in cells B14, B19 and C15
3
Q
Function:
MAX
A
Example:
=MAX(C3:C45)
Description:
Returns the maximum value within the cell range C3 to C45
4
Q
Function:
MIN
A
Example:
=MIN(A3:A15)
Description:
Returns the minimum value within the cell range A3 to A15
5
Q
Function:
COUNT
A
Example:
=COUNT(A1:A10)
Description:
Counts the total number of cells within the range A1:A10 that contains numbers
6
Q
Function:
SQRT
A
Example:
=SQRT(A2)
Description:
Returns the square root of the value cell A2
