HOW TO
FIND POSITION OF DATA [SCORES] IN EXCEL
Procedures and concepts to
consider:
I.FIND THE AVERAGE OF SCORES
=AVERAGE(13;25;14)
Example
Columns
[B, C and D]
and Row
[2]
…....... Horizontal calculation
OR
Column
[B]
and Rows
[2,3,4 and 5]
…........ Vertical calculation
Example
B2 to D2 (B2:D2)
II. FIND THE POSITION OF DATA
[By Ranking from highest to smallest]
OR
B7:D7
[In horizontal]
EXAMPLE
''E2''
means that, the "E"
will increment one letter for every cell that I move over to the
right and will decrement one letter for every cell that I move over
to the left. Then, the "2"
will increment by one for every cell that I move down and will
increment by one for every cell that I move down.
$E$2
This
is an absolute cell reference. Means that, If we copy a formula with
that cell reference, the cell reference will NOT
change AT ALL.
$E2
means
that, The "E"
will stay the same when we copy the cell, but the "2"
will change.
E$2
means that, The "E"
will change when we copy the cell, but the "2"
will stay the same.
Therefore;
NOTE:
In writing formula, use semi-colon [;]
if you use OpenOffice
otherwise use comma only [,]
if you use Microsoft
office
OTHER EXCEL FUNCTIONS [SYNTANX]
