Explanation

• A bit (binary digit) is the smallest unit of data in a computer.
• It can have a value of 0 or 1, representing two possible states.

Additional information:

• 1 Byte = 8 bits
• 1 Kilobyte (KB) = 1024 Bytes
• 1 Megabyte (MB) = 1024 KB
• 1 Gigabyte (GB) = 1024 MB
• 1 Terabyte (TB) = 1024 GB

Last verified on 12-03-2026

Explanation

• Function: COUNT
• Purpose: Counts cells containing numbers only
• Syntax: =COUNT(range)
• Example: =COUNT(A1:A10)
• Ignores: Text, blank cells, and logical values (TRUE/FALSE)

Additional information:

• COUNTA → Counts all non-empty cells.
• COUNTIF → Counts cells that meet a specific condition.
• COUNTIFS → Counts cells meeting multiple conditions.
• COUNTBLANK → Counts blank cells.

Last verified on 18-07-2026

Explanation

• Charles Babbage is known as the Father of the Computer.
• He designed the more advanced Analytical Engine, which featured a "Mill" (CPU) and a "Store" (memory).

Additional information:

• He was an English polymath.
• Born: 26 December 1791 London, England
• Died: 18 October 1871 (aged 79) London, England

Last updated on 09-03-2026

Explanation

• Bluetooth is a Personal Area Network (PAN) technology used for short-range communication.
• It connects devices within a range of about 10 meters.
• It is commonly used in headphones, mobile phones, and laptops.
• It works without cables using wireless signals.

Last verified on 24-06-2026

Explanation

Networks are typically classified into four main types based on distance (geographical coverage):

1. PAN (Personal Area Network) – Very short distance (e.g., Bluetooth, USB connections).
2. LAN (Local Area Network) – Limited area (e.g., home, office, or school network).
3. MAN (Metropolitan Area Network) – City-wide coverage (e.g., ISP networks in a city).
4. WAN (Wide Area Network) – Large-scale, global reach (e.g., the Internet).

Last verified on 08-06-2026

Explanation

• Ctrl + D → Open Font dialog box

Additional information:

• Ctrl + H → Open Replace dialog box
• Ctrl + F12 → Open an existing document in Microsoft Word (Open dialog box)
• F12 → Save As
• Shift + F12 → Save document

Last verified on 02-07-2026

Explanation

• WWW stands for World Wide Web.

Additional information:

• It is an information system.
• First published: 6 August 1991
• Founder: Tim Berners-Lee in 1989.
• Birthplace: CERN near Geneva, Switzerland.

Last verified on 01-07-2026

Explanation

• CPU stands for Central Processing Unit.
• It is the main part of a computer that processes all instructions.
• It is considered the brain of the computer system.
• It performs all calculations and decision-making tasks.
• It controls the operations of all hardware and software.
• It is located on the motherboard.

Last verified on 10-06-2026

Explanation

• Communication between a keyboard and computer is simplex.
• It means data flows in one direction only — from keyboard to computer.
• The computer does not send data back to the keyboard during typing.

Additional information:

There are 3 main data transmission modes:

1. Simplex: Data flows in one direction only (e.g., keyboard to computer).
2. Half-Duplex: Data can flow both ways, but not at the same time (e.g., walkie-talkies).
3. Full-Duplex: Data flows both ways simultaneously (e.g., telephone conversations).

Last verified on 17-06-2026

Explanation

• QR stands for Quick Response
• A QR code is a two-dimensional square barcode.
• It stores data like website links, text, or payment details

Last updated 07-09-2026 by NA