Computer Knowledge & Proficiency — AEE Exam Notes

COMPUTER KNOWLEDGE &

PROFICIENCY
One-Day Revision Study Notes

For Assistant Executive Engineer (AEE) Examinations

APTRANSCO • APGENCO • TGTRANSCO • TSGENCO • GATE General Aptitude • PSU
Recruitment Exams

Covers: Computer Basics • CPU • I/O & Storage Devices • Memory • Ports • Windows OS • Keyboard
Shortcuts
MS Word • MS Excel • PowerPoint • Internet • Email • E-Banking • Networking • Cyber Security

Page 1 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

How to Use These Notes

Each chapter follows a consistent exam-oriented structure: Core Concepts → Comparison
Tables → Important Exam Points → Quick Revision Points → Important Formulas/Conversions
(where applicable) → Memory Tricks → Frequently Asked MCQs with answers.
The final chapter, "One-Day Revision," consolidates the entire syllabus into one-liners, a master
fact sheet, frequently confused term comparisons, and an additional MCQ practice set for last-
minute revision.

Page 2 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Table of Contents
TOC \h \o "1-2"

Page 3 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 1: Computer Fundamentals

1.1 Definition of Computer
A computer is an electronic device that accepts data (input), processes it as per given
instructions, and produces meaningful information (output). It works on the principle of GIGO —
Garbage In, Garbage Out.

1.2 Characteristics of a Computer

• Speed: Performs calculations in micro/nano/pico seconds.
• Accuracy: Gives error-free results if correct data and instructions are given.
• Diligence: Can perform repetitive tasks without fatigue or boredom.
• Versatility: Can perform multiple types of tasks (calculation, drawing, typing, etc.).
• Storage Capacity: Can store huge volumes of data permanently.
• No IQ / No Feelings: Computer has no intelligence of its own; it works only on
instructions (programs).

1.3 Basic Block Diagram of a Computer

Input Unit → CPU (Control Unit + ALU + Registers) ↔ Memory Unit → Output Unit. All units are
interconnected by a system bus (data bus, address bus, control bus).

1.4 Functional Units

Unit Function Examples
Input Unit Takes data/instructions from user and Keyboard, Mouse,
converts to machine-readable form Scanner
CPU (Central Processing Processes data; "Brain of the computer" ALU, CU, Registers
Unit)
Output Unit Converts processed data into human- Monitor, Printer
readable form
Memory Unit Stores data, instructions and results RAM, ROM, Cache

1.5 IPO Cycle

Input → Process → Output (sometimes extended as IPOS Cycle: Input → Process → Output →
Storage). This is the fundamental cycle of data processing in any computer system.

1.6 Types of Computers — Basic Classification

(a) By Size
Type Key Point
Supercomputer Fastest, used for weather forecasting, nuclear
research (e.g., PARAM, Fugaku)

Page 4 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Type Key Point

Mainframe Computer Large, used by big organizations (banks, railways)
for bulk data processing
Mini Computer Mid-sized, used by small/medium businesses
Micro Computer (PC) Smallest, single-user, e.g., Desktop, Laptop

(b) By Working Principle / Data Handling

Type Description
Analog Computer Processes continuous data (e.g., speedometer, thermometer)
Digital Computer Processes data in binary form (0 and 1) — most common
today
Hybrid Computer Combination of analog + digital (e.g., ECG, petrol pump
dispensers)

1.7 Hardware vs Software

Hardware Software
Physical, tangible parts of a computer Set of instructions/programs (intangible)
Can be seen and touched Cannot be touched, only executed
Examples: CPU, Monitor, Keyboard Examples: Windows, MS Office, Antivirus
Does not get "infected" by virus directly Can get infected by viruses
Once manufactured, function is fixed Can be updated/upgraded easily

Exam Important Points

Father of Computer: Charles Babbage (Analytical Engine).
Computer generations are based on the technology used: I-Vacuum tubes, II-Transistors, III-
IC, IV-Microprocessor (VLSI), V-AI (ULSI).
A Personal Computer (PC) is a Microcomputer.
Binary number system (0,1) is the language of computers.

Quick Revision Points

• Computer works on the IPO cycle: Input → Process → Output.
• CPU is called the "Brain" of the computer.
• Hardware = physical parts; Software = set of instructions.
• 4 generations are based on technology: Vacuum Tube → Transistor → IC →
Microprocessor → AI.
Memory Tricks
• "SAVD" for Characteristics — Speed, Accuracy, Versatility, Diligence.

Page 5 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

• Remember Functional Units as "I-C-O-M" (Input, CPU, Output, Memory).

Frequently Asked MCQs
1. Who is known as the Father of the Computer?
(a) Alan Turing
(b) Charles Babbage
(c) Bill Gates
(d) John von Neumann
Answer: (b) Charles Babbage
2. The full form of CPU is:
(a) Central Processing Unit
(b) Computer Personal Unit
(c) Central Program Unit
(d) Central Processor Utility
Answer: (a) Central Processing Unit
3. Which unit is called the "Brain of the Computer"?
(a) Input Unit
(b) Output Unit
(c) CPU
(d) Memory Unit
Answer: (c) CPU
4. GIGO stands for:
(a) Garbage In Garbage Out
(b) Get In Get Out
(c) General Input General Output
(d) Good Input Good Output
Answer: (a) Garbage In Garbage Out
5. A computer that processes continuous data is called:
(a) Digital Computer
(b) Analog Computer
(c) Hybrid Computer
(d) Mainframe Computer
Answer: (b) Analog Computer
6. Which of the following is an example of hardware?
(a) MS Word
(b) Windows OS
(c) Keyboard
(d) Antivirus
Answer: (c) Keyboard
7. ECG machine is an example of which type of computer?
(a) Analog
(b) Digital
(c) Hybrid
(d) Mainframe
Answer: (c) Hybrid

Page 6 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

8. The smallest category of computer is:

(a) Supercomputer
(b) Mainframe
(c) Minicomputer
(d) Microcomputer
Answer: (d) Microcomputer
9. PARAM is an example of:
(a) Microcomputer
(b) Supercomputer
(c) Minicomputer
(d) Hybrid Computer
Answer: (b) Supercomputer
10. Which characteristic refers to a computer working without fatigue?
(a) Accuracy
(b) Diligence
(c) Versatility
(d) Speed
Answer: (b) Diligence
11. Software is best described as:
(a) A physical device
(b) A set of instructions
(c) An input device
(d) A storage device
Answer: (b) A set of instructions
12. Computer speed is generally measured in:
(a) Meters per second
(b) Micro/Nano seconds
(c) Kilograms
(d) Decibels
Answer: (b) Micro/Nano seconds

Page 7 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 2: Central Processing Unit (CPU)

2.1 CPU Components
Component Function
ALU (Arithmetic Logic Unit) Performs arithmetic (+, −, ×, ÷) and logical (AND, OR, NOT,
comparison) operations
Control Unit (CU) Directs and coordinates all activities of the computer; does
not process data itself
Registers Small, high-speed storage locations inside CPU used to hold
data temporarily during processing

Important Registers
• Accumulator (AC): Stores results of ALU operations.
• Program Counter (PC): Holds address of next instruction to be executed.
• Instruction Register (IR): Holds the instruction currently being executed.
• Memory Address Register (MAR): Holds address of memory location to be accessed.
• Memory Buffer/Data Register (MBR/MDR): Holds data being transferred to/from
memory.

2.2 Machine Cycle (Instruction Cycle)

Fetch → Decode → Execute → Store (FDES). The CPU fetches an instruction from memory,
decodes it, executes it, and stores the result.

2.3 Clock Speed

Clock speed determines how many instructions a CPU can execute per second. It is measured
in Hertz (Hz) — commonly in GHz (Gigahertz) for modern processors. Higher clock speed
generally means faster processing.

2.4 Cache Memory

A small, very fast memory located between CPU and RAM that stores frequently used
data/instructions to speed up processing. It is costlier and faster than RAM but smaller in size.
Level Location Speed
L1 Cache Inside the processor core Fastest, smallest
L2 Cache Near the processor Medium
L3 Cache Shared across cores Slower than L1/L2, larger

2.5 Multi-core Processors (Basic)

• Dual Core: 2 independent processing units on a single chip.

Page 8 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

• Quad Core: 4 processing units — allows multitasking and faster performance.

• Octa Core: 8 processing units, common in modern smartphones.

Important CPU Facts for Competitive Exams

CPU is fabricated on a single chip called a Microprocessor.
Speed of supercomputers is measured in FLOPS (Floating Point Operations Per Second).
Speed of PCs is measured in MIPS (Million Instructions Per Second).
Control Unit does NOT perform actual data processing — only directs operations.
Intel and AMD are leading CPU manufacturers.

Quick Revision Points

• CPU = ALU + CU + Registers.
• Machine Cycle = Fetch → Decode → Execute → Store.
• Clock speed measured in GHz.
• Cache memory is faster than RAM, placed between CPU and RAM.
Important Formulas / Conversions
• 1 GHz = 1,000 MHz = 1,000,000,000 Hz (cycles per second).
Memory Tricks
• "FDES" = Fetch, Decode, Execute, Store.
• ALU does Math + Logic; CU "Controls/Directs" — does not calculate.
Frequently Asked MCQs
1. Which CPU component performs arithmetic and logical operations?
(a) Control Unit
(b) ALU
(c) Register
(d) Cache
Answer: (b) ALU
2. The Control Unit is responsible for:
(a) Performing calculations
(b) Storing data permanently
(c) Directing and coordinating operations
(d) Displaying output
Answer: (c) Directing and coordinating operations
3. The correct order of the Machine Cycle is:
(a) Decode-Fetch-Execute-Store
(b) Fetch-Decode-Execute-Store
(c) Execute-Fetch-Decode-Store
(d) Fetch-Execute-Decode-Store
Answer: (b) Fetch-Decode-Execute-Store
4. Clock speed of a processor is measured in:
(a) MB
(b) GHz
(c) GB

Page 9 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(d) Mbps
Answer: (b) GHz
5. Which register holds the address of the next instruction?
(a) Accumulator
(b) Program Counter
(c) MAR
(d) IR
Answer: (b) Program Counter
6. Which cache level is fastest and smallest?
(a) L3
(b) L2
(c) L1
(d) L4
Answer: (c) L1
7. A Quad Core processor has how many processing cores?
(a) 2
(b) 4
(c) 6
(d) 8
Answer: (b) 4
8. Speed of a supercomputer is measured in:
(a) MIPS
(b) FLOPS
(c) GHz only
(d) Bytes
Answer: (b) FLOPS
9. Cache memory is located between:
(a) CPU and Hard Disk
(b) CPU and RAM
(c) RAM and ROM
(d) Input and Output devices
Answer: (b) CPU and RAM
10. CPU is also referred to as a:
(a) Motherboard
(b) Microprocessor
(c) Peripheral
(d) Bus
Answer: (b) Microprocessor
11. Which register holds the instruction currently being executed?
(a) MAR
(b) MBR
(c) Instruction Register
(d) Program Counter
Answer: (c) Instruction Register

