Explanation

• GUI stands for Graphical User Interface.
• It is a type of user interface that allows users to interact with electronic devices using icons, windows, menus, and buttons instead of typing commands.
• The first GUI was developed at Xerox PARC in the early 1980s.

Additional information:

• CLI – Command Line Interface
• CUI – Character User Interface
• VUI – Voice User Interface
• NUI – Natural User Interface

Last verified on 03-07-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

• 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

• 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

• Page Up: Move the cursor or page up one screen.

Additional information:

• Ctrl + Home: Move to the top of a document.
  
• Ctrl + End: Move to the bottom of a document.
• Page Down: Move the cursor or page down one screen.

Last verified on 09-08-2026

Explanation

• A Drop Cap enlarges the first letter of a paragraph and makes it extend down several lines.

Additional information:

• The maximum number of lines that can be set for a Drop Cap in Microsoft Word is 10.
• The minimum number of lines is 1.
• The default setting is 3 lines.

Last verified on 07-08-2026

Explanation

• Data is permanently stored in the Hard Disk.
• A hard disk is a secondary storage device used to store data for long-term use.
• Data remains stored even when the computer is turned off.

Additional information:

• RAM → Temporary/volatile memory
• Cache → High-speed temporary memory
• Bus → Transfers data, addresses, and control signals

Last verified on 08-08-2026

Explanation

• Move the cursor to the top of the next page: Ctrl + Page Down

Additional information:

• Move the cursor to the top of the previous page: Ctrl + Page Up
• Move the cursor by scrolling the document view down by one screen: Page Down
• Move the cursor to the end of the document: Ctrl + End

Last verified on 07-08-2026

Explanation

• A computer application program that displays data arranged in rows and columns is called a Spreadsheet.
• Spreadsheets organize data in cells formed by the intersection of rows and columns.
• They are used for calculations, data analysis, charts, and record keeping.
• Examples include Microsoft Excel, Google Sheets, and LibreOffice Calc.
• A spreadsheet file usually contains multiple worksheets.

Last verified on 07-08-2026