How2Excel 1 - Data types and basic formulae

What is the cell reference for the selected blue cell?

• B

• 4B

• B4

• 4

What is the cell range for the selected blue cells?

• B2

• B2-E2

• B2,E2

• B2:E2

What is the cell range for the selected blue cells?

• B2

• B2-E2

• B2,E2

• B2:E2

What is the cell range for the selected orange cells?

• C3:E7

• C3:E3,C4:E4,C5:E5,C6:E6

• C3,E7

• 3C:7C

What formula should C2 contain, to add together the contents of A2 and B2?

• 6+8

• =6+8

• A2+B2

• =A2+B2

If we copy down (drag down) the formula in C2, the reference of A2 and B2 will change to A3 and B3. This is because A2 and B2 are (a)   cell references?

What formula should C2 contain to multiply the contents of A2 and B2?

• =A2*B2

• =A2xB2

• =A2+B2

• =A2,B2

What formula should C2 contain to subtract the contents of A2 from B2?

• =A2-B2

• =B2-A2

• =A2/B2

• =B2,A2

To create a 'Times' table', B1, B2, B3, etc all need to multiply with A1. What formula will C1 (blue) contain, to allow the formula in C1 to be 'copied down' into B1, B2, B3, etc?

• =A1*B1

• =A1*$B$1

• =$A$1*B1

• =$A$1*$B$1

To create a 'Times' table', B1, B2, B3, etc all need to multiply with A1. The formula will allow the formula in C1 to be 'copied down' into B1, B2, B3, etc, and 'lock' onto A1 every time. What do we call this? We have changed the cell reference to A1 into an (a)   cell reference.