, GRADE 10
4.1 BASIC FUNCTIONS
-
SUM
AVERAGE
'
MIN
-
MAX
'
→
Use c.) full stop when typing decimals
→
☒ Don't in
type currency can't perform calculations
=
.
→
C) before #
Numbers as text I.
quotation mark
=
2. Data format to cell to text
→
Dates treated as numbers
→
Auto fill [ can be used horizontally or vertically ]
4.2 CALCULATIONS
•
VAT :
Multiply VAT % by price
Add VAT i. price for total
ENTER !
Naming Name Box
•
cells : Type name in and press
Fitting Decrease font size
•
1 worksheet a
page
:
on
-
Decrease
•
margins
•
Decrease column width
Change orientation to
landscape
-
ERROR MESSAGES
# VALUE ! data
wrong type
:
# DIV / 0 ! ÷
by
:
0 or empty cell
# NAME ? i.
Invalid function name
" "
.
left out from text
Missing :
-
# REF ! cell reference longer valid
:
no
# NUM ! :
Invalid numerical value .
4} . ANALYSING DATA
→
Count :
counts numbers only
→
Counter :
counts number of cells
→
Count blank :
counts empty cells
→
Count If :
counts number of cells with specific criterion
→
Rand :
random # 0 & I
→ Rand between : random whole #
→ Mode : Most frequent #
→
Median : Middle #
Today current date
→ :
→ Now :
current date & time
4.1 BASIC FUNCTIONS
-
SUM
AVERAGE
'
MIN
-
MAX
'
→
Use c.) full stop when typing decimals
→
☒ Don't in
type currency can't perform calculations
=
.
→
C) before #
Numbers as text I.
quotation mark
=
2. Data format to cell to text
→
Dates treated as numbers
→
Auto fill [ can be used horizontally or vertically ]
4.2 CALCULATIONS
•
VAT :
Multiply VAT % by price
Add VAT i. price for total
ENTER !
Naming Name Box
•
cells : Type name in and press
Fitting Decrease font size
•
1 worksheet a
page
:
on
-
Decrease
•
margins
•
Decrease column width
Change orientation to
landscape
-
ERROR MESSAGES
# VALUE ! data
wrong type
:
# DIV / 0 ! ÷
by
:
0 or empty cell
# NAME ? i.
Invalid function name
" "
.
left out from text
Missing :
-
# REF ! cell reference longer valid
:
no
# NUM ! :
Invalid numerical value .
4} . ANALYSING DATA
→
Count :
counts numbers only
→
Counter :
counts number of cells
→
Count blank :
counts empty cells
→
Count If :
counts number of cells with specific criterion
→
Rand :
random # 0 & I
→ Rand between : random whole #
→ Mode : Most frequent #
→
Median : Middle #
Today current date
→ :
→ Now :
current date & time
