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

Explanation

• Ctrl + R runs the Fill Right command

Additional information

• Ctrl + D: Fill Down
• SUM(): Adds/total values in a range
• COUNT(): Counts cells containing numbers
• MOD(): Returns the remainder after division