Quiz 1: Introducing spreadsheets

Which symbol represents addition?

• +

• -

• /

• *

Which symbol represents subtraction?

• +

• -

• /

• *

Which symbol represents multiplication?

• +

• -

• /

• *

Which symbol represents multiplication?

• +

• -

• /

• *

Which symbol represents division?

• +

• -

• /

• *

A relative cell reference will not change when a formula is replicated.

• True

• False

An example of an absolute cell reference is: =$A$2

• True

• False

The formula in C1 is replicated to cells C2 and C3. What will the formula in cell C2 be?

• =A1+B1

• =A2+B1

• =A1+B2

• =A2+B2

The formula in C1 is replicated to cells C2 and C3. What value will be shown in cell C3?

• 49

• 48

• 26

• 24

The formula in C1 is replicated to cells C2 and C3. What will the formula in cell C2 be?

• =A1+$B$2

• =A2+$B$2

• =A2+$B$1

• =A1+$B$1