Page 10 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

12. Two leading CPU manufacturing companies are:

(a) HP and Dell
(b) Intel and AMD
(c) Apple and Sony
(d) IBM and Wipro
Answer: (b) Intel and AMD

Page 11 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 3: Input & Output Devices

3.1 Input Devices
Device Use / Key Point
Keyboard Most common input device; QWERTY layout standard
Mouse Pointing device; types: Mechanical, Optical, Wireless
Scanner Converts physical documents/images into digital form
Barcode Reader Reads barcodes (parallel lines) — used in retail billing
OCR (Optical Character Converts printed/handwritten text into editable digital text
Recognition)
OMR (Optical Mark Detects marked answers — used in exams (answer sheets)
Recognition)
MICR (Magnetic Ink Character Reads magnetic ink characters — used in banking (cheques)
Recognition)
Joystick Used mainly for gaming / controlling movement
Touch Screen Allows direct interaction by touching the display
Webcam Captures live video, used for video calls

3.2 Output Devices

Device Use / Key Point
Monitor (VDU) Visual Display Unit; types — CRT, LCD, LED, OLED
Printer Produces hard copy; types — Inkjet, Laser, Dot Matrix
Plotter Produces high-quality large drawings/graphics (maps,
blueprints)
Speaker Produces audio/sound output

3.3 Comparison: Impact vs Non-Impact Printers

Impact Printers Non-Impact Printers
Print head strikes the ribbon/paper No physical contact with paper
(mechanical contact)
Noisy, slower Quiet, faster
Example: Dot Matrix Printer Example: Inkjet, Laser Printer
Low print quality, low cost High print quality, costlier

Page 12 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

3.4 MICR vs OCR vs OMR (Frequently Confused — Banking-related)

Term Used For
MICR Bank cheques — reads special magnetic ink numbers at bottom of
cheque
OCR Reading printed text and converting to editable digital text
OMR Reading shaded/marked bubbles, e.g., exam OMR sheets

Exam Important Points

Mouse is also called a "Pointing Device."
Laser Printer gives the best print quality among common printers.
CRT monitors are bulky (old technology); LED is most energy-efficient (current technology).
Plotters are used for engineering drawings/maps — relevant for AEE (Engineering) exams.

Quick Revision Points

• Input devices: Keyboard, Mouse, Scanner, OCR, OMR, MICR, Barcode Reader,
Joystick, Touchscreen, Webcam.
• Output devices: Monitor, Printer, Plotter, Speaker.
• MICR → Banking; OMR → Exams; OCR → Text conversion.
Memory Tricks
• "MOB" — MICR=Money/Bank, OMR=Objective papers, OCR=Characters/text.
Frequently Asked MCQs
1. MICR technology is mainly used in:
(a) Examination answer sheets
(b) Bank cheques
(c) Barcode billing
(d) Printing photographs
Answer: (b) Bank cheques
2. OMR is commonly used for:
(a) Reading bank cheques
(b) Evaluating exam answer sheets
(c) Scanning barcodes
(d) Editing images
Answer: (b) Evaluating exam answer sheets
3. Which device converts printed text into editable digital text?
(a) OMR
(b) MICR
(c) OCR
(d) Scanner only
Answer: (c) OCR
4. A Plotter is mainly used for:
(a) Printing text documents

Page 13 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(b) Large engineering drawings/maps

(c) Reading barcodes
(d) Audio output
Answer: (b) Large engineering drawings/maps
5. Which is an example of a Non-Impact printer?
(a) Dot Matrix Printer
(b) Laser Printer
(c) Daisy Wheel Printer
(d) Line Printer
Answer: (b) Laser Printer
6. A Joystick is primarily used for:
(a) Typing text
(b) Gaming/movement control
(c) Scanning documents
(d) Printing
Answer: (b) Gaming/movement control
7. VDU stands for:
(a) Visual Display Unit
(b) Video Display Utility
(c) Virtual Display Unit
(d) Visual Data Unit
Answer: (a) Visual Display Unit
8. Which monitor technology is most energy efficient?
(a) CRT
(b) LCD
(c) LED
(d) Plasma
Answer: (c) LED
9. Barcode readers are most commonly used in:
(a) Hospitals only
(b) Retail billing
(c) Banking cheques
(d) Exam evaluation
Answer: (b) Retail billing
10. Webcam is used to capture:
(a) Printed documents
(b) Live video
(c) Sound only
(d) Barcode data
Answer: (b) Live video
11. Which is both used for input in modern devices and as an output display?
(a) Mouse
(b) Touch Screen
(c) Keyboard
(d) Scanner

Page 14 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Answer: (b) Touch Screen

12. Best print quality among common printers is given by:
(a) Dot Matrix
(b) Inkjet
(c) Laser
(d) Daisy Wheel
Answer: (c) Laser

Page 15 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 4: Computer Memory

4.1 Primary Memory
RAM ROM
Random Access Memory — Volatile (data Read Only Memory — Non-volatile (data
lost when power off) retained when power off)
Read & Write memory Mostly Read-only; some types are
programmable
Used as main working memory of computer Stores BIOS/firmware (boot instructions)
Types: SRAM, DRAM Types: PROM, EPROM, EEPROM

4.2 Secondary Memory

Non-volatile, permanent storage used to store data even after the computer is switched off.
Examples: Hard Disk, SSD, Pen Drive, CD/DVD. Slower than primary memory but much larger
in capacity and cheaper per GB.

4.3 Cache Memory

Very high-speed memory placed between CPU and RAM, stores frequently accessed
instructions/data to reduce CPU wait time. (Detailed in Chapter 2.)

4.4 Virtual Memory

A memory management technique where a portion of the hard disk is used as if it were RAM,
when RAM is full. It allows running larger programs than the actual physical RAM size, but is
slower than RAM.

4.5 Memory Hierarchy (Fastest to Slowest)

Registers → Cache Memory → Primary Memory (RAM) → Secondary Memory (Hard Disk/SSD)
→ Magnetic Tape/Backup.

Key Rule
As we go down the hierarchy: Speed decreases, Capacity increases, Cost per byte
decreases.

4.6 Units of Memory

Unit Equivalent
Bit Smallest unit (0 or 1)
Nibble 4 bits
Byte 8 bits
Kilobyte (KB) 1024 Bytes

Page 16 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Unit Equivalent
Megabyte (MB) 1024 KB
Gigabyte (GB) 1024 MB
Terabyte (TB) 1024 GB
Petabyte (PB) 1024 TB

Important Formulas / Conversions

• 1 Byte = 8 Bits
• 1 KB = 1024 Bytes = 2^10 Bytes
• 1 MB = 1024 KB = 2^20 Bytes
• 1 GB = 1024 MB = 2^30 Bytes
• 1 TB = 1024 GB = 2^40 Bytes
Quick Revision Points
• RAM is volatile; ROM is non-volatile.
• Virtual memory uses hard disk space as extended RAM.
• Memory Hierarchy (fastest→slowest): Register > Cache > RAM > Secondary Storage.
• Conversion is always based on 1024 (2^10), not 1000.
Memory Tricks
• "RAM is temporary, ROM is Read-Only forever" — RAM=Remember And Move(temp),
ROM=Read Only Memory(permanent).
• Memory units mnemonic: "Bad Boys Kill Mosquitoes, Girls Throw Plates" → Bit, Byte,
KB, MB, GB, TB, PB.
Frequently Asked MCQs
1. 1 Byte equals how many bits?
(a) 4
(b) 8
(c) 16
(d) 1024
Answer: (b) 8
2. Which memory is volatile?
(a) ROM
(b) RAM
(c) Hard Disk
(d) Pen Drive
Answer: (b) RAM
3. 1 KB equals:
(a) 1000 Bytes
(b) 1024 Bytes
(c) 100 Bytes
(d) 1024 Bits

Page 17 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Answer: (b) 1024 Bytes

4. BIOS is stored in:
(a) RAM
(b) ROM
(c) Cache
(d) Hard Disk
Answer: (b) ROM
5. Virtual memory uses which device as extended RAM?
(a) Cache
(b) Hard Disk
(c) ROM
(d) Register
Answer: (b) Hard Disk
6. The fastest memory in the hierarchy is:
(a) RAM
(b) Cache
(c) Registers
(d) Hard Disk
Answer: (c) Registers
7. 1 GB equals:
(a) 1024 KB
(b) 1024 MB
(c) 1000 MB
(d) 1024 TB
Answer: (b) 1024 MB
8. Which is non-volatile memory?
(a) RAM
(b) Cache
(c) ROM
(d) Register
Answer: (c) ROM
9. EEPROM stands for:
(a) Electrically Erasable Programmable ROM
(b) Easily Erasable Permanent ROM
(c) External Erasable PROM
(d) Electronic Erasable Process ROM
Answer: (a) Electrically Erasable Programmable ROM
10. As we move down the memory hierarchy:
(a) Speed increases, capacity decreases
(b) Speed decreases, capacity increases
(c) Both increase
(d) Both decrease
Answer: (b) Speed decreases, capacity increases
11. 1 Terabyte equals:

Page 18 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(a) 1024 GB
(b) 1000 GB
(c) 1024 MB
(d) 1024 KB
Answer: (a) 1024 GB
12. Which is an example of primary memory?
(a) Hard Disk
(b) RAM
(c) Pen Drive
(d) CD
Answer: (b) RAM

Page 19 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 5: Storage Devices

Device Key Point

Hard Disk Drive (HDD) Magnetic storage; large capacity; slower than SSD; moving
parts
SSD (Solid State Drive) Flash-memory based; no moving parts; much faster than HDD;
costlier per GB
Pen Drive (USB Flash Portable, plug-and-play; uses USB port
Drive)
CD (Compact Disc) Optical storage; capacity ~700 MB
DVD (Digital Versatile Disc) Optical storage; capacity 4.7 GB (single layer) / 8.5 GB (dual
layer)
Blu-ray Disc Optical storage; uses blue laser; capacity 25 GB (single layer) /
50 GB (dual layer)
Magnetic Tape Sequential access; used for backup of huge data (cheapest
per GB)
Cloud Storage Data stored on remote servers, accessed via Internet (e.g.,
Google Drive, OneDrive, Dropbox)

5.1 HDD vs SSD

HDD SSD
Magnetic platters, moving parts Flash memory chips, no moving parts
Slower read/write speed Much faster read/write speed
Cheaper per GB Costlier per GB
Noisy, generates more heat Silent, energy efficient

5.2 Backup Devices

Used to create copies of data to protect against loss. Common backup media: External Hard
Disk, Pen Drive, Magnetic Tape, Cloud Storage.

5.3 Cloud Storage — Basics

