Explanation

• Compiler Function: Converts high-level language into machine language.
• Output: Produces an object file (.obj / .exe) after compilation.
• Examples of Languages Using Compiler: C, C++, Java (uses compiler + JVM).

Additional information:

• Compiler: Translates whole program at once.
• Interpreter: Translates line by line.

Last verified on 21-02-2026

Explanation

• The dollar sign ($) is used to create an absolute cell reference in MS Excel.

Additional information:

• Absolute Reference: $D$2 (Row and column fixed)
• Relative Reference: D2 (Row and column change)
• Mixed Reference: $D2 (Column fixed)
• Mixed Reference: D$2 (Row fixed)
• Shortcut Key: F4 toggles between reference types.

Last verified on 18-07-2026

Explanation

• Malware means malicious software designed to damage, disrupt, steal information from, or gain unauthorized access to computer systems.
• Common types include viruses, worms, trojans, ransomware, spyware, and adware.

Additional information:

• Virus: Attaches itself to files and can spread when the infected file runs.
• Worm: Can spread automatically across networks without attaching to another file.
• Trojan: Pretends to be legitimate software but performs malicious actions.
• Ransomware: Encrypts or blocks access to data and demands payment.
• Spyware: Secretly collects information about a user or system.

Last verified on 09-08-2026

Explanation

• Cache Memory is the fastest memory.
• It is typically located inside or very close to the CPU.

Additional information:

• L1 Cache: Usually the fastest and smallest CPU cache.
• L2 Cache: Larger than L1 but generally slower.
• L3 Cache: Larger and usually shared among CPU cores.

Last verified on 09-08-2026

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

• 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

• A single page of a PowerPoint presentation is called a Slide.
• A slide is a single screen/page that contains text, images, charts, videos, or other presentation elements.
• A collection of slides forms a PowerPoint presentation.
• PowerPoint is a presentation software developed by Microsoft.
• Slides can be displayed using Slide Show mode.
• The default PowerPoint file extension is .pptx.

Last verified on 07-08-2026

Explanation

• A collection of related data is called a Database.
• A database stores and organizes related information so it can be easily accessed, managed, and updated.
• Examples include student records, employee information, and customer details.
• A DBMS (Database Management System) is software used to create and manage databases.

Last verified on 08-08-2026

Explanation

• The keyboard shortcut to select the entire document (or all items in a window) is Ctrl + A.
• Function: Selects all content, text, or files in the active window.

Additional information:

• Ctrl + R = used for aligning selected text to the right.
• Ctrl + E = used for aligning selected text to the center.
• Ctrl + J = use for Justify paragraph alignment.
• Ctrl + L = used for aligning selected text to the left.
• Ctrl + Q = used to Align the selected paragraph to the left.

Explanation

• The shortcut key to insert a new slide in a PowerPoint presentation is Ctrl + M.

Additional information:

• Ctrl + N shortcut key used to create a new presentation document.
• Ctrl + S shortcut key used to save a presentation.

Last verified on 29-05-2026