Spreadsheets

Mere som dette

Area and Perimeter

af Love Erin

Cell analogy

af Natalia Kaufman

CELLS

af Erica Mertens

ONU

af Alberto Carbone

Spreadsheets

Referencing

Relative

Relative cell referencing allows cells to change when a formula is replicated through a range of cells

Absolute

Absolute cell referencing fixes a cell so that it doesn't change when a formula is replicated through a range of cells

Structure

Cell

Attributes

Cell attributes can be changed/formatted:

bold

italics

colour

number of decimal places

percentage

currency

etc

Alter row height

Alter column width

Column

Row

Function

=MIN

Finds the smallest value in a range of cells

=MAX

finds the biggest value over a range of cells

=Average

finds the average over a range of cells

=SUM

adds a range of cells

=SUM (A5:A10)

Charting

Subtopic

Displays data so that it is easy to read

Used to show trends

Protection

Lock cells with passwords

Automatic formula update

Manual formula update

Formula

Conditional =IF

Use this to find out if a condition exists

IF ( condition exists, then enter this , otherwise this )

Example

=IF(B3>100 , £100 , 0 )

or

=IF(D9 > 50 , "Discount", " ")

simple operators

Examples are :

=A5+B5

=C2*B4

Data

formula

value (number)

text (label)