• Definition: Storing data on remote servers accessed via the Internet instead of a local
device.
• Advantages: Accessible from anywhere, automatic backup, easy sharing.
• Examples: Google Drive, Microsoft OneDrive, Dropbox, iCloud.

Exam Important Points

Page 20 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Optical storage devices (CD/DVD/Blu-ray) use LASER technology to read/write data.

Order of capacity (low to high): CD < DVD < Blu-ray.
SSD has NO moving mechanical parts — main reason for its speed and durability.
Magnetic tape provides sequential access; HDD/SSD provide random/direct access.

Quick Revision Points

• HDD = magnetic, moving parts, cheaper; SSD = flash, no moving parts, faster.
• CD ≈ 700 MB; DVD ≈ 4.7 GB; Blu-ray ≈ 25 GB.
• Cloud storage = remote server storage accessed via internet.
Memory Tricks
• "CD-DVD-BD" capacity order: 700MB → 4.7GB → 25GB (each jump roughly 6-7x
bigger).
Frequently Asked MCQs
1. Which storage device has no moving mechanical parts?
(a) HDD
(b) SSD
(c) Magnetic Tape
(d) Floppy Disk
Answer: (b) SSD
2. Approximate storage capacity of a standard DVD is:
(a) 700 MB
(b) 4.7 GB
(c) 25 GB
(d) 1 TB
Answer: (b) 4.7 GB
3. Blu-ray discs use which laser color?
(a) Red
(b) Green
(c) Blue
(d) Yellow
Answer: (c) Blue
4. Which is the cheapest storage medium per GB for very large backups?
(a) SSD
(b) Pen Drive
(c) Magnetic Tape
(d) Blu-ray
Answer: (c) Magnetic Tape
5. Cloud Storage data is stored on:
(a) Local hard disk only
(b) Remote servers accessed via internet
(c) Pen drive
(d) CD/DVD
Answer: (b) Remote servers accessed via internet

Page 21 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

6. Which is an example of optical storage?

(a) SSD
(b) HDD
(c) DVD
(d) Pen Drive
Answer: (c) DVD
7. SSD stands for:
(a) Secondary Storage Drive
(b) Solid State Drive
(c) Static Storage Device
(d) Serial Storage Disk
Answer: (b) Solid State Drive
8. Compared to HDD, SSD is generally:
(a) Slower and cheaper
(b) Faster and costlier
(c) Slower and costlier
(d) Same speed, cheaper
Answer: (b) Faster and costlier
9. Which storage type provides sequential access only?
(a) HDD
(b) SSD
(c) Magnetic Tape
(d) Pen Drive
Answer: (c) Magnetic Tape
10. Google Drive and OneDrive are examples of:
(a) Optical storage
(b) Cloud storage
(c) Magnetic storage
(d) Cache memory
Answer: (b) Cloud storage
11. Pen Drive connects to a computer via:
(a) VGA port
(b) USB port
(c) HDMI port
(d) PS/2 port
Answer: (b) USB port
12. A single-layer Blu-ray disc capacity is approximately:
(a) 4.7 GB
(b) 8.5 GB
(c) 25 GB
(d) 50 GB
Answer: (c) 25 GB

Page 22 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 6: Ports & Connectors

Port Full Form / Use

USB Universal Serial Bus — connects pen drives, mouse, keyboard,
printers (most common port)
HDMI High Definition Multimedia Interface — transmits both audio +
video digitally
VGA Video Graphics Array — transmits analog video only, no audio
Ethernet Port (RJ-45) Used for wired LAN/Internet connection
Audio Port Connects speakers, microphones, headphones (3.5mm jack)
PS/2 Round connector — older port for keyboard (purple) and
mouse (green)
Serial Port Transmits data 1 bit at a time; used for old mice/modems
(COM port)
Parallel Port Transmits multiple bits simultaneously; used for old printers
(LPT port)

6.1 HDMI vs VGA (Frequently Compared)

HDMI VGA
Digital signal Analog signal
Carries audio + video Carries video only
Better picture quality Lower picture quality
Modern standard Older/legacy standard

6.2 Serial vs Parallel Port

Serial Port Parallel Port
Sends data 1 bit at a time Sends multiple bits simultaneously
Slower over long distance but more reliable Faster over short distance
Used for mouse, modem (old) Used for printers (old, LPT)

Exam Important Points

USB is the most frequently used port today — supports plug-and-play.
USB versions: USB 2.0 (slower) vs USB 3.0 (faster, usually blue colored port).
PS/2 ports: Purple = Keyboard, Green = Mouse (standard color coding).

Page 23 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Ethernet/RJ-45 port is used for wired internet/LAN connections.

Quick Revision Points

• USB = universal, most common connector today.
• HDMI = digital, audio+video; VGA = analog, video only.
• PS/2: Purple-Keyboard, Green-Mouse.
• Serial = 1 bit at a time; Parallel = multiple bits at a time.
Memory Tricks
• "HAVE" — HDMI = Audio + Video, both Enabled (digital). VGA = Video only (analog).
Frequently Asked MCQs
1. USB stands for:
(a) Universal Serial Bus
(b) United Serial Bus
(c) Universal System Bus
(d) Unique Serial Bus
Answer: (a) Universal Serial Bus
2. Which port transmits both audio and video digitally?
(a) VGA
(b) HDMI
(c) Serial Port
(d) PS/2
Answer: (b) HDMI
3. VGA stands for:
(a) Video Graphics Array
(b) Visual Graphic Adapter
(c) Video Generation Array
(d) Visual Gate Array
Answer: (a) Video Graphics Array
4. Ethernet port is also known as:
(a) USB Port
(b) RJ-45
(c) PS/2
(d) VGA
Answer: (b) RJ-45
5. In PS/2 ports, the purple connector is for:
(a) Mouse
(b) Keyboard
(c) Speaker
(d) Monitor
Answer: (b) Keyboard
6. Which port sends data one bit at a time?
(a) Parallel Port

Page 24 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(b) Serial Port

(c) USB 3.0
(d) HDMI
Answer: (b) Serial Port
7. Parallel port (LPT) was traditionally used for:
(a) Mouse
(b) Printers
(c) Monitor
(d) Speakers
Answer: (b) Printers
8. A standard audio jack size is:
(a) 2.5mm
(b) 3.5mm
(c) 5mm
(d) 1mm
Answer: (b) 3.5mm
9. Which port/cable does NOT carry audio signal?
(a) HDMI
(b) VGA
(c) USB-C (with audio support)
(d) Bluetooth
Answer: (b) VGA
10. USB 3.0 ports are commonly identified by which color?
(a) Black
(b) Red
(c) Blue
(d) Green
Answer: (c) Blue

Page 25 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 7: Windows Operating System

7.1 Important Features
Feature Description
Desktop Main screen with icons and background after Windows starts
Taskbar Horizontal bar (usually bottom) showing Start button, open
apps, system tray, clock
Control Panel Used to change system settings (display, hardware, user
accounts, network)
Recycle Bin Temporary storage for deleted files; files can be restored from
here
File Explorer (Windows Used to browse, manage files and folders on the computer
Explorer)

7.2 Folder/File Operations

• Copy: Creates a duplicate of a file/folder at a new location (original remains).
• Move: Shifts the file/folder to a new location (removed from original location).
• Rename: Changes the name of a file/folder.
• Delete: Sends file/folder to Recycle Bin (Shift+Delete deletes permanently).
• Search: Used to locate files/folders/apps quickly using keywords.

Exam Important Points

Recycle Bin items still occupy disk space until "Emptied."
Shift + Delete bypasses Recycle Bin — permanent deletion.
Windows is a GUI-based (Graphical User Interface) Operating System.
File Explorer was earlier called "Windows Explorer."

7.3 Important Windows Keyboard Shortcuts

Shortcut Function
Win Open/Close Start Menu
Win + E Open File Explorer
Win + D Show/Hide Desktop
Win + L Lock the computer
Win + R Open Run dialog box
Win + I Open Settings
Win + Tab Open Task View

Page 26 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Shortcut Function
Alt + Tab Switch between open windows
Alt + F4 Close active window/application
Ctrl + Esc Open Start Menu
F2 Rename selected file/folder
F5 Refresh screen
Ctrl + A Select all
Ctrl + C / Ctrl + V Copy / Paste
Ctrl + X Cut
Ctrl + Z / Ctrl + Y Undo / Redo
Shift + Delete Permanent delete (skip Recycle Bin)
Print Screen (PrtScn) Capture screenshot

Quick Revision Points

• Control Panel is used to change system settings.
• Recycle Bin stores deleted files temporarily.
• Shift+Delete = permanent delete; normal Delete = goes to Recycle Bin.
• Win+E = File Explorer; Win+L = Lock; Win+D = Show Desktop.
Memory Tricks
• "Win+E for Explorer, Win+L for Lock, Win+D for Desktop" — letter matches the action
word.
Frequently Asked MCQs
1. Which key combination opens File Explorer?
(a) Win + E
(b) Win + L
(c) Win + D
(d) Win + R
Answer: (a) Win + E
2. Permanently deleting a file (skipping Recycle Bin) is done using:
(a) Delete
(b) Ctrl + Delete
(c) Shift + Delete
(d) Alt + Delete
Answer: (c) Shift + Delete
3. Which shortcut locks the computer?
(a) Win + D
(b) Win + L
(c) Win + R

Page 27 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(d) Win + E
Answer: (b) Win + L
4. Control Panel is used to:
(a) Browse files
(b) Change system settings
(c) Delete temporary files
(d) Open applications only
Answer: (b) Change system settings
5. F2 key is used to:
(a) Refresh the screen
(b) Rename a file
(c) Delete a file
(d) Open Run
Answer: (b) Rename a file
6. Alt + Tab is used to:
(a) Close a window
(b) Switch between open windows
(c) Open Start Menu
(d) Lock the system
Answer: (b) Switch between open windows
7. Which key opens the Run dialog box?
(a) Win + R
(b) Win + E
(c) Win + I
(d) Win + D
Answer: (a) Win + R
8. Recycle Bin is used for:
(a) Permanently deleted files
(b) Temporarily deleted files (recoverable)
(c) System settings
(d) Installed programs
Answer: (b) Temporarily deleted files (recoverable)
9. Alt + F4 is used to:
(a) Open Settings
(b) Close the active window
(c) Take a screenshot
(d) Rename a file
Answer: (b) Close the active window
10. Windows operating system is based on:
(a) Command Line Interface
(b) Graphical User Interface
(c) Voice Interface
(d) Batch Interface
Answer: (b) Graphical User Interface

Page 28 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

11. F5 key is generally used to:

(a) Rename
(b) Refresh
(c) Save
(d) Print
Answer: (b) Refresh
12. Win + D is used to:
(a) Open Run
(b) Show/Hide Desktop
(c) Lock PC
(d) Open Settings
Answer: (b) Show/Hide Desktop

Page 29 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 8: Keyboard Shortcuts (Master Table)

