Page 16 - Ones and Zeros 2 (Workbook)

4 Spreadsheets
4

Lesson 4

Multiplication and Division

1. Open the file ‘My Toy Collection.xlsx’.

2. n the third worksheet named ‘Model Aeroplanes’, add the following
I
information:

Cell B2: Friends I have

Cell B3: Planes I gave each friend

Cell B4: Total planes I gave away

Cell C2: 26

Cell C3: 6

3. Use a formula in cell C4. Multiply cells C2 and C3.

4. What is the total? .

5. Now, go to the fourth worksheet named ‘Action Figures’ and add the

following information:

Cell B2: Action figures I used to have

Cell B3: Action figures I gave away to friends

Cell B4: Total number

of action figures each
friend got

Cell C2: 32

Cell C3: 8

6. Use a formula in cell C4. Divide cells C2 and C3.

7. What is the total? .

8. Save the file.

14