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

Explanation

• The Slide Show tab is used to display all slides during a PowerPoint presentation.
• It starts the presentation in full-screen mode.
• You can begin the slideshow from the first slide or the current slide.

• F5 starts the slideshow from the first slide.
• Shift + F5 starts the slideshow from the current slide.

Last verified on 09-08-2026

Explanation

• Animations tab is used to apply animation effects to objects in MS PowerPoint.
• It allows effects such as Entrance, Emphasis, Exit, and Motion Paths.
• The Animations tab also provides options to control the timing and order of effects.

Additional information:

• Insert tab is used to add objects such as pictures, tables, shapes, and charts.
• Design tab is mainly used for themes, colors, fonts, and slide background.

Last verified on 09-08-2026

Explanation

• LAN is ideal for connecting computers in closely located buildings, such as within a campus or office block.
• LAN stands for Local Area Network.
• It offers high speed and cost-effective connectivity over short distances.

Last verified on 19-04-2026