The following table consolidates the most frequently asked shortcut keys across Windows, MS
Word, MS Excel and PowerPoint for quick one-day revision.

8.1 Common / Universal Shortcuts

Shortcut Function
Ctrl + N New file/document
Ctrl + O Open file
Ctrl + S Save
Ctrl + P Print
Ctrl + Z Undo
Ctrl + Y Redo
Ctrl + X Cut
Ctrl + C Copy
Ctrl + V Paste
Ctrl + A Select All
Ctrl + F Find
Ctrl + H Replace
Ctrl + W Close window/document

8.2 MS Word Shortcuts

Shortcut Function
Ctrl + B Bold
Ctrl + I Italic
Ctrl + U Underline
Ctrl + E Center align
Ctrl + L Left align
Ctrl + R Right align
Ctrl + J Justify
Ctrl + D Open Font dialog box
Ctrl + K Insert hyperlink
Ctrl + Enter Insert page break

Page 30 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Shortcut Function
Ctrl + Shift + N Apply Normal style
Ctrl + 1 / 2 / 5 Single / Double / 1.5 line spacing
Shift + F3 Change case of selected text
F7 Spell check
Ctrl + End / Home Move to end / start of document

8.3 MS Excel Shortcuts

Shortcut Function
Ctrl + Arrow Key Jump to edge of data region
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + + (Plus) Insert cell/row/column
Ctrl + − (Minus) Delete cell/row/column
F2 Edit active cell
F4 Repeat last action / toggle absolute reference ($)
Ctrl + 1 Format Cells dialog box
Alt + = AutoSum
Ctrl + ; Insert current date
Ctrl + Shift + ; Insert current time
Ctrl + Page Up/Down Move between worksheets
Ctrl + Shift + L Apply/remove Filter
Ctrl + D Fill down
Ctrl + R Fill right

8.4 PowerPoint Shortcuts

Shortcut Function
F5 Start slide show from beginning
Shift + F5 Start slide show from current slide
Ctrl + M Insert new slide
Ctrl + D Duplicate selected slide
Esc End slide show

Page 31 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Shortcut Function
Ctrl + Shift + C / V Copy / Paste formatting (Format Painter)
B Black out screen during slide show
W White out screen during slide show

Most Frequently Asked Shortcuts (High Priority)

Ctrl+S (Save), Ctrl+Z (Undo), Ctrl+C/V (Copy/Paste) — asked across ALL applications.
F2 has different meaning: Rename (Windows) vs Edit Cell (Excel).
F5: Refresh (Windows/Browser) vs Start Slideshow (PowerPoint) vs Go To (Word/Excel).
Ctrl+Shift+L: Apply Filter (Excel) — frequently tested.

Quick Revision Points

• Memorize common shortcuts first (Ctrl+S, C, V, Z, P, F).
• Note context-dependent keys: F2, F5, Ctrl+D have different functions in different apps.
• Excel filter shortcut: Ctrl+Shift+L.
Memory Tricks
• Group shortcuts by symbol: B=Bold, I=Italic, U=Underline (Ctrl+B/I/U) — same order as
the toolbar.
Frequently Asked MCQs
1. Ctrl + Shift + L in Excel is used to:
(a) Sort data
(b) Apply/remove filter
(c) Insert chart
(d) Format cells
Answer: (b) Apply/remove filter
2. In PowerPoint, F5 is used to:
(a) Insert new slide
(b) Start slide show from beginning
(c) Save the file
(d) Duplicate slide
Answer: (b) Start slide show from beginning
3. F2 in MS Excel is used to:
(a) Rename a file
(b) Edit the active cell
(c) Open Find dialog
(d) Insert a row
Answer: (b) Edit the active cell
4. Ctrl + J in MS Word is used for:
(a) Justify text
(b) Join paragraphs
(c) Insert hyperlink

Page 32 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(d) Jump to page

Answer: (a) Justify text
5. Which key combination inserts a new slide in PowerPoint?
(a) Ctrl + M
(b) Ctrl + N
(c) Ctrl + D
(d) Ctrl + S
Answer: (a) Ctrl + M
6. Ctrl + Space in Excel selects:
(a) Entire row
(b) Entire column
(c) Active cell only
(d) Entire worksheet
Answer: (b) Entire column
7. Which shortcut is used for Spell Check in MS Word?
(a) F5
(b) F7
(c) F2
(d) F4
Answer: (b) F7
8. Alt + = in Excel performs:
(a) Subtraction
(b) AutoSum
(c) Multiplication
(d) Cell formatting
Answer: (b) AutoSum
9. Ctrl + D in Excel is used to:
(a) Delete row
(b) Fill Down
(c) Duplicate sheet
(d) Open dialog box
Answer: (b) Fill Down
10. Shift + F5 in PowerPoint starts the slideshow from:
(a) Beginning
(b) Current slide
(c) Last slide
(d) It does not start a slideshow
Answer: (b) Current slide
11. Ctrl + Home in MS Word moves the cursor to:
(a) End of document
(b) Start of document
(c) Start of line
(d) Next page
Answer: (b) Start of document

Page 33 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

12. Which shortcut toggles absolute cell reference ($) in Excel formulas?
(a) F2
(b) F4
(c) F5
(d) F7
Answer: (b) F4

Page 34 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 9: Microsoft Word

9.1 Important Concepts
Term Description
Ribbon Strip at the top containing Tabs (Home, Insert, Layout, etc.) with
grouped commands
Tabs Home, Insert, Design, Layout, References, Mailings, Review, View
Formatting Changing font, size, color, alignment, style of text
Tables Used to organize data in rows and columns (Insert tab → Table)
Page Setup Controls margins, orientation (Portrait/Landscape), paper size
Header/Footer Text appearing at top (Header) / bottom (Footer) of every page
Page Number Inserted via Insert tab → Page Number
Spell Check Checks spelling/grammar errors (F7 or automatic red/blue
underline)
Mail Merge Creates personalized letters/labels by merging a document with a
data source (e.g., Excel list)
Printing Ctrl + P; can select page range, number of copies, printer

9.2 Mail Merge — Steps (Frequently Asked)

1. Select Document Type → 2. Select Starting Document → 3. Select Recipients (data source,
e.g., Excel/Access file) → 4. Write/Insert Merge Fields → 5. Preview Letters → 6. Complete the
Merge.

9.3 File Extension

Version Extension
MS Word 2003 and earlier .doc
MS Word 2007 and later .docx
Word Template .dotx

Exam Important Points

Default font in MS Word (modern versions) is Calibri, size 11.
Mail Merge requires a Main Document + Data Source.
Header/Footer can include page numbers, date, company name/logo.
Ctrl + N opens a new blank document; Ctrl + S saves it.

Page 35 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

9.4 Key Shortcuts (Word)

Shortcut Function
Ctrl + B / I / U Bold / Italic / Underline
Ctrl + E / L / R / J Center / Left / Right / Justify align
Ctrl + Shift + > / < Increase / Decrease font size
F7 Spell check
Ctrl + K Insert Hyperlink

Quick Revision Points

• Ribbon contains Tabs; Tabs contain Groups; Groups contain Commands.
• Mail Merge = Main Document + Data Source.
• .docx is the default file format from Word 2007 onward.
• Header/Footer repeat on every page.
Memory Tricks
• Mail Merge order: "Select-Start-Recipients-Write-Preview-Complete" (S-S-R-W-P-C).
Frequently Asked MCQs
1. The default file extension in MS Word 2016 is:
(a) .doc
(b) .docx
(c) .txt
(d) .rtf
Answer: (b) .docx
2. Mail Merge is used to:
(a) Merge two documents into one
(b) Create personalized letters using a data source
(c) Check spelling
(d) Insert tables
Answer: (b) Create personalized letters using a data source
3. Which key is used for spell check in MS Word?
(a) F5
(b) F7
(c) F2
(d) F9
Answer: (b) F7
4. Header and Footer appear on:
(a) First page only
(b) Every page of the document
(c) Last page only
(d) Selected pages only
Answer: (b) Every page of the document

Page 36 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

5. The Ribbon in MS Word contains:

(a) Only menus
(b) Tabs with grouped commands
(c) Only the toolbar
(d) Only shortcuts
Answer: (b) Tabs with grouped commands
6. Page orientation options in Page Setup are:
(a) Portrait and Landscape
(b) Vertical and Diagonal
(c) Wide and Narrow
(d) Top and Bottom
Answer: (a) Portrait and Landscape
7. To insert a hyperlink, the shortcut is:
(a) Ctrl + H
(b) Ctrl + K
(c) Ctrl + L
(d) Ctrl + J
Answer: (b) Ctrl + K
8. A Mail Merge data source can be:
(a) An Excel sheet
(b) A picture file
(c) A video file
(d) An audio file
Answer: (a) An Excel sheet
9. Which tab in MS Word ribbon is used to insert a table?
(a) Home
(b) Insert
(c) Review
(d) View
Answer: (b) Insert
10. Ctrl + J in MS Word aligns text as:
(a) Center
(b) Justify
(c) Right
(d) Left
Answer: (b) Justify
11. Which file format is used for a Word template?
(a) .docx
(b) .dotx
(c) .dot
(d) .txt
Answer: (b) .dotx
12. Printing a document is done by pressing:
(a) Ctrl + P
(b) Ctrl + O

Page 37 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(c) Ctrl + N
(d) Ctrl + S
Answer: (a) Ctrl + P

Page 38 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 10: MS Excel

10.1 Basic Terms
Term Description
Workbook An Excel file, contains one or more worksheets
Worksheet A single sheet (grid of rows/columns) within a workbook
Cell Intersection of a row and column (e.g., A1)
Row Horizontal arrangement, identified by numbers (1, 2, 3...)
Column Vertical arrangement, identified by letters (A, B, C...)

Excel Limits (Frequently Asked)

Total rows in a worksheet: 1,048,576
Total columns in a worksheet: 16,384 (last column: XFD)
Default file extension (2007+): .xlsx

10.2 Important Functions

Function Syntax Use
SUM =SUM(A1:A10) Adds values in a range
AVERAGE =AVERAGE(A1:A10) Calculates mean value
COUNT =COUNT(A1:A10) Counts cells containing numbers
COUNTA =COUNTA(A1:A10) Counts non-empty cells
MAX =MAX(A1:A10) Returns largest value
MIN =MIN(A1:A10) Returns smallest value
IF =IF(A1>50,"Pass","Fail") Conditional logic test
ROUND =ROUND(A1,2) Rounds number to given decimal places

10.3 Charts
Used to visually represent data. Common chart types: Bar, Column, Line, Pie, Area, Scatter.
Inserted via Insert tab → Charts group.

10.4 Sorting & Filtering

• Sorting: Arranges data in ascending or descending order (Data tab → Sort).
• Filtering: Displays only data meeting specific criteria, hides the rest (Data tab → Filter,
or Ctrl+Shift+L).

Page 39 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

10.5 Freeze Panes

