Google Sheets: Functions and Behavior Check-Up

What does the equal sign do at the beginning of an expression in a spreadsheet?

• It indicates a comment.

• It starts a formula.

• It formats the cell as text.

• It locks the cell reference.

Which function would you use to generate a random number between 1 and 10?

• RAND()

• IF()

• RANDBETWEEN(1, 10)

• COUNTIF()

How does recalculation affect randomly generated cell values in a spreadsheet?

• It keeps the values constant.

• It changes the values each time recalculation occurs.

• It deletes the values.

• It formats the values as text.

What is the difference between copying a cell and copying the contents of a cell?

• Copying a cell includes its formatting, while copying contents does not.

• Copying a cell deletes the original, while copying contents does not.

• Copying a cell moves it, while copying contents duplicates it.

• There is no difference.

When using the function IF(), what is the purpose of the logical test?

• To perform arithmetic operations.

• To determine which value to return.

• To format the cell.

• To generate random numbers.

How can you lock a cell reference in a formula?

• By using the "@" symbol.

• By using the "#" symbol.

• By using the "$" character.

• By using the "&" symbol.

What happens to cell references when you copy and paste a formula?

• They remain absolute.

• They change relative to the new location.

• They become text.

• They are deleted.

How can you highlight multiple columns in a spreadsheet?

• CTRL+SHIFT+UP ARROW

• CTRL+SHIFT+RIGHT ARROW

• ALT+SHIFT+RIGHT ARROW

• CTRL+ALT+RIGHT ARROW

What is the difference between numbers and text in a spreadsheet?

• Numbers can be used in calculations, text cannot.

• Text can be used in calculations, numbers cannot.

• There is no difference.

• Text is always bold, numbers are not.

Use the functions RAND() and IF() to simulate a coin toss. Enter the correct expression just like you would enter it into Google Sheets.