A. SUM()
B. MAX()
C. IF()
D. COUNT()
• IF() performs logical tests.
• Returns different results based on conditions.
• Example: =IF(A1>=50,”Pass”,”Fail”).
• Useful for grading systems.
• Helps automate decision-making.
• Commonly used in reports.
• Saves manual checking.
• Improves productivity.
• Important Excel formula.
• Frequently asked in exams.