Keeps specific rows/columns visible while scrolling through the rest of the worksheet — useful
for keeping headers visible. Found under View tab → Freeze Panes.

10.6 Key Shortcuts (Excel)

Shortcut Function
Ctrl + ; Insert current date
Ctrl + Shift + L Apply/Remove Filter
Alt + = AutoSum
F2 Edit active cell
F4 Toggle absolute/relative reference
Ctrl + 1 Format Cells

Quick Revision Points

• Workbook → contains → Worksheets → contain → Cells.
• Rows = numbers; Columns = letters; Cell = e.g. B5.
• IF function tests a condition: =IF(condition, value_if_true, value_if_false).
• Freeze Panes keeps header rows/columns visible while scrolling.
Important Formulas / Conversions
• SUM: =SUM(range)
• AVERAGE: =AVERAGE(range)
• IF: =IF(logical_test, value_if_true, value_if_false)
• ROUND: =ROUND(number, num_digits)
Memory Tricks
• "SACMI-R" — SUM, AVERAGE, COUNT, MAX, MIN, IF, ROUND — the 7 most-asked
Excel functions.
Frequently Asked MCQs
1. In Excel, a Workbook contains:
(a) Only one sheet
(b) One or more worksheets
(c) Only charts
(d) Only formulas
Answer: (b) One or more worksheets
2. Which function returns the largest value in a range?
(a) MIN
(b) MAX
(c) SUM
(d) COUNT
Answer: (b) MAX

Page 40 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

3. The intersection of a row and column is called a:

(a) Field
(b) Cell
(c) Range
(d) Tab
Answer: (b) Cell
4. Default extension of an Excel file (2007 onward) is:
(a) .xls
(b) .xlsx
(c) .xlt
(d) .csv
Answer: (b) .xlsx
5. Which function counts only numeric cells in a range?
(a) COUNTA
(b) COUNT
(c) SUM
(d) AVERAGE
Answer: (b) COUNT
6. Freeze Panes is used to:
(a) Delete rows
(b) Keep rows/columns visible while scrolling
(c) Sort data
(d) Apply filter
Answer: (b) Keep rows/columns visible while scrolling
7. The formula =IF(A1>40,"Pass","Fail") tests:
(a) Whether A1 equals 40
(b) A condition and returns Pass/Fail
(c) The sum of A1
(d) The average of A1
Answer: (b) A condition and returns Pass/Fail
8. Shortcut to apply/remove filter in Excel is:
(a) Ctrl + L
(b) Ctrl + Shift + L
(c) Ctrl + F
(d) Ctrl + Shift + F
Answer: (b) Ctrl + Shift + L
9. Columns in an Excel worksheet are labeled with:
(a) Numbers
(b) Letters
(c) Roman numerals
(d) Symbols
Answer: (b) Letters
10. Total number of rows in a modern Excel worksheet is:
(a) 65,536
(b) 1,048,576

Page 41 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(c) 16,384
(d) 256
Answer: (b) 1,048,576
11. =ROUND(A1,2) will:
(a) Round A1 to nearest whole number
(b) Round A1 to 2 decimal places
(c) Round A1 to 2 significant figures only for integers
(d) Truncate A1
Answer: (b) Round A1 to 2 decimal places
12. Sorting data arranges it in:
(a) Random order
(b) Ascending or Descending order
(c) Filtered order only
(d) Grouped order only
Answer: (b) Ascending or Descending order

Page 42 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 11: MS PowerPoint

11.1 Key Concepts
Term Description
Slides Individual pages of a presentation
Themes Pre-designed combination of colors, fonts, effects applied to whole
presentation
Animations Effects applied to individual objects/text on a slide (entrance,
emphasis, exit)
Transitions Effects applied between two slides while moving from one to
another
Slide Show Mode used to present/run the presentation full-screen (F5)
Insert Pictures Insert tab → Pictures (from device, stock images, or online)

Animations vs Transitions (Frequently Confused)

Animation = effect on an object/text WITHIN a slide.
Transition = effect WHILE MOVING from one slide to the next.

11.2 Key Shortcuts (PowerPoint)

Shortcut Function
F5 Start slide show from the beginning
Shift + F5 Start slide show from current slide
Ctrl + M Insert new slide
Ctrl + D Duplicate selected slide
Esc End slide show

Quick Revision Points

• Theme controls overall look (colors, fonts); applies to whole presentation.
• Animation = within a slide; Transition = between slides.
• Default extension: .pptx (2007 onward); .ppt (2003 and earlier).
• F5 starts the slideshow from slide 1; Shift+F5 starts from the current slide.
Memory Tricks
• "A for Animation = inside the slide; T for Transition = traveling between slides."
Frequently Asked MCQs
1. An effect applied between two slides is called:

Page 43 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(a) Animation
(b) Transition
(c) Theme
(d) Template
Answer: (b) Transition
2. An effect applied to text/objects within a slide is called:
(a) Transition
(b) Animation
(c) Layout
(d) Master Slide
Answer: (b) Animation
3. Which key starts the slide show from the beginning?
(a) F2
(b) F5
(c) F7
(d) F9
Answer: (b) F5
4. Default file extension of PowerPoint (2007 onward) is:
(a) .ppt
(b) .pptx
(c) .pps
(d) .potx
Answer: (b) .pptx
5. A Theme in PowerPoint controls:
(a) Only slide numbers
(b) Colors, fonts and effects of the whole presentation
(c) Only animations
(d) Only transitions
Answer: (b) Colors, fonts and effects of the whole presentation
6. Shift + F5 starts the slide show from:
(a) The first slide
(b) The current slide
(c) The last slide
(d) A random slide
Answer: (b) The current slide
7. Ctrl + M in PowerPoint is used to:
(a) Duplicate a slide
(b) Insert a new slide
(c) Delete a slide
(d) Start slideshow
Answer: (b) Insert a new slide
8. Pictures can be inserted into a slide from the:
(a) Home tab only
(b) Insert tab
(c) Review tab

Page 44 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(d) Animations tab

Answer: (b) Insert tab
9. Which key ends a running slide show?
(a) Esc
(b) F5
(c) Tab
(d) Ctrl
Answer: (a) Esc
10. Ctrl + D in PowerPoint is used to:
(a) Delete a slide
(b) Duplicate a slide
(c) Insert a new slide
(d) Open Design tab
Answer: (b) Duplicate a slide

Page 45 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 12: Internet

12.1 Key Terms
Term Description
WWW (World Wide Web) System of interlinked web pages accessed via the Internet;
invented by Tim Berners-Lee (1989)
Browser Software used to access/view web pages (e.g., Chrome, Firefox,
Edge, Safari)
Search Engine Tool used to search for information on the web (e.g., Google,
Bing, Yahoo)
URL (Uniform Resource Address of a web page/resource on the internet
Locator)
HTTP HyperText Transfer Protocol — transfers web pages, NOT
secure
HTTPS HTTP Secure — encrypted, secure version of HTTP (uses
SSL/TLS)
Downloading Transferring data FROM the internet TO your device
Uploading Transferring data FROM your device TO the internet
Cookies Small text files stored by websites on your device to remember
preferences/login info
Cache Temporarily stored web data (pages/images) to load websites
faster on revisit

12.2 HTTP vs HTTPS (Frequently Asked)

HTTP HTTPS
Not secure, no encryption Secure, data is encrypted (SSL/TLS)
Uses Port 80 Uses Port 443
No padlock icon in browser Shows padlock icon in browser

12.3 Downloading vs Uploading

Downloading Uploading
Receiving data from internet to device Sending data from device to internet
Example: Downloading a PDF Example: Uploading a photo to social media

Page 46 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Exam Important Points

Tim Berners-Lee invented WWW in 1989.
A URL example: [Link] — "https" is the protocol, "[Link]" is
the domain.
Cookies can store login sessions, preferences; Cache stores page data for speed.
Internet vs WWW: Internet is the physical network of networks; WWW is a service that runs
on the Internet.

Quick Revision Points

• WWW invented by Tim Berners-Lee (1989).
• HTTPS = HTTP + Security (encryption via SSL/TLS), Port 443.
• Cookies = remember user info; Cache = stores web data for faster loading.
• Browser = software to view web pages; Search Engine = tool to find information.
Memory Tricks
• "S in HTTPS = Secure/SSL." Remember Port 80 = HTTP, Port 443 = HTTPS.
Frequently Asked MCQs
1. WWW was invented by:
(a) Bill Gates
(b) Tim Berners-Lee
(c) Steve Jobs
(d) Charles Babbage
Answer: (b) Tim Berners-Lee
2. HTTPS uses which port by default?
(a) 80
(b) 8080
(c) 443
(d) 21
Answer: (c) 443
3. Which of the following is a web browser?
(a) Google
(b) Chrome
(c) Yahoo
(d) Bing
Answer: (b) Chrome
4. Transferring a file from your computer to a server is called:
(a) Downloading
(b) Uploading
(c) Caching
(d) Browsing
Answer: (b) Uploading
5. Cookies are used by websites to:
(a) Increase internet speed
(b) Remember user preferences/login info

Page 47 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(c) Protect against viruses

(d) Compress images
Answer: (b) Remember user preferences/login info
6. HTTP stands for:
(a) HyperText Transfer Protocol
(b) High Transfer Text Protocol
(c) HyperText Transmission Process
(d) High Text Transfer Process
Answer: (a) HyperText Transfer Protocol
7. A URL is best described as:
(a) A type of virus
(b) The address of a resource on the internet
(c) A search engine
(d) An email client
Answer: (b) The address of a resource on the internet
8. Which protocol is more secure?
(a) HTTP
(b) HTTPS
(c) FTP
(d) Both are equally secure
Answer: (b) HTTPS
9. Cache memory on a browser is used to:
(a) Permanently delete history
(b) Store data temporarily for faster page loading
(c) Send emails
(d) Block websites
Answer: (b) Store data temporarily for faster page loading
10. Which is an example of a search engine?
(a) Chrome
(b) Google
(c) Firefox
(d) Edge
Answer: (b) Google
11. The default port for HTTP is:
(a) 21
(b) 25
(c) 80
(d) 443
Answer: (c) 80
12. Internet differs from WWW because Internet is:
(a) A type of website
(b) The physical network connecting computers globally
(c) A search engine
(d) Same as WWW exactly
Answer: (b) The physical network connecting computers globally

Page 48 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 13: Email

13.1 Email Structure
Field Description
From Sender’s email address
To Primary recipient(s) of the email
CC (Carbon Copy) Additional recipients; all recipients can see who else received the
mail
BCC (Blind Carbon Copy) Additional recipients; their addresses are hidden from other
recipients
Subject Brief title summarizing the email content
Attachment A file (document/image/etc.) sent along with the email
Draft An unsent, saved email
Signature Predefined text (name, designation, contact) auto-added at the
end of emails
Spam Unwanted/junk/bulk unsolicited email

