UNIT – 1: Number Systems, Evolution, Block Diagram & Generations
Very Important Questions (Long Answer)
1. Explain number systems with examples. Describe binary, decimal, octal, and
hexadecimal systems.
2. Explain conversion between number systems:
o Decimal to Binary
o Binary to Decimal
o Binary to Octal and Hexadecimal
3. Explain the evolution of computers from early mechanical devices to modern
computers.
4. Draw and explain the Block Diagram of a Computer.
5. Explain the generations of computers (First to Fifth) with:
o Technology used
o Characteristics
o Examples
Short Answer Questions
• Define binary number system.
• What is a hexadecimal number system?
• What is an ALU?
• What is the role of Control Unit (CU)?
• Write any two characteristics of first-generation computers.
• Name any two examples of second-generation computers.
Diagram-Based Question
• Draw a neat block diagram of a computer and label its parts.
UNIT – 2: Computer Organization & Networking Fundamentals
Very Important Questions (Long Answer)
1. Explain the basic organization of a computer.
2. Explain functional components of a computer system.
3. Explain the memory hierarchy with a neat diagram.
4. Explain the types of computers:
5. Explain computer networks and their types of Networks.
6. Explain network topologies with diagrams:
Short Answer Questions
• Define computer organization.
• What is primary memory?
• Difference between RAM and ROM.
• Define LAN.
• What is a network topology?
• Define IP address.
• What is a domain name?
• What is a web browser?
Comparison Questions
• LAN vs WAN
• RAM vs ROM
• Microcomputer vs Supercomputer
UNIT – 3: Word Processing & Presentations
Important Long Answer Questions
1. Explain word processing and its features.
2. Explain formatting in MS Word (fonts, paragraphs, styles).
3. Explain mail merge with steps.
4. Explain presentation tools and features of PowerPoint.
5. Explain animations and transitions in presentations.
6. Explain the applications of word processing in:
o Resume
o Reports
o Brochures
Short Answer Questions
• What is mail merge?
• What are styles in MS Word?
• What is a slide layout?
• Define transition.
• Define animation.
Keyboard Shortcut Questions (Very Important)
• Ctrl + C
• Ctrl + V
• Ctrl + X
• Ctrl + B
• Ctrl + I
• Ctrl + U
• Ctrl + S
• Ctrl + P
UNIT – 4: Spreadsheet Basics
Very Important Long Answer Questions
1. Explain spreadsheet concepts.
2. Explain cell referencing with examples.
3. Explain functions and formulae with examples:
o SUM
o AVERAGE
o COUNT
o IF
4. Explain charts and graphs and their importance.
5. Explain data handling techniques in spreadsheets.
6. Explain text functions with examples.
7. Explain lookup functions:
o VLOOKUP
o HLOOKUP
o INDEX and MATCH
Short Answer Questions
• What is a cell?
• Define formula.
• What is conditional formatting?
• What is VLOOKUP?
• Difference between VLOOKUP and XLOOKUP.
Problem-Based Questions
• Write a formula to calculate total and average.
• Write an IF formula for pass/fail.
• Write syntax of VLOOKUP.
UNIT – 5: Data Analysis & Visualization
Very Important Long Answer Questions
1. Explain conditional formatting with examples.
2. Explain Pivot Tables and Pivot Charts.
3. Explain Data Validation and its types.
4. Explain What-If Analysis:
o Goal Seek
o Scenario Manager
o Data Tables
5. Explain interactive dashboards in Excel.
6. Explain slicers and their use.
7. Explain combo charts and sparklines.
8. Explain productivity tools:
o Named Ranges
o Freeze Panes
o Split View
Short Answer Questions
• What is a Pivot Table?
• What is Goal Seek?
• What are sparklines?
• Define data validation.
• What is a dashboard?
Most Repeated Exam Questions
Block Diagram of Computer Mail Merge
Generations of Computers IF and VLOOKUP functions
Number System Conversions Pivot Tables and Charts
LAN, MAN, WAN comparison Conditional Formatting