HOW TO
FIND AN AVERAGE OF DATA [SCORES] IN EXCEL
Procedures and concepts to consider:
- Have a data into cells [that are to be average calculated] Example [30 + 92 + 14] ÷ 3
=AVERAGE(30;92;14)
- Identify the column name and row name
Example
Columns
[B, C and D]
and Row
[2]
…....... Horizontal calculation
OR
Column
[B]
and Rows
[2,3,4 and 5]
…........ Vertical calculation
- Identify the range of data into cells [that are to be average calculated]
Example
B2 to D2 (B2:D2)
- Syntax: '' = AVERAGE(B2:D2) ''
- Syntax: '' = AVERAGE(B2:B5) ''
NOTE:
In writing formula, use semi-colon [;]
if you use OpenOffice
otherwise use comma only [,]
if you use Microsoft
office
OTHER EXCEL FUNCTIONS [SYNTANX]
No comments:
Post a Comment