MS Excel

Manipulation of data into a spreadsheet is a SURVIVAL tool for life - making calculations via formula then extracting certain information to produce correctly labelled graphs.

EXCEL TERMINOLOGY

A SPREADSHEET is a document made up of columns and rows.

They are used to perform all sorts of calculations. Many people use them in their personal lives as well as in business. The program we use for spreadsheets is MS EXCEL.

You must remember that columns go down and rows go across. Where the two meet is called a cell.

Cool tips: <CTRL> + arrow down gets you to the end of the spreadsheet

Are you able to correctly speak "Microsoft Excell"?

What about the ribbons?

GRAPHS

Line Graph use this to show a trend within the data.

Column Graph use these when the counting of different things is involved – comparisons.

Pie Graph use this to show % figures (proportions).

FORMULAS

All formulae start with the = sign.

When using spreadsheets we use formulae to make calculations. The basic formulae are: addition, subtraction, multiplication and division.

The symbols used are +, -, *, /.

If applying formula to a cell range (3 or more) ensure you show this: (for example)

=SUM(B5:D5) NOT =SUM(B5+C5+D5)
Only use + when adding TWO cells together. Example: =C6+C7

When calculating AVERAGES, MAXIMUMS OR MINIMUMS you write in: =AVERAGE(B2:F2), =MIN(B2:F2) Or you can use the Autosum feature.