Explanation

• Mail Merge is used to merge data into a template document to create multiple personalized copies.
• It is a feature of MS Word used for bulk document creation.
• It combines a main document with a data source (like names or addresses).
• Each output document is customized automatically.
• Commonly used for letters, labels, and certificates.

Last verified on 20-06-2026

Explanation

• Ctrl + Page Down in MS Word moves the cursor/view to the next page.
• It is used for quick navigation through pages in a document.
• Page Down alone moves the document view downward by approximately one screen.
• Ctrl + Down Arrow moves the cursor to the beginning of the next paragraph.
• Down Arrow moves the cursor one line down.

Last verified on 09-08-2026

Explanation

• Format Painter is used to copy formatting from one object or piece of text and apply the same formatting to another.
• It can copy properties such as font, font size, color, bold, italic, alignment, and other formatting.

Additional information:

• Copy: Copies content and/or formatting.
• Cut (Ctrl + X): Removes selected content and places it on the clipboard.
• Paste (Ctrl + V): Inserts copied or cut content.

Last verified on 09-08-2026

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

• The Title Bar is the bar at the top of a window that displays the name of the application and usually the current document.
• In MS Word, it may show the document name and Microsoft Word.

Additional information:

• The Taskbar is generally located at the bottom of the Windows desktop and shows open or pinned applications.
• The Status Bar displays information about the current document or application.
• The Scroll Bar is used to move up, down, left, or right through content.

Last verified on 09-08-2026

Explanation

• Text Wrapping automatically starts a new line when a word or sentence reaches the border/margin of the text area.
• It allows text to fit within the available space without manually pressing Enter.

Additional information:

• Word Wrap: Automatically breaks text at the end of a line.
• Wrap Text in Excel: Displays long cell content on multiple lines.

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

• To delete selected text in MS Word, press the Delete (Del) key.
• The selected/highlighted text is removed immediately.
• The Backspace key can also remove selected text.
• Ctrl + X cuts the selected text and places it on the clipboard.

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

• Color Scheme is used to change the colors of different objects without changing their content.
• It provides a coordinated set of colors for presentation elements.

Additional information:

• Design Template changes the overall design and appearance of slides.
• Object Color changes the color of a specific selected object.
• Font Color changes only the color of text.

Last verified on 09-08-2026