Excel Summary (Grade 10-12)

, 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