Google Sheets: Working with Functions Flashcard

What is a function in Google Sheets?

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

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

What does the SUM function do?

What does the COUNT Function do?

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

What does the MIN function do?

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

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

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