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)
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)
