HOW TO
FIND GRADE OF DATA [SCORES] IN EXCEL
Procedures and concepts to consider:
I.FIND THE AVERAGE OF SCORES
- Have a data into cells [that are to be average calculated] Example [13 + 25 + 14] ÷ 3
=AVERAGE(13;25;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) ''
II. FIND THE GRADE OF SCORES
- Use the Cells [Columns and Rows] with Average data to find the Grade of given data
- Example use Cell E2 [In vertical] and Cell B7 [In horizontal]
- If A = 75-100, B = 65-74, C = 45-64, D = 30-44 and F = 0-29 then,
- '' . . . IF(E2>=30;”D”; “F”) '' will mean that, '' . . . If average in cell E2 is greater than or equal to 30 then will be D otherwise F ) ''
- Syntax: '' = IF(E2>=75;”A”;IF(E2>=65;”B”;IF(E2>=45;”C”;IF(E2>=30;”D”;”F”)))) ''
- Syntax: '' = IF(B7>=75;”A”;IF(B7>=65;”B”;IF(B7>=45;”C”;IF(B7>=30;”D”;”F”)))) ''
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