Understanding Spreadsheet Formulas and References

Which of the following is the correct way to start a formula in a spreadsheet cell?

• By typing a colon (:)

• By typing an equals sign (=)

• By typing a plus sign (+)

• By typing a hash (#)

What does the formula `=A1+B1` do in a spreadsheet?

• Adds the values in cells A1 and B1

• Multiplies the values in cells A1 and B1

• Subtracts B1 from A1

• Divides A1 by B1

Which of the following is an example of a relative cell reference?

• A$1

• $A1

• A1

What is the result of copying the formula `=B2+C2` from cell D2 to D3?

• =B2+C2

• =B3+C3

• =B1+C1

• =B2+C3

Which symbol is used to make a cell reference absolute in a spreadsheet formula?

• $

• #

• &

• %

• Both references are relative

• Both references are absolute

If you copy the formula `=A1*2` from cell B1 to cell B2, what will the formula become in B2?

• =A1*2

• =A2*2

• =B1*2

• =B2*2

Which of the following is a mixed cell reference?

• A1

• $A1

• 1A

What does the formula `=SUM(A1:A5)` do?

• Multiplies all values from A1 to A5

• Adds all values from A1 to A5

• Finds the average of A1 to A5

• Subtracts A5 from A1

Which formula will always refer to cell C3, no matter where it is copied?

• C3

• $C3

• C$3