13.2 CC vs BCC (Frequently Asked)

CC BCC
Visible to all recipients Hidden from all other recipients
Used for transparency (everyone knows who Used for privacy (recipient list kept
got the mail) confidential)

13.3 Email Etiquette

• Use a clear, relevant Subject line.
• Use proper greeting and closing (Dear/Regards).
• Avoid using ALL CAPS (perceived as shouting).
• Proofread before sending; check attachments are included.
• Use CC/BCC appropriately — do not overuse "Reply All."
• Keep the email concise and professional in tone.

Exam Important Points

Email was invented by Ray Tomlinson; he also introduced "@" symbol in email addresses.
Spam folder collects unsolicited/junk emails automatically.
A Draft is automatically saved if you start writing but don’t send the email.

Page 49 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Quick Revision Points

• CC = visible to all; BCC = hidden from others.
• "@" symbol separates username from domain name in an email address.
• Spam = unwanted bulk email; Draft = unsent saved email.
Memory Tricks
• "BCC = Blind = can’t see others" — easy way to remember the hidden nature of BCC.
Frequently Asked MCQs
1. BCC stands for:
(a) Blind Carbon Copy
(b) Basic Carbon Copy
(c) Blind Custom Copy
(d) Bulk Carbon Copy
Answer: (a) Blind Carbon Copy
2. In CC, the recipient list is:
(a) Hidden
(b) Visible to all recipients
(c) Encrypted
(d) Deleted after sending
Answer: (b) Visible to all recipients
3. Who introduced the "@" symbol in email addresses?
(a) Bill Gates
(b) Ray Tomlinson
(c) Tim Berners-Lee
(d) Steve Jobs
Answer: (b) Ray Tomlinson
4. An unsent saved email is stored in:
(a) Inbox
(b) Draft
(c) Spam
(d) Sent
Answer: (b) Draft
5. Unwanted/junk emails are referred to as:
(a) Draft
(b) Spam
(c) Signature
(d) Attachment
Answer: (b) Spam
6. A file sent along with an email is called a/an:
(a) Signature
(b) Attachment
(c) Draft
(d) CC
Answer: (b) Attachment

Page 50 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

7. Using BCC is appropriate when:

(a) You want everyone to see all recipients
(b) You want to hide recipient addresses from each other
(c) You want to delete the email
(d) You want to mark email urgent
Answer: (b) You want to hide recipient addresses from each other
8. An email signature typically contains:
(a) Subject line
(b) Name, designation and contact details
(c) Spam filter settings
(d) Attachment size
Answer: (b) Name, designation and contact details
9. Writing an email entirely in capital letters is considered:
(a) Polite
(b) Shouting/rude
(c) Mandatory
(d) A formatting requirement
Answer: (b) Shouting/rude
10. Which field is used to specify the topic of the email briefly?
(a) To
(b) CC
(c) Subject
(d) BCC
Answer: (c) Subject

Page 51 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 14: E-Banking

14.1 Key Terms
Term Description
Internet Banking Banking transactions performed via a bank’s website using a
computer/internet
Mobile Banking Banking transactions performed via a mobile app
UPI (Unified Payments Real-time payment system enabling instant fund transfer via
Interface) mobile, developed by NPCI
NEFT (National Electronic Fund transfer in batches/settlement cycles; no
Funds Transfer) minimum/maximum limit
RTGS (Real Time Gross Real-time, high-value fund transfer; minimum amount ₹2 lakh
Settlement)
IMPS (Immediate Instant fund transfer, available 24x7, including holidays
Payment Service)
Debit Card Linked directly to bank account; deducts money immediately
from account balance
Credit Card Allows borrowing money up to a credit limit; repaid later (with
interest if delayed)

14.2 NEFT vs RTGS vs IMPS (Frequently Asked Comparison)

Mode Settlement Minimum Amount Availability
NEFT Batch-wise (half-hourly No minimum 24x7
cycles)
RTGS Real-time, individual ₹2 Lakh minimum 24x7
IMPS Real-time, instant No minimum 24x7 including holidays

14.3 Debit Card vs Credit Card

Debit Card Credit Card
Deducts money directly from bank account Borrows money up to a sanctioned limit
No interest charged (uses own money) Interest charged if bill not paid on time
No credit limit; spend only available balance Has a pre-approved credit limit

Exam Important Points

UPI was launched by NPCI (National Payments Corporation of India) in 2016.

Page 52 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

RTGS is meant for high-value transactions (minimum ₹2 lakh); NEFT/IMPS have no

minimum limit.
IMPS works even on bank holidays/24x7, including NEFT and RTGS now (RBI made NEFT
& RTGS 24x7 since Dec 2020/2019 respectively).
OTP (One Time Password) adds a security layer to online banking transactions.

Quick Revision Points

• UPI, NEFT, RTGS, IMPS are electronic fund transfer methods in India.
• RTGS = real-time + high value (min ₹2 lakh); NEFT = batch-wise, no minimum; IMPS =
instant, 24x7.
• Debit Card = own money; Credit Card = borrowed money (credit limit).
Memory Tricks
• "RTGS = Real-money, Truly Gross, Significant amount (high value)."
Frequently Asked MCQs
1. RTGS is mainly used for:
(a) Small value transactions
(b) High-value, real-time transactions
(c) Only international transfers
(d) Cash withdrawal
Answer: (b) High-value, real-time transactions
2. The minimum amount required for RTGS transfer is:
(a) ₹1,000
(b) ₹10,000
(c) ₹2 Lakh
(d) ₹50,000
Answer: (c) ₹2 Lakh
3. UPI was developed/launched by:
(a) RBI directly
(b) NPCI
(c) SBI
(d) World Bank
Answer: (b) NPCI
4. Which payment mode works 24x7 including bank holidays and has no minimum limit?
(a) RTGS
(b) NEFT
(c) IMPS
(d) Cheque
Answer: (c) IMPS
5. A Debit Card deducts money from:
(a) A credit limit
(b) The user’s own bank account balance
(c) The bank’s reserve fund
(d) A loan account

Page 53 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Answer: (b) The user’s own bank account balance

6. A Credit Card allows the user to:
(a) Spend only available balance
(b) Borrow money up to a sanctioned limit
(c) Earn fixed interest
(d) Withdraw cash without limit free of cost
Answer: (b) Borrow money up to a sanctioned limit
7. NEFT stands for:
(a) National Electronic Funds Transfer
(b) National Express Fund Transfer
(c) New Electronic Fund Transaction
(d) National Exchange Funds Transfer
Answer: (a) National Electronic Funds Transfer
8. IMPS stands for:
(a) Immediate Payment Service
(b) Instant Money Processing System
(c) Internet Mobile Payment Service
(d) Indian Money Payment System
Answer: (a) Immediate Payment Service
9. OTP in banking is used for:
(a) Marketing
(b) Adding security to transactions
(c) Increasing transaction limit
(d) Currency conversion
Answer: (b) Adding security to transactions
10. Which of these requires no minimum transaction amount?
(a) RTGS
(b) NEFT
(c) Loan disbursement
(d) Fixed Deposit
Answer: (b) NEFT
11. Mobile Banking refers to banking done via:
(a) ATM only
(b) A mobile app
(c) Bank branch visit
(d) Postal services
Answer: (b) A mobile app
12. RTGS stands for:
(a) Real Time Gross Settlement
(b) Rapid Transfer Gateway System
(c) Real Time General Settlement
(d) Reserve Time Gross Settlement
Answer: (a) Real Time Gross Settlement

Page 54 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 15: Networking

15.1 Types of Networks (By Geographic Coverage)
Network Full Form Coverage
PAN Personal Area Network Very short range (e.g., Bluetooth, few
meters)
LAN Local Area Network Small area — office, building, campus
MAN Metropolitan Area Network City-wide network
WAN Wide Area Network Large geographic area — country/global
(e.g., Internet)

15.2 Network Devices

Device Function
Router Connects multiple networks; directs data packets between networks
(e.g., connects LAN to Internet)
Switch Connects multiple devices within the same LAN; sends data only to the
intended device
Hub Connects multiple devices; broadcasts data to ALL devices (no
intelligence) — outdated vs switch
Repeater Amplifies/regenerates signal to extend network coverage/distance
Bridge Connects two LAN segments, filters traffic between them
Gateway Connects two dissimilar networks (different protocols)
Modem Modulator-Demodulator; converts digital signal to analog and vice
versa (for internet over telephone lines)

15.3 Hub vs Switch vs Router (Frequently Asked)

Hub Switch Router
Broadcasts to all ports Sends data to specific device Connects different networks
(intelligent)
Operates at Physical layer Operates at Data Link layer Operates at Network layer
No filtering of data Filters data using MAC Routes data using IP address
address

Page 55 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

15.4 IP Address, MAC Address, DNS, DHCP

• IP Address: Unique logical address assigned to a device on a network (e.g.,
[Link]); IPv4 (32-bit) and IPv6 (128-bit).
• MAC Address: Unique physical/hardware address (48-bit) burnt into the Network
Interface Card (NIC); does not change.
• DNS (Domain Name System): Translates domain names (e.g., [Link]) into IP
addresses — "Phonebook of the Internet."
• DHCP (Dynamic Host Configuration Protocol): Automatically assigns IP addresses to
devices on a network.

15.5 Basic Protocols

Protocol Use
HTTP Transfer of web pages (not secure)
HTTPS Secure transfer of web pages (encrypted)
FTP (File Transfer Protocol) Transferring files between computers over a network
SMTP (Simple Mail Transfer Sending emails
Protocol)
POP3 (Post Office Protocol) Receiving/downloading emails to a single device (removes
from server)
IMAP (Internet Message Receiving emails while keeping them synced on the server
Access Protocol) (accessible from multiple devices)
TCP/IP Core protocol suite for data transmission across
networks/internet

Exam Important Points

IP Address can change (dynamic); MAC Address is fixed (static, hardware-based).
DNS converts domain names to IP addresses.
TCP/IP is called the backbone protocol of the Internet.
SMTP = sending mail; POP3/IMAP = receiving mail.

Quick Revision Points

• Network size order: PAN < LAN < MAN < WAN.
• Hub = broadcasts to all; Switch = sends to specific device; Router = connects different
networks.
• MAC = physical/permanent address; IP = logical/can change address.
• DNS = name to IP translator; DHCP = auto-assigns IP addresses.
Memory Tricks
• "Please Login Monthly Without fail" → PAN, LAN, MAN, WAN (size order, smallest to
largest).

Page 56 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Frequently Asked MCQs

