Exel Diagram

What is a spreadsheet

A document that data can be entered into.

The uses of Exel

Charts, Calendars, Invoice

Exel UI

image

Selecting cells

Entering Data

Formatting Cells

Basic Maths

Simple Formula

The Fill Handle

Fills all cells selected with the sequence of values.

Specify the cells you would like to do maths with. eg. "=A2+C2+E2"

SHIFT + CTRL

Type in the cells to enter data. This could be words, numbers or formulas.

Rows and columns

Left click to select, right click for more options. The Name box helps identify the cell selected.

=SUM(A1 Z1)

Used to make tables.

Collumns A-Z

Rows Numbers

Can change things about the cell.

Can select multiple cells.

Click and drag

Keys

Select area before typing

Holding CTRL can select individual cells.

= A2 + B4

+

-

*

/

BIDMAS (4+4)

click to edit