P5 Spreadsheets

Which symbol is used to represent multiplication in a formula in Google Sheets?

• +

• -

• /

• *

What does the function SUM do in Google Sheets?

• Finds the average of numbers

• Adds up a range of numbers

• Divides two numbers

Which describes a single box in a Google Sheets spreadsheet?

• Cell

• Block

• Unit

• Section

What does the term "cell reference" mean in Google Sheets?

• A contact number

• The location of a cell in a spreadsheet

• A reference book for cells

Formulas should always begin with a(n) ________.

• equals sign

• header

• dollar sign

• hashtag

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

• 'SheetName'!CellReference

• CellReference/'SheetName'

• 'CellReference'-SheetName

• 'SheetName'/CellReference

What does the formula "=A1+B1" in a cell perform?

• Adds the values in cells A1 and B1

• Multiplies the values in cells A1 and B1

• Divides the values in cells A1 and B1

• Subtracts the values in cells A1 and B1

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

• Type the currency symbol manually

• Use the "Format" menu and choose "Currency"

• Apply a custom number format with the currency symbol

• Change the font color to green

What does the range A2:A6 represent in the formula "=SUM(A2:A6)"?

• all values in column A from A2 to A6

• Value from A2

• Value from A6

• All values from column A

Look at the image . What is the cell reference for the highlighted cell?

• B2

• 3C

• C3

• 2B