1. LAN stands for:
(a) Local Area Network
(b) Limited Access Network
(c) Large Area Network
(d) Local Access Node
Answer: (a) Local Area Network
2. Which device broadcasts data to all connected devices without filtering?
(a) Switch
(b) Router
(c) Hub
(d) Bridge
Answer: (c) Hub
3. A device that connects two different networks using different protocols is:
(a) Switch
(b) Gateway
(c) Repeater
(d) Hub
Answer: (b) Gateway
4. MAC Address is a:
(a) Logical, changeable address
(b) Physical, fixed hardware address
(c) Domain name
(d) Software license key
Answer: (b) Physical, fixed hardware address
5. DNS is used to:
(a) Assign IP addresses automatically
(b) Translate domain names into IP addresses
(c) Encrypt data
(d) Compress files
Answer: (b) Translate domain names into IP addresses
6. Which protocol is used for sending emails?
(a) POP3
(b) IMAP
(c) SMTP
(d) FTP
Answer: (c) SMTP
7. DHCP is used to:
(a) Translate domain names
(b) Automatically assign IP addresses
(c) Encrypt emails
(d) Transfer files
Answer: (b) Automatically assign IP addresses
8. Which network covers an entire city?

Page 57 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(a) LAN
(b) PAN
(c) MAN
(d) WAN
Answer: (c) MAN
9. A Modem performs which conversion?
(a) Digital to Digital
(b) Analog to Digital and Digital to Analog
(c) Optical to Digital
(d) IP to MAC
Answer: (b) Analog to Digital and Digital to Analog
10. Which protocol allows files to be transferred between computers?
(a) HTTP
(b) FTP
(c) SMTP
(d) DNS
Answer: (b) FTP
11. A Repeater is used to:
(a) Filter network traffic
(b) Amplify/extend a signal over distance
(c) Assign IP addresses
(d) Convert protocols
Answer: (b) Amplify/extend a signal over distance
12. Which protocol keeps emails synced across multiple devices?
(a) POP3
(b) IMAP
(c) SMTP
(d) FTP
Answer: (b) IMAP
13. IPv4 address is how many bits?
(a) 16-bit
(b) 32-bit
(c) 64-bit
(d) 128-bit
Answer: (b) 32-bit
14. A Switch operates mainly using which address to forward data?
(a) IP Address
(b) MAC Address
(c) URL
(d) Domain Name
Answer: (b) MAC Address

Page 58 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Chapter 16: Cyber Security

16.1 Threats
Threat Description
Virus Malicious program that attaches itself to files/programs and spreads
when the host file is executed/shared
Worm Self-replicating malicious program that spreads across networks
WITHOUT needing a host file or user action
Trojan (Trojan Horse) Disguises itself as legitimate software but performs malicious actions
once installed
Spyware Secretly monitors and collects user activity/data without consent
Ransomware Locks/encrypts victim’s data and demands ransom payment for
release
Phishing Fraudulent attempt to obtain sensitive info (passwords, card details)
by posing as a trustworthy entity (fake emails/sites)
Hacking Unauthorized access into a computer system or network
Malware Umbrella term for any malicious software (viruses, worms, trojans,
spyware, ransomware, etc.)

16.2 Virus vs Worm vs Trojan (Frequently Compared)

Virus Worm Trojan
Needs a host file to spread Self-replicates, spreads Disguised as legitimate
independently over network software
Needs user action (open/run Does NOT need user action Needs user to install it
file)
Can corrupt/delete files Consumes bandwidth, slows Creates backdoor for hackers
network

16.3 Protective Measures

Term Description
Firewall Hardware/software security barrier that monitors and controls
incoming/outgoing network traffic
Antivirus Software that detects, prevents and removes malware
VPN (Virtual Private Creates a secure, encrypted connection over the internet, hides
Network) real IP address

Page 59 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Term Description
Two-Factor Authentication Requires two methods of verification (e.g., password + OTP) for
(2FA) extra security

16.4 Password Safety & Cyber Safety Tips

• Use strong passwords: mix of uppercase, lowercase, numbers, special characters.
• Never share passwords or OTPs with anyone.
• Enable Two-Factor Authentication wherever possible.
• Avoid clicking unknown links or downloading attachments from unknown senders.
• Keep operating system, antivirus and software updated regularly.
• Use HTTPS websites for sensitive transactions (look for padlock icon).
• Regularly back up important data.
• Avoid using public Wi-Fi for banking transactions (or use VPN).

Exam Important Points

A Firewall can be hardware-based, software-based, or both.
Phishing typically occurs through fake emails or fraudulent websites mimicking real ones.
Ransomware famous example: WannaCry attack (2017).
Antivirus needs regular updates to detect new threats (virus definitions).

Quick Revision Points

• Virus needs host file + user action; Worm spreads independently; Trojan disguises as
legitimate software.
• Malware = umbrella term for all malicious software.
• Firewall = traffic gatekeeper; Antivirus = detects/removes malware; VPN = secure
encrypted connection.
• Phishing = fraud via fake emails/websites to steal information.
Memory Tricks
• "VWT" — Virus=needs host, Worm=self-spreads, Trojan=disguised gift (like the Greek
Trojan Horse story).
Frequently Asked MCQs
1. A self-replicating malicious program that spreads without needing a host file is called:
(a) Virus
(b) Worm
(c) Trojan
(d) Spyware
Answer: (b) Worm
2. Malicious software disguised as legitimate software is called:
(a) Worm
(b) Trojan Horse
(c) Firewall
(d) Antivirus

Page 60 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Answer: (b) Trojan Horse

3. Ransomware mainly:
(a) Steals passwords only
(b) Encrypts data and demands payment for release
(c) Monitors browsing activity
(d) Speeds up the computer
Answer: (b) Encrypts data and demands payment for release
4. Phishing is best described as:
(a) A type of antivirus
(b) Fraudulent attempt to steal sensitive information via fake emails/sites
(c) A network device
(d) A firewall feature
Answer: (b) Fraudulent attempt to steal sensitive information via fake emails/sites
5. A Firewall is used to:
(a) Speed up internet connection
(b) Monitor/control incoming and outgoing network traffic
(c) Store passwords
(d) Compress files
Answer: (b) Monitor/control incoming and outgoing network traffic
6. VPN stands for:
(a) Virtual Private Network
(b) Verified Personal Network
(c) Virtual Public Network
(d) Verified Private Node
Answer: (a) Virtual Private Network
7. Two-Factor Authentication typically combines:
(a) Two passwords
(b) Password + a second verification method (e.g., OTP)
(c) Username + Username
(d) Two antivirus programs
Answer: (b) Password + a second verification method (e.g., OTP)
8. Software that secretly monitors user activity is called:
(a) Antivirus
(b) Spyware
(c) Firewall
(d) VPN
Answer: (b) Spyware
9. Which is the umbrella term covering viruses, worms, trojans, spyware, etc.?
(a) Firewall
(b) Malware
(c) Antivirus
(d) VPN
Answer: (b) Malware
10. A virus requires which of the following to spread?

Page 61 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(a) A network only

(b) A host file and user action
(c) A firewall
(d) A VPN
Answer: (b) A host file and user action
11. The famous 2017 ransomware attack was called:
(a) ILOVEYOU
(b) WannaCry
(c) Stuxnet
(d) Melissa
Answer: (b) WannaCry
12. Which of these is the BEST practice for password safety?
(a) Sharing passwords with close friends
(b) Using the same password everywhere
(c) Using a strong, unique password with 2FA
(d) Writing passwords on sticky notes
Answer: (c) Using a strong, unique password with 2FA
13. Unauthorized access to a computer system is called:
(a) Hacking
(b) Antivirus
(c) Firewall
(d) Patching
Answer: (a) Hacking
14. Public Wi-Fi for banking transactions is:
(a) Always safe
(b) Risky; should be avoided or used with VPN
(c) Required by banks
(d) Faster than private networks
Answer: (b) Risky; should be avoided or used with VPN

Page 62 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Final Chapter: One-Day Revision

This chapter consolidates the entire syllabus into rapid-revision format for use a few hours
before the exam.

A. 100 Quick One-Liners

Set 1 (1–50)
• Father of Computer — Charles Babbage.
• Father of Modern Computer Science — Alan Turing.
• CPU is called the "Brain" of the computer.
• GIGO = Garbage In, Garbage Out.
• Binary number system uses only 0 and 1.
• 1 Byte = 8 Bits.
• 1 KB = 1024 Bytes.
• 1 MB = 1024 KB.
• 1 GB = 1024 MB.
• 1 TB = 1024 GB.
• RAM is volatile memory; ROM is non-volatile memory.
• ALU performs arithmetic and logical operations.
• Control Unit directs/coordinates CPU operations.
• Machine cycle order: Fetch → Decode → Execute → Store.
• Cache memory lies between CPU and RAM.
• Virtual memory uses hard disk space as extra RAM.
• Memory hierarchy (fastest to slowest): Register > Cache > RAM > Secondary Storage.
• MICR is used in bank cheques.
• OMR is used for evaluating exam answer sheets.
• OCR converts printed text into editable digital text.
• Plotter is used for large engineering drawings/maps.
• Laser printer gives the best output quality among common printers.
• SSD has no moving parts, faster than HDD.
• HDD uses magnetic storage with moving parts.
• Optical disks (CD/DVD/Blu-ray) use laser technology.
• DVD capacity is approx. 4.7 GB (single layer).
• Blu-ray uses a blue laser.
• USB is the most commonly used port today.
• HDMI carries both audio and video digitally.
• VGA carries only analog video, no audio.
• PS/2 purple port = keyboard; green port = mouse.
• Ethernet port is also called RJ-45.
• Recycle Bin temporarily stores deleted files.

Page 63 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

• Shift + Delete permanently deletes a file.

• Win + E opens File Explorer.
• Win + L locks the computer.
• Control Panel is used to change system settings.
• Ctrl + S = Save, Ctrl + P = Print, Ctrl + Z = Undo.
• F2 in Windows = Rename; F2 in Excel = Edit active cell.
• F5 in PowerPoint = Start slideshow; F5 in browser = Refresh.
• Mail Merge requires a Main Document + Data Source.
• Default Word file extension (2007+) is .docx.
• Default Excel file extension (2007+) is .xlsx.
• Default PowerPoint file extension (2007+) is .pptx.
• Excel worksheet has 1,048,576 rows and 16,384 columns.
• SUM, AVERAGE, COUNT, MAX, MIN, IF, ROUND are key Excel functions.
• Freeze Panes keeps headers visible while scrolling in Excel.
• Animation = effect within a slide; Transition = effect between slides.
• WWW was invented by Tim Berners-Lee in 1989.
• HTTPS is the secure version of HTTP (Port 443 vs Port 80).
Set 2 (51–100)
• Cookies store user preferences/login info; Cache stores web data for faster loading.
• Downloading = data from internet to device; Uploading = device to internet.
• CC recipients are visible to all; BCC recipients are hidden.
• "@" symbol in email was introduced by Ray Tomlinson.
• UPI was launched by NPCI in 2016.
• RTGS minimum transfer amount is ₹2 Lakh.
• NEFT and IMPS have no minimum transfer limit.
• IMPS works 24x7, including bank holidays.
• Debit card uses own money; Credit card uses borrowed money (credit limit).
• Network size order: PAN < LAN < MAN < WAN.
• Router connects different networks; Switch connects devices within a LAN intelligently.
• Hub broadcasts data to all ports without filtering.
• MAC address is fixed/hardware-based; IP address is logical/can change.
• DNS translates domain names into IP addresses.
• DHCP automatically assigns IP addresses.
• SMTP is used for sending emails; POP3/IMAP for receiving.
• TCP/IP is the backbone protocol suite of the Internet.
• Virus needs a host file and user action to spread.
• Worm self-replicates and spreads without user action.
• Trojan disguises itself as legitimate software.
• Ransomware encrypts data and demands payment.
• Phishing steals information via fake emails/websites.
• Malware is the umbrella term for all malicious software.

