Spreadsheets

Data

text (label)

value (number)

formula

Formula

simple operators

r

Examples are : =A5+B5=C2*B4

Conditional =IF

r

Use this to find out if a condition existsIF ( condition exists, then enter this , otherwise this )Example=IF(B3>100 , £100 , 0 )or=IF(D9 > 50 , "Discount", " ")

Protection

Manual formula update

Automatic formula update

Lock cells with passwords

Charting

Used to show trends

Displays data so that it is easy to read

Subtopic

Function

=SUM

r

adds a range of cells=SUM (A5:A10)

=Average

r

finds the average over a range of cells

=MAX

r

finds the biggest value over a range of cells

=MIN

r

Finds the smallest value in a range of cells

Structure

Row

Column

Alter column width

Alter row height

Cell

Attributes

r

Cell attributes can be changed/formatted:bolditalicscolournumber of decimal placespercentagecurrencyetc

Referencing

Absolute

r

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

Relative

r

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