Google Sheets Formulas Flashcard

Front

What is the shortcut to cut data from one cell and paste it into another in Google Sheets?

Back

Press 'ctrl x' & 'ctrl v'.

Front

How do you insert a chart in Google Sheets?

Back

Use the 'Insert' menu and select 'Chart'.

Front

What formula would you use to add the values in cells H1 through H10?

Back

=SUM(H1:H10)

Front

What symbol do all formulas in Google Sheets begin with?

Back

=

Front

If you want to sum the numbers from cells A1 to A3, which formula is correct?

Back

=SUM(A1:A3)

Front

What is the function of the SUM formula in Google Sheets?

Back

It adds together a range of numbers.

Front

What does the AVERAGE function do in Google Sheets?

Back

It calculates the average of a range of numbers.

Front

How do you reference a cell in another sheet in Google Sheets?

Back

Use the format 'SheetName!CellReference'.

Front

What is the purpose of the IF function in Google Sheets?

Back

It returns one value if a condition is true and another value if it's false.

Front

What does the COUNT function do in Google Sheets?

Back

It counts the number of cells that contain numbers.