More on Spreadsheets

1
More on Spreadsheets

• By Emily Baddeley, Emma Brock, Stephanie Beach
  and Tom Drew.

2
Introduction

• Spreadsheets allow you to carry out complex
  calculations on numerical data input into cells
  by using formulae.

• The formulae should be entered into the cell in
  which you require the answer to the calculation
  to be stored and displayed.

All formulae are preceded by the equals sign ()
to indicate to the programme the need to carry
out a calculation on the contents of the cells
which follow.
3
Addition

• There are two ways you can add together the
  contents of two cells. Firstly you can enter the
  cell addresses you would like to add together.
  For example

B2C2D2E2F2
However, if the cell addresses are consecutive,
then the spreadsheet only needs you to enter the
digits of the first and last cells separated by
two full stops (..) or a colon (). The formula
will now look like this SUM(B2..F2) or SUM(B2F
2)
4
Subtraction
To take away or subtract the contents of one cell
from another the equals sign () should be
entered followed by the two cell addresses
separated by a minus sign (-). For example

• D3-F3

5
Multiplication

• To multiply the contents of two cells the equals
  sign () should be entered followed by the two
  cell addresses separated by the multiplication
  sign (). For example

C3G2
6
Division

• Finally, to divide the the contents of two cells
  the equals sign () should be entered followed by
  the two cell addresses separated by the division
  sign (/). The second cell is divided into the
  first. For example

D4/D5