Spreadsheets

Plus de détails

Emulsifier

par Lau Yincheng

Pythagorean Theorem

par Katherine VanMeter

Gun Control

par Pamela Curtis

Electronic Products Controlled Assessment - Specifications

par Jutka Czirok

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)