Explanation

• MS Excel allows data to be sorted in both Ascending and Descending order.
• Ascending order: Smallest to largest, A to Z, or oldest to newest.
• Descending order: Largest to smallest, Z to A, or newest to oldest.
• Excel can sort numbers, text, dates, and other data types.
• The Sort command is available under the Data tab in Excel.

Last verified on 09-08-2026

Explanation

• A Workbook is a collection of related worksheets in spreadsheet software such as MS Excel.
• A workbook can contain multiple worksheets, each with rows and columns.
• A worksheet is an individual spreadsheet page within a workbook.
• For example, a workbook may contain separate worksheets for Sales, Expenses, and Profit.

Last verified on 09-08-2026

Explanation

• Cell Tips are comments or notes placed in an Excel cell to provide additional information.
• They help users understand or explain the data entered in a cell.
• In older versions of MS Excel, cell comments were displayed when the cell was selected or pointed to.

Last verified on 09-08-2026

Explanation

• Columns: Run vertically and are identified by letters (A, B, C … AA, AB).

Additional information:

• Rows: Run horizontally and are identified by numbers (1, 2, 3 …).
• Cells: Intersection of a row and column, e.g., A1.
• Fields: In database terminology, a column is often called a field.

Last verified on 09-08-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