Page 64 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

• Firewall monitors/controls network traffic.

• VPN creates a secure encrypted connection and hides the real IP address.
• Two-Factor Authentication adds password + OTP (or similar) for security.
• IPv4 address is 32-bit; IPv6 address is 128-bit.
• Cloud storage examples: Google Drive, OneDrive, Dropbox.
• Hardware is tangible; Software is a set of instructions (intangible).
• Supercomputer is the fastest and largest type of computer.
• Microcomputer (PC) is the smallest category of computer.
• A Hybrid computer combines features of analog and digital computers (e.g., ECG
machine).
• Clock speed is measured in GHz (Gigahertz).
• Speed of supercomputers is measured in FLOPS.
• Speed of PCs is generally referenced in MIPS.
• Impact printers physically strike paper (e.g., Dot Matrix); Non-impact printers do not
(e.g., Laser, Inkjet).
• Ctrl + Shift + L in Excel applies/removes a filter.
• Alt + F4 closes the active window/application.
• Ctrl + N opens a new document/file in most applications.
• A Bridge connects two LAN segments and filters traffic.
• A Gateway connects two dissimilar networks (different protocols).
• A Repeater amplifies/extends a network signal.
• A Modem converts digital signals to analog and vice versa.
• WannaCry (2017) is a famous ransomware attack.
• HTTPS shows a padlock icon in the browser address bar.
• Internet Banking is done via a computer/website; Mobile Banking via an app.
• Mail Merge steps: Select recipients → Write letter → Insert merge fields → Preview →
Complete.
• Page Setup controls margins, orientation, and paper size in MS Word.
• Slide Show mode in PowerPoint is started with F5.
• A worksheet is part of a workbook in Excel; a workbook can contain many worksheets.

B. Final Revision Sheet — Most Important Facts

Topic Key Fact
Father of Computer Charles Babbage
CPU Components ALU + Control Unit + Registers
Machine Cycle Fetch → Decode → Execute → Store
RAM / ROM Volatile / Non-volatile
1 Byte 8 Bits
MICR / OMR / OCR Banking / Exams / Text Conversion
HDD vs SSD Magnetic, moving parts vs Flash, no moving parts

Page 65 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Topic Key Fact

HDMI vs VGA Digital A+V vs Analog Video only
USB Most common, universal port
Excel rows/columns 1,048,576 rows / 16,384 columns
Animation vs Transition Within slide vs Between slides
HTTP vs HTTPS Port 80 (insecure) vs Port 443 (secure)
CC vs BCC Visible vs Hidden recipients
RTGS minimum ₹2 Lakh
PAN<LAN<MAN<WAN Network size order
MAC vs IP Address Fixed/Physical vs Logical/Changeable
DNS Domain name → IP address translator
Virus vs Worm vs Trojan Host needed vs Self-spreading vs Disguised
Firewall Controls network traffic
VPN Secure encrypted connection, hides IP

C. Frequently Confused Terms — Side-by-Side

Term A Term B Key Difference
RAM ROM Volatile/Read-Write vs Non-volatile/Read-Only
MICR OMR Banking cheques vs Exam answer sheets
HDD SSD Magnetic/moving parts vs Flash/no moving parts
HTTP HTTPS Not secure vs Secure (SSL/TLS)
CC BCC Visible vs Hidden recipients
NEFT RTGS Batch-wise, no minimum vs Real-time, min ₹2
Lakh
LAN WAN Small local area vs Large/global area
Hub Switch Broadcasts to all vs Sends to specific device
MAC Address IP Address Fixed hardware address vs Logical/changeable
address
Virus Worm Needs host file vs Self-replicating, independent
Animation Transition Effect within slide vs Effect between slides
Downloading Uploading Internet → Device vs Device → Internet
Debit Card Credit Card Own money vs Borrowed money (credit limit)
Firewall Antivirus Controls network traffic vs Detects/removes

Page 66 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

Term A Term B Key Difference

malware
Cookies Cache Stores user preference/login data vs Stores
page data for speed

D. Important Tables Recap

Memory Units
Unit Value
1 Byte 8 Bits
1 KB 1024 Bytes
1 MB 1024 KB
1 GB 1024 MB
1 TB 1024 GB

Fund Transfer Modes

Mode Key Point
NEFT Batch-wise, no minimum amount
RTGS Real-time, minimum ₹2 Lakh
IMPS Instant, 24x7 including holidays
UPI Real-time mobile payments via NPCI

E. Most Expected Additional MCQs

Additional MCQ Practice Set
1. Which generation of computers used microprocessors?
(a) First
(b) Second
(c) Third
(d) Fourth
Answer: (d) Fourth
2. The smallest unit of data in a computer is:
(a) Byte
(b) Bit
(c) Nibble
(d) Word
Answer: (b) Bit
3. Which of these is an input AND output device?

Page 67 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(a) Keyboard
(b) Touch Screen
(c) Mouse
(d) Scanner
Answer: (b) Touch Screen
4. Which memory type is fastest among the options?
(a) Hard Disk
(b) RAM
(c) Cache
(d) Pen Drive
Answer: (c) Cache
5. A computer virus mainly affects:
(a) Hardware components
(b) Software/files/data
(c) Power supply
(d) Network cables
Answer: (b) Software/files/data
6. Which key combination is used to select all content?
(a) Ctrl + A
(b) Ctrl + S
(c) Ctrl + B
(d) Ctrl + N
Answer: (a) Ctrl + A
7. A worksheet cell reference like $A$1 indicates:
(a) Relative reference
(b) Absolute reference
(c) Mixed reference
(d) Invalid reference
Answer: (b) Absolute reference
8. Which is the correct order of memory hierarchy (fastest to slowest)?
(a) RAM > Cache > Register
(b) Register > Cache > RAM
(c) Cache > Register > RAM
(d) RAM > Register > Cache
Answer: (b) Register > Cache > RAM
9. Which device is used to connect a LAN to the Internet?
(a) Hub
(b) Router
(c) Repeater
(d) Switch
Answer: (b) Router
10. A Trojan horse is named after which historical reference?
(a) Greek mythology (Trojan War)
(b) Roman Empire
(c) Egyptian Pyramids

Page 68 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(d) Chinese history

Answer: (a) Greek mythology (Trojan War)
11. Which protocol is used to access secure websites?
(a) FTP
(b) HTTPS
(c) SMTP
(d) POP3
Answer: (b) HTTPS
12. Which of the following best defines "Phishing"?
(a) A type of antivirus
(b) A method to steal information via fake communication
(c) A network protocol
(d) A type of hardware
Answer: (b) A method to steal information via fake communication
13. The default alignment shortcut for centering text is:
(a) Ctrl + L
(b) Ctrl + E
(c) Ctrl + R
(d) Ctrl + J
Answer: (b) Ctrl + E
14. Which is the correct full form of DHCP?
(a) Dynamic Host Configuration Protocol
(b) Digital Host Control Protocol
(c) Data Host Configuration Process
(d) Dynamic Hardware Control Protocol
Answer: (a) Dynamic Host Configuration Protocol
15. Excel function to find the average of a range is:
(a) =AVG()
(b) =AVERAGE()
(c) =MEAN()
(d) =SUM()/COUNT()
Answer: (b) =AVERAGE()
16. Which port number is associated with HTTP?
(a) 21
(b) 25
(c) 80
(d) 110
Answer: (c) 80
17. A Gateway is mainly used to connect:
(a) Two similar LANs
(b) Two networks using different protocols
(c) A printer to a PC
(d) A monitor to a CPU
Answer: (b) Two networks using different protocols

Page 69 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

18. The technique of storing frequently used data closer to CPU for speed is:
(a) Virtual Memory
(b) Caching
(c) Paging
(d) Buffering
Answer: (b) Caching
19. Which of these offers the largest storage capacity typically?
(a) CD
(b) DVD
(c) Blu-ray
(d) Floppy Disk
Answer: (c) Blu-ray
20. A Spreadsheet program is best represented by:
(a) MS Word
(b) MS Excel
(c) MS PowerPoint
(d) MS Access only
Answer: (b) MS Excel
21. Which of the following is volatile memory?
(a) ROM
(b) Hard Disk
(c) RAM
(d) Pen Drive
Answer: (c) RAM
22. Which shortcut duplicates a slide in PowerPoint?
(a) Ctrl + M
(b) Ctrl + D
(c) Ctrl + N
(d) Ctrl + C
Answer: (b) Ctrl + D
23. A computer network confined to a single building is most likely a:
(a) WAN
(b) MAN
(c) LAN
(d) PAN only
Answer: (c) LAN
24. Which of these encrypts internet traffic and hides your IP address?
(a) Firewall
(b) VPN
(c) Antivirus
(d) Cache
Answer: (b) VPN
25. Excel shortcut to insert the current date is:
(a) Ctrl + ;
(b) Ctrl + D

Page 70 of 71
 Computer Knowledge & Proficiency — AEE Exam Notes

(c) Ctrl + T
(d) Ctrl + Shift + D
Answer: (a) Ctrl + ;

F. Memory Tricks — Master Recap

• "Please Login Monthly Without fail" → PAN, LAN, MAN, WAN.
• "Bad Boys Kill Mosquitoes, Girls Throw Plates" → Bit, Byte, KB, MB, GB, TB, PB.
• "FDES" → Fetch, Decode, Execute, Store (Machine Cycle).
• "SACMI-R" → SUM, AVERAGE, COUNT, MAX, MIN, IF, ROUND (Excel functions).
• "S in HTTPS = Secure" → Port 443, encrypted.
• "BCC = Blind, can’t see others."
• "RTGS = Real-money, Truly Gross, Significant (high value)."

G. Last-Minute Checklist Before Exam

• Revise all chapter-end Quick Revision Points once.
• Go through the Final Revision Sheet (Section B above) thoroughly.
• Recheck all Comparison Tables (RAM vs ROM, HDD vs SSD, NEFT vs RTGS, Virus vs
Worm vs Trojan, etc.).
• Revise the full Keyboard Shortcuts master table (Chapter 8).
• Attempt all MCQs once more and re-check any wrong answers.
• Stay calm, read each question carefully, and manage time during the exam.

Page 71 of 71