Summary Management of Information (MOI) International Business Y1 (IB)

MOI Summary International Business Year 1
Basics:

Column = Letter

Row = Number

Calculating:

Formulas ->

=Cell + Cell

=Cell – Cell

=Cell / Cell

=Cell*Cell

EXAMPLE: =A2*B2

Calculating with TIME

1. Start time – End time
2. Change time to numbers
3. *24

EXAMPLE: =(C2-B2)*24

Calculating with DATES

Each date = number

01/01/1990 = number 1

EXAMPLE: =(C2-B2)/365,25 (incl. leap year)

Calculate with FUNCTION

=SUM() : adds values together

A1;B2 => AND

A1:B2 => UNTILL

=AVERAGE() -> speaks for itself but EXAMPLE =AVERAGE(A2:B4)

=MIN() -> Lowest number of the list

=MAX() -> Highest number of the list

=COUNT() –> Count NUMBERS in cells in selected area

=COUNTA() –> Count FILLED cells in selected area (dots, spaces, letters, numbers)

=IF() -> return one value if a condition is true and another value if its false

=IF(something is true; then do ; otherwise)