Explanation

• Excel 2007–2026 (Default): .xlsx

Additional information:

• Excel 97–2003 (Default): .xls
• Excel Macro-Enabled Workbook: .xlsm
• Excel Binary Workbook: .xlsb
• Excel Template: .xltx

Last verified on 12-07-2026

Explanation

• The IFERROR function returns a specified value if a formula evaluates to an error.
• If the formula works correctly, it returns the formula’s result.
• Syntax: =IFERROR(value, value_if_error)

Last verified on 09-10-2026

Explanation

• Function: COUNT
• Purpose: Counts cells containing numbers only
• Syntax: =COUNT(range)
• Example: =COUNT(A1:A10)
• Ignores: Text, blank cells, and logical values (TRUE/FALSE)

Additional information:

• COUNTA → Counts all non-empty cells.
• COUNTIF → Counts cells that meet a specific condition.
• COUNTIFS → Counts cells meeting multiple conditions.
• COUNTBLANK → Counts blank cells.

Last verified on 18-07-2026

Explanation

• Ctrl + H is used for Find and Replace function.
• It allows users to search text and replace it quickly.

Additional information:

• Ctrl + F → Find text
• Ctrl + C → Copy
• Ctrl + V → Paste
• Ctrl + X → Cut
• Ctrl + Z → Undo

Last verified on 19-04-2026

Explanation

• Cell borders in MS Excel are used to separate and define individual cells or ranges of cells.
• Borders make worksheets clearer, organized, and easier to read.
• Borders can be applied to the top, bottom, left, right, or all sides of a cell or selected range.

Last verified on 04-10-2026