Explanation

• An input device is any hardware component used to send data, signals, and commands to a computer. 
• Keyboard: Used to type text and enter commands.
• Mouse: Used to control the cursor and select items.
• Microphone: Used to record sound.
• Scanner: Used to convert physical documents into digital file
  

Last updated by NA on 09-09-2026

Explanation

• In MS PowerPoint, Templates are pre-designed slide formats.
• They control layout, colors, fonts, and overall design.
• Templates help maintain consistency in presentations.
• They save time in designing professional slides.

Last verified on 29-05-2026

Explanation

• Cache Memory — the buffer between CPU and RAM.

  • Stores frequently used data for quick CPU access
  • Faster but smaller than RAM
  • Falls between the CPU and main memory
  • Has levels (L1, L2, L3) — L1 is fastest/closest to CPU
  • Reduces memory access time, boosting performance

Additional information:

• RAM = the main memory itself
• ROM = read-only, holds firmware (BIOS)
• SRAM = a type used to build cache, not the buffer itself

Last updated 07-09-2026 by NA

Explanation

MAN (Metropolitan Area Network): City or district coverage

• LAN (Local Area Network): Small area, e.g., home, office
• WAN (Wide Area Network): Covers countries or continents, e.g., Internet
• PAN (Personal Area Network): Very small area, e.g., devices connected via Bluetooth

Explanation

Order of arguments:

• First argument: Range – the cells you want to count
• Second argument: Criteria – the condition that defines which cells to count
• Example:
• =COUNTIF(A1:A10, ">20") counts how many cells in range A1 to A10 have a value greater than 20.

Last verified on 05-09-2026

Explanation

• An algorithm is a step-by-step set of rules to solve a problem.
• It is used in programming and computer science.
• Algorithms must be clear, finite, and logical.
• Every computer program is based on an algorithm.
• It works like a recipe to reach a solution.

Last verified on 07-02-2026

Explanation

• The transfer of data from one place to another is called data communication.
• It involves sending data through a communication medium like cables or wireless signals.

Last verified on 05-09-2026

Explanation

• An Operating System (OS) is system software.
• It manages computer hardware and provides a platform for running application software.
• It acts as an interface between the user and computer hardware.

Functions of an Operating System:

• Allocates resources
• Monitors activities
• Manages disks and files

Last verified on 02-07-2026

Explanation

• DOCX is the newer version of DOC, the original official Microsoft Word file format. 
• Microsoft Word 97 - 2003 Document extension (.doc).
• Microsoft Word 2007 to till date Document extension (.docx).

Additional information:

• .xls extension of Excel.
• .ppt extension of PowerPoint.
• .txt extension of Text files.
• .pdf extension of Portable Document Format.

Last verified on 15-02-2026

Explanation

• SSDs use flash memory and have no moving mechanical parts.
• They provide faster data access and transfer speeds than HDDs.
• SSDs are generally more durable and resistant to physical shock.
• HDDs use spinning magnetic disks and mechanical read/write heads.

Last verified on 04-09-2026