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

Explanation

• Microsoft Excel provides features to automate data entry and save time.
• The Fill Handle is used to quickly fill a series like numbers, dates, or patterns by dragging.
• It appears as a small square at the bottom-right corner of a selected cell.

Last verified on 04-04-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

Explanation

• To split windows or document panes into two in applications like Excel or Word, use the View > Window > Split menu option.
• This command divides the active document window into separate

Explanation

• Pressing F2 allows you to edit the contents or formula of the current cell in MS Excel.

Additional information:

• F4: Repeat last action / toggle absolute and relative references
• CTRL + 1: Opens Format Cells dialog
• CTRL + F: Opens Find dialog
• Works in: Excel 2007, 2010, 2013, 2016, 2019, 365

Last verified on 12-03-2026