Explanation

• The IF function in MS Excel is used to perform conditional logic by testing whether a condition is TRUE or FALSE.
• It returns one value if the condition is true and another value if it is false.
• The IF function is one of the most commonly used logical functions in Excel.
• It helps automate calculations and decision-making.

Last verified on 08-07-2026

Explanation

• HLOOKUP searches for a value in the first horizontal row of a table and returns a value from a specified row in the same column.
• The "H" in HLOOKUP stands for Horizontal.
• It is used when data is arranged across rows instead of down columns.
• HLOOKUP is useful for looking up values in horizontally organized tables.

Additional information:

• VLOOKUP → Searches in a vertical (first) column

Last verified on 08-07-2026

Explanation

• COUNTA() counts only non-empty cells in a selected range.
• It counts cells containing numbers, text, logical values (TRUE/FALSE), errors, and formulas that return values.
• It does not count completely empty cells.
• COUNTA() is commonly used for counting filled entries in datasets.

Additional information:

• COUNT() → Counts only numeric cells
• COUNTBLANK() → Counts empty (blank) cells
• COUNTIF() → Counts cells matching a specific condition
• COUNTIFS() → Counts cells matching multiple conditions

Last verified 08-07-2026

Explanation

• Microsoft Excel is a spreadsheet program used to organize, calculate, and analyze data efficiently.
• It is widely used in offices, schools, and businesses for data management.

Additional information:

• Allows calculations using formulas and functions.
• Can create charts, graphs, and pivot tables for data analysis.
• Supports data sorting, filtering, and visualization.

Last verified on 17-01-2026

Explanation

List of Microsoft Excel Filename Extensions: