Spreadsheets

Mais informações

To kill a mockingbird

por Hyunji Jung

PERMUTATIONS AND COMBINATIONS

por Ralph Roi Diano

Algebraic Reasoning, Graphing and Geometric Connections

por Rachael Hernandez

INTRODUCTION TO SPORTS FIRST AID CARE

por amirah rukaini

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)