Which Excel formulas are essential for analyzing student data?
Managing student data? Here are must-know formulas:
- IF: =IF(B2>35, "Pass", "Fail")
- VLOOKUP: To fetch grades
- AVERAGE: =AVERAGE(C2:F2)
- COUNTIF: =COUNTIF(B2:B100, "Absent")
- ROUND: =ROUND(AVERAGE(B2:D2), 1)
Comments
Post a Comment