Google Sheets: Working with Functions Flashcard

Front

What is a function in Google Sheets?

Back

A predefined formula that performs calculations.

Front

What symbol is used to start a function in Google Sheets?

Back

Equals sign (=)

Front

Which function is used to find the mean of a range of cells? Options: AVERAGE, COUNT, MAX, SUM

Back

AVERAGE

Front

What does the SUM function do?

Back

Adds values

Front

What does the COUNT Function do?

Back

Gives the number of cells with numerical data

Front

What is the correct syntax for the function to find the average of the data in cells A1 to A10?

Back

=AVERAGE(A1:A10)

Front

What does the MIN function do?

Back

Finds the minimum value

Front

Which function would you use to find the largest number of units sold by a troop?

Back

MAX

Front

What is the underlined part of the Function called. (The section in red)

Back

argument

Front

Which is an example of an absolute cell reference? Options: A1, A1:A9, $A$1, A1*A9

Back

$A$1