Google Sheets Quiz1

What is an active cell?

• The first cell in a spreadsheet

• The selected cell in a spreadsheet

• A cell with a value

• A cell with a formula

Select the correct formulas

• =A1+B1

• A1+B1

• A1*B1

• =SUM(A1:B1)

Show me a value

• =A1+B1

• A1+B1

• 10

• A1*B1

Show me a label

• A1+B1

• Text

• 10

• =A1+B1

Add the 2 numbers together

• A1+B1

• =SUM(A1:B1)

• =A1+B1

• A1*B1

What is a cell reference?

• The location of a cell in a spreadsheet, represented by the column letter and row number

• A formula in a cell

• The value of a cell

• The label of a cell

What is the result of the formula '=A1*B1' when A1=2 and B1=3?

• 5

• 6

• 8

• 9

What does the formula '=SUM(A1:B1)' do?

• Adds the values of cells A1 and B1

• Subtracts the value of cell B1 from A1

• Multiples the values of cells A1 and B1

• Divides the value of cell A1 by B1

What is the result of the formula '=A1+A2' when A1=5 and A2=3?

• 7

• 8

• 9

• 10

What does the formula '=AVERAGE(A1:B1)' do?

• Adds the values of cells A1 and B1

• Finds the average of cells A1 and B1

• Multiples the values of cells A1 and B1

• Divides the value of cell A1 by B1