NEW
Font size
WorksheetsQuiz 1: Introducing spreadsheets
Total questions: 11
Worksheet time: 6mins
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
The formula in C1 is replicated to cells C2 and C3. What value will be shown in cell C3?
28
22
18
32
