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

• In Microsoft Excel, the SUM function is used for addition.
• It adds numbers in a selected range of cells.
• Example: =SUM(A1:A5) adds values from A1 to A5.

Additional information:

• AVERAGE → calculates mean
• COUNT → counts numbers
• MAX → finds highest value
• MIN → finds lowest value
• PRODUCT → multiplies values

Last verified on 19-04-2026

Explanation

• Spreadsheet software is used for calculations and data organization.
• MS Excel is a widely used spreadsheet program.
• It works with rows, columns, and formulas.

Last verified on 11-04-2026

Explanation

• Microsoft Excel provides tools to organize and view data efficiently.
• Filter allows users to display only specific data based on criteria without deleting rows.
• It helps in analyzing large datasets easily.

Last verified on 04-04-2026

Explanation

• Microsoft Excel provides tools to control and manage user input.
• Data Validation is used to create drop-down lists based on cell values.
• It helps ensure accurate and consistent data entry.

Last verified on 04-04-2026