F24 MRDM MIDTERM REVIEW GOOGLE SHEETS 1

Front

How can you move a row in Google Sheets?

Back

Click on the row and drag it.

Front

Which symbol indicates the start of an equation or formula in Google Sheets?

Back

=

Front

What function is used to calculate the average of a range of cells?

Back

AVERAGE

Front

How do you select a column in Google Sheets?

Back

Click on the letter at the top of the column.

Front

What keyboard shortcut cancels a command in Google Sheets?

Back

Escape

Front

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

Back

To add up a range of numbers.

Front

How do you insert a new row in Google Sheets?

Back

Right-click on a row number and select 'Insert row'.

Front

What does the COUNT function do in Google Sheets?

Back

Counts the number of cells that contain numbers.

Front

How can you format a cell to display currency in Google Sheets?

Back

Select the cell, then choose 'Format' > 'Number' > 'Currency'.

Front

What is the difference between relative and absolute cell references?

Back

Relative references change when copied; absolute references do not.