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

Explanation

• In MS Excel Ctrl+9 shortcut key is used for hiding rows.

Additional information:

• Ctrl+0 (zero) to Hide Columns.
• Ctrl+Shift+( to Unhide Rows.
• Ctrl+Shift+) to Unhide Columns 
• Ctrl + N New Workbook
• Ctrl + O Open Workbook
• Ctrl + S Save Workbook
• Ctrl + P Print
• Ctrl + K Insert Hyperlink
• Ctrl + ; Insert Current Date
• Ctrl + Shift + ; Insert Current Time

Last updated NA on 10-09-2026