Practice Questions

Test yourself, then check the answers below. Questions 12 to 22 use the sample sheet.

1. Which generation of computers used microprocessors?
2. What is 45 in binary?
3. What is binary 10110111 in hexadecimal?
4. Which logic gate gives 1 only when its two inputs are different?
5. Which memory is volatile: RAM or ROM?
6. At which OSI layer does a router work?
7. What is the default port of HTTPS?
8. Which protocol is used to send email?
9. Which malware self-replicates without a host file?
10. Which section of the IT Act deals with identity theft?
11. What is the shortcut for AutoSum?
12. What does =COUNTIF(C2:C9,">=60") return?
13. What does =SUMIF(B2:B9,"Jammu",C2:C9) return?
14. What does =MEDIAN(C2:C9) return?
15. What does =LEFT("JKEdusphere",2)&RIGHT("JKEdusphere",4) return?
16. What does =INT(-4.5) return?
17. What does =2+3*4^2 return?
18. What does =WEEKDAY(DATE(2026,10,21),2) return?
19. What is the sign of =PMT(9%/12,60,500000), and why?
20. What does =ROUND(1234,-2) return?
21. Which function returns the position of a value in a range?
22. In =VLOOKUP("Eram",A2:D9,2,FALSE), what is returned?
23. Which SQL clause filters groups?
24. Which key links a table to another table's primary key?
25. Which normal form removes partial dependency?
26. How many rows does an Excel worksheet have?
27. Which chart is best for showing a trend over time?
28. Who invented the World Wide Web?
29. How many bits does IPv6 use?
30. Which pointing device did Douglas Engelbart invent?

Answers

1. Fourth generation.
2. 101101.
3. B7.
4. XOR.
5. RAM.
6. Network layer (layer 3).
7. 443.
8. SMTP.
9. Worm.
10. Section 66C.
11. Alt + =.
12. 6 (all except 55 and 40).
13. 228 (65 + 92 + 71).
14. 74.5 (average of 71 and 78).
15. JKhere.
16. -5.
17. 50 (power first: 4^2 = 16, then 3 × 16 = 48, then 2 + 48).
18. 3 (Wednesday, with Monday as 1).
19. Negative, because the payment is money going out. The amount is about -10,379.18 a month.
20. 1200.
21. MATCH.
22. Srinagar (column 2, District).
23. HAVING.
24. Foreign key.
25. Second normal form (2NF).
26. 1,048,576.
27. Line chart.
28. Tim Berners-Lee.
29. 128 bits.
30. The mouse.

Practise with our free tests at JKEdusphere.