CBSE Class 10 IT (402) - Platinum Board Question Bank (Chapter-
Wise)
Status: Updated for 2025-26 Exam Pattern Structure: Unit-wise arrangement for 1M, 2M, and
4M. Note: CBSE IT 402 has NO 3-mark questions. Only 1, 2, and 4 Marks.
📑 INDEX / TABLE OF CONTENTS
Section Topic Page No.
Section A Objective Type (1 Mark) 1-3
• Unit 1: Digital Documentation (Writer) 1
• Unit 2: Electronic Spreadsheet (Calc) 2
• Unit 3: DBMS (Base & SQL) 2
• Unit 4: Web Applications & Security 3
• Unit 5: Employability Skills 3
Section B Short Answer (2 Marks) 4-5
• Unit 1: Writer 4
• Unit 2: Calc 4
• Unit 3: DBMS 5
• Unit 4: Web Apps 5
• Unit 5: Employability 5
Section C Competency / Long Answer (4 Marks) 6-7
• Unit 1: Writer (Steps & Scenarios) 6
• Unit 2: Calc (Scenarios & Tools) 6
• Unit 3: DBMS (SQL Queries) 7
• Unit 4: Web Apps (Case Studies) 7
Cheat Sheet Menu Map 8
🟢 SECTION A: OBJECTIVE TYPE (1 MARK)
Arranged Chapter-Wise.
Unit 1: Digital Documentation (Writer)
1. The ______ window shows available styles. [CBSE 2018] (Ans: Styles and Formatting)
2. ______ mode applies styles quickly to multiple areas. [CBSE 2020] (Ans: Fill Format)
3. Images can be added from ______ or file. [SQP 2021] (Ans: Gallery)
4. ______ is the reference point for graphics. [CBSE 2022] (Ans: Anchoring)
5. Change TOC background in ______ tab. [SQP 2023] (Ans: Background)
6. Default tab stop is ______. [CBSE 2019] (Ans: 0.5 inch)
7. ______ wrapping forms shape around image. [CBSE 2023] (Ans: Contour)
8. Mail Merge data source is usually a ______. [CBSE 2020] (Ans: Database)
9. A ______ is a set of formats. [CBSE 2018] (Ans: Style)
10. Drag text to ______ to create style. [SQP 2020] (Ans: Styles window)
11. ______ style controls paragraph layout. [CBSE 2021] (Ans: Paragraph)
12. ______ style controls font/size. [CBSE 2021] (Ans: Character)
13. ______ style controls page margins. [SQP 2022] (Ans: Page)
14. ______ combines letter with address list. [CBSE 2019] (Ans: Mail Merge)
15. ______ contains variable data. [CBSE 2024] (Ans: Data Source)
16. Update TOC: Right-click > ______. [SQP 2021] (Ans: Update Index)
17. Insert Table shortcut: ______. [CBSE 2019] (Ans: Ctrl+F12)
18. ______ handles rotate image. [CBSE 2020] (Ans: Red)
19. Sketch filter: ______. [SQP 2022] (Ans: Charcoal)
20. ______ is a document model. [CBSE 2018] (Ans: Template)
21. Writer template ext: ______. [CBSE 2021] (Ans: .ott)
22. Template Manager: ______. [SQP 2023] (Ans: Ctrl+Shift+N)
23. ______ copies styles from doc. [CBSE 2020] (Ans: Load Styles)
24. Anchor to keep image on page? [CBSE 2023] (a) To Page (b) To Para (Ans: a)
25. Mail Merge menu? [CBSE 2019] (Ans: Tools)
26. Select non-consecutive text: ______ key. [SQP 2020] (Ans: Ctrl)
27. ______ keeps object fixed relative to screen. [NCERT] (Ans: Frame)
28. Group objects: ______ > Group. [SQP 2024] (Ans: Format)
Unit 2: Electronic Spreadsheet (Calc)
29. ______ gathers data from sheets. [CBSE 2020] (Ans: Consolidation)
30. ______ is Goal Seek with constraints. [CBSE 2022] (Ans: Solver)
31. ______ tests "what-if" scenarios. [SQP 2023] (Ans: Scenarios)
32. Link cell from sheet: ______. [CBSE 2019] (Ans: Hyperlink)
33. ______ is saved commands. [CBSE 2024] (Ans: Macro)
34. Calc template ext: ______. [SQP 2021] (Ans: .ots)
35. Subtotals require ______ first. [CBSE 2021] (Ans: Sorting)
36. Ref Sheet2 A1: ______. [SQP 2020] (Ans: Sheet2.A1)
37. Hyperlinks types: ______ & ______. [CBSE 2023] (Ans: Absolute, Relative)
38. Macro language: ______. [CBSE 2022] (Ans: LibreOffice Basic)
39. ______ restricts input. [SQP 2024] (Ans: Data Validation)
40. Copy result only: ______. [CBSE 2020] (Ans: Paste Special)
41. Track Changes delete shows: ______. [SQP 2022] (Ans: Strikethrough)
42. Comment color: ______. [CBSE 2021] (Ans: Red)
43. Track Changes menu: ______. [CBSE 2019] (Ans: Edit)
44. ______ counts numbers. [SQP 2023] (Ans: COUNT)
45. ______ counts non-empty. [CBSE 2022] (Ans: COUNTA)
46. Solver menu? [SQP 2021] (a) Tools (b) Data (Ans: a)
47. Sum by category? [CBSE 2019] (a) Subtotal (b) Consolidate (Ans: a)
48. Macro library: ______. [CBSE 2024] (Ans: Standard)
49. Stop recording: Click ______. [SQP 2022] (Ans: Stop)
50. External Data format: ______. [CBSE 2020] (Ans: HTML/CSV)
51. Define Range menu: ______. [CBSE 2021] (Ans: Data)
52. Trace Precedents: ______ tool. [NCERT] (Ans: Detective)
Unit 3: DBMS (Base & SQL)
53. A ______ is collection of data. [CBSE 2018] (Ans: Database)
54. ______ manages databases. [CBSE 2019] (Ans: DBMS)
55. Data duplication: ______. [CBSE 2021] (Ans: Redundancy)
56. ______ identifies row uniquely. [CBSE 2020] (Ans: Primary Key)
57. ______ links tables. [CBSE 2022] (Ans: Foreign Key)
58. Retrieve command: ______. [SQP 2023] (Ans: SELECT)
59. Add row command: ______. [SQP 2020] (Ans: INSERT)
60. Modify record: ______. [CBSE 2023] (Ans: UPDATE)
61. Remove record: ______. [SQP 2022] (Ans: DELETE)
62. Modify structure: ______. [CBSE 2024] (Ans: ALTER)
63. Base ext: ______. [CBSE 2018] (Ans: .odb)
64. DB Language: ______. [CBSE 2020] (Ans: SQL)
65. Yes/No type: ______. [SQP 2021] (Ans: Boolean)
66. Data entry interface: ______. [SQP 2023] (Ans: Form)
67. Printable summary: ______. [CBSE 2022] (Ans: Report)
68. RDBMS uses ______. [CBSE 2019] (Ans: Tables)
69. Row: ______. [CBSE 2020] (Ans: Tuple)
70. Column: ______. [CBSE 2021] (Ans: Attribute)
71. No duplicate record rule: ______. [CBSE 2023] (Ans: Entity Integrity)
72. Long text type: ______. [CBSE 2021] (Ans: Memo)
73. DDL command? [CBSE 2023] (a) CREATE (b) INSERT (Ans: a)
74. DML command? [SQP 2024] (a) DELETE (b) ALTER (Ans: a)
75. Sort keyword? [CBSE 2020] (a) ORDER BY (b) SORT (Ans: a)
76. Check null: ______. [CBSE 2024] (Ans: IS NULL)
77. Default text type: ______. [CBSE 2019] (Ans: VARCHAR)
78. Design View key icon: ______. [CBSE 2020] (Ans: Primary Key)
79. Filter clause: ______. [CBSE 2022] (Ans: WHERE)
80. Data entry view: ______. [CBSE 2019] (Ans: Datasheet)
Unit 4: Web Applications & Security
81. ______ is user-friendliness. [CBSE 2018] (Ans: Accessibility)
82. ______ keys: press one by one. [CBSE 2020] (Ans: Sticky)
83. ______ keys: ignore repeats. [SQP 2021] (Ans: Filter)
84. ______ keys: visual cues. [CBSE 2019] (Ans: SoundSentry)
85. ______ keys: beep on lock. [CBSE 2021] (Ans: Toggle)
86. Small area network: ______. [CBSE 2018] (Ans: LAN)
87. Internet manners: ______. [SQP 2020] (Ans: Netiquette)
88. Disguised malware: ______. [CBSE 2023] (Ans: Trojan)
89. Fake email theft: ______. [CBSE 2022] (Ans: Phishing)
90. Access blocker: ______. [CBSE 2024] (Ans: Firewall)
91. Broadcast device: ______. [SQP 2022] (Ans: Hub)
92. Specific node device: ______. [SQP 2023] (Ans: Switch)
93. Network layout: ______. [CBSE 2021] (Ans: Topology)
94. DSL: ______. [CBSE 2019] (Ans: Digital Subscriber Line)
95. Wireless long range: ______. [CBSE 2020] (Ans: WiMAX)
96. Real-time chat: ______. [CBSE 2021] (Ans: IM)
97. Online journal: ______. [SQP 2021] (Ans: Blog)
98. Offline editor: ______. [CBSE 2022] (Ans: Qumana)
99. Secure site: ______. [CBSE 2023] (Ans: HTTPS)
100. Hand injury: ______. [CBSE 2019] (Ans: RSI)
101. Eye strain rule: ______. [SQP 2020] (Ans: 20-20-20)
102. Fire escape: ______. [CBSE 2021] (Ans: Stairs)
103. Unforeseen damage: ______. [CBSE 2024] (Ans: Accident)
104. Digital-Analog converter: ______. [CBSE 2018] (Ans: Modem)
105. City network: ______. [SQP 2022] (Ans: MAN)
106. Web protocol: ______. [CBSE 2020] (Ans: HTTP)
107. Strong Pass: ______. [SQP 2023] (Ans: P@ssw0rd1)
Unit 5: Employability Skills
108. ______ feedback improves. [CBSE 2019] (Ans: Descriptive)
109. ______ is positive stress. [SQP 2020] (Ans: Eustress)
110. ______ is creating business. [CBSE 2018] (Ans: Entrepreneurship)
111. ______ meets needs safely. [CBSE 2022] (Ans: Sustainable Dev)
112. ______ is open source OS. [SQP 2023] (Ans: Linux)
113. ______ listening is attentive. [SQP 2024] (Ans: Active)
114. 3 R's: ______. [CBSE 2019] (Ans: Reduce, Reuse, Recycle)
115. ______: belief in self. [CBSE 2021] (Ans: Self-Confidence)
116. Language barrier: ______. [SQP 2022] (Ans: Linguistic)
117. Noise barrier: ______. [CBSE 2023] (Ans: Physical)
118. Regulate emotions: ______. [CBSE 2024] (Ans: Emotional Intelligence)
119. Solar is ______. [SQP 2021] (Ans: Renewable)
120. Coal is ______. [CBSE 2018] (Ans: Non-renewable)
121. ______ motivation from inside. [CBSE 2021] (Ans: Intrinsic)
🟡 SECTION B: SHORT ANSWER TYPE (2 MARKS)
Arranged Chapter-Wise.
Unit 1: Digital Documentation (Writer)
122. "Link" vs "Embed" image. [CBSE 2023]
Link: Path only. Small file. Dependent.
Embed: Copy image. Large file. Independent.
123. What are handles? [CBSE 2019]
Green/Blue squares on image border.
Used to resize (Corner: Diagonal, Side: Width/Height).
124. Styles Types. [CBSE 2019]
Paragraph, Character, Page, Frame, List.
125. What is Template? [CBSE 2020]
Pre-designed model. Ensures formatting consistency.
126. Anchoring. [CBSE 2022]
Reference point (Page/Para/Char). Determines how image moves.
Unit 2: Electronic Spreadsheet (Calc)
127. "Goal Seek" vs "Solver". [CBSE 2022]
Goal Seek: One variable, exact value, backward calc.
Solver: Multiple variables, constraints, optimization.
128. Relative Hyperlink. [CBSE 2020]
Path relative to current file. Works if folder moves.
129. Share Document. [CBSE 2024]
Multi-user simultaneous editing. Collaboration.
130. Detective Tools. [NCERT]
Trace Precedents: Arrows to cells affecting current.
Trace Dependents: Arrows to cells affected by current.
131. Hyperlink in Calc. [CBSE 2023]
Jump to cell/sheet/web. Internal or External.
132. Data Validation. [CBSE 2024]
Restricts input (e.g., Num 1-100). Reduces errors.
Unit 3: DBMS (Base)
133. Referential Integrity. [CBSE 2020]
Relationship consistency. No orphan records (FK matches PK).
134. Memo vs Varchar. [CBSE 2022]
Varchar: Short variable text (Names).
Memo: Long descriptive text (Articles).
135. Primary Key. [CBSE 2019]
Unique ID. No Nulls. No Duplicates.
136. Report vs Form. [SQP 2023]
Form: Interface for data entry.
Report: Printable summary of data.
137. Flat vs Relational DB. [SQP 2021]
Flat: Single table, redundancy.
Relational: Linked tables, consistency.
138. DBMS Advantages. [CBSE 2018]
Less Redundancy, High Security, Data Sharing.
Unit 4: Web Applications & Security
139. Blog vs IM. [CBSE 2020]
Blog: Asynchronous, public, diary.
IM: Real-time, private, chat.
140. Toggle Key. [CBSE 2021]
Sound cue for locking keys (Caps Lock). For visually impaired.
141. Packet Switching. [CBSE 2020]
Data broken into packets. Travel independently. Reassembled.
142. Sticky Keys. [SQP 2022]
Press combination keys sequentially. For physical disability.
143. LAN vs WAN. [CBSE 2018]
LAN: Small area, fast. WAN: Large area, internet.
144. Workplace Evacuation. [CBSE 2021]
Moving to assembly point. Critical for fire safety.
145. Netiquette. [SQP 2020]
Internet manners. No spam/bullying.
146. Phishing. [CBSE 2021]
Fake emails stealing passwords.
147. Wi-Fi. [CBSE 2019]
Wireless Fidelity. Radio wave internet.
148. Modem. [CBSE 2022]
Modulator-Demodulator. Connects PC to ISP.
149. Switch vs Hub. [SQP 2021]
Switch: Smart, sends to destination.
Hub: Dumb, broadcasts to all.
150. Offline Blog Editor. [CBSE 2019]
Write without internet. Publish later. Ex: Qumana.
151. Star Topology. [SQP 2024]
Nodes connected to central Hub. Hub fail = Network fail.
152. Antivirus. [CBSE 2023]
Protects from malware. Ex: Norton.
153. Strong Password. [CBSE 2021]
Mix Upper/Lower/Num/Symbol. Length > 8.
Unit 5: Employability Skills (2 Marks Only)
154. Types of Motivation. [CBSE 2021]
Intrinsic: Internal desire.
Extrinsic: External reward.
155. Green Skills List. [SQP 2023]
Waste Management, Water Conservation.
156. Sustainable Development. [CBSE 2020]
Meeting needs without harming future.
157. Barriers to Communication. [CBSE 2019]
Physical, Linguistic, Cultural, Emotional.
🔵 SECTION C: COMPETENCY & LONG ANSWER (4 MARKS)
Arranged Chapter-Wise.
Unit 1: Digital Documentation (Writer)
158. [Scenario] Mail Merge: [CBSE 2020]
Q: Send letter to 500 parents.
Ans: Feature: Mail Merge. Component 1: Main Document (Letter). Component 2: Data
Source (Address List).
159. [Steps] Table of Contents: [CBSE 2019]
1. Apply Heading Styles (H1, H2).
2. Insert > TOC & Index.
3. Click OK.
160. [Steps] Crop Image: [SQP 2021]
1. Right-click Image > Picture.
2. Crop Tab.
3. Set Left/Right/Top/Bottom values.
161. [Scenario] Mouse Keys: [CBSE 2021]
Q: Mouse broken, user needs to move pointer.
Ans: Enable Mouse Keys. Use NumPad to control pointer.
Unit 2: Electronic Spreadsheet (Calc)
162. [Scenario] Goal Seek: [SQP 2023]
Q: Find Math marks for 90% avg.
Ans: Tool: Goal Seek. Set Cell: Avg. To Value: 90. Change Cell: Math.
163. [Scenario] Calc Tool Choice: [SQP 2022]
Q: (a) Reverse calc? (b) Max profit with constraints?
Ans: (a) Goal Seek. (b) Solver.
164. [Steps] Consolidate Data: [SQP 2023]
1. Data > Consolidate.
2. Select Function (Sum).
3. Add Source Ranges.
4. OK.
165. [Steps] Record Macro: [CBSE 2022]
1. Tools > Macros > Record.
2. Perform actions.
3. Stop Recording.
4. Save/Name Macro.
166. [Steps] Link External Data: [CBSE 2021]
1. Sheet > Link External Data.
2. Enter URL.
3. Select Table.
4. OK.
Unit 3: DBMS (Base & SQL) - Critical for 4 Marks
167. [SQL] Query Set A: [CBSE 2022]
Q1: Filter Marks > 80: SELECT * FROM Students WHERE Marks > 80;
Q2: Filter City 'Delhi': SELECT Name, City FROM Students WHERE City = 'Delhi';
Q3: Delete ID 10: DELETE FROM Students WHERE RollNo = 10;
Q4: Update City: UPDATE Students SET City = 'Mumbai' WHERE Name = 'Ravi';
168. [SQL] Query Set B: [SQP 2024]
Q1: Sort Descending: SELECT * FROM Students ORDER BY Name DESC;
Q2: Insert Row: INSERT INTO Students VALUES (1, 'Amit', 90);
Q3: Show Distinct: SELECT DISTINCT City FROM Students;
Q4: Delete All Rows: DELETE FROM Students;
169. [SQL] Query Set C (Pattern & Logic): [NCERT]
Q1: Start with 'A': SELECT * FROM Students WHERE Name LIKE 'A%';
Q2: Range 80-90: SELECT * FROM Students WHERE Marks BETWEEN 80 AND 90;
Q3: Delhi OR Mumbai: SELECT * FROM Students WHERE City = 'Delhi' OR City =
'Mumbai';
Q4: Create Table: CREATE TABLE Items (ID Integer PRIMARY KEY, Name
Varchar(50));
170. [Steps] Create Report: [SQP 2022]
1. Use Wizard. 2. Select Query. 3. Add Grouping. 4. Finish.
171. [Steps] Create Form: [CBSE 2020]
1. Use Wizard. 2. Select Table. 3. Choose Layout. 4. Finish.
Unit 4: Web Applications & Security
172. [Case Study] Impairments: [CBSE 2019]
Q1: Can't hear beep -> SoundSentry.
Q2: Hand tremors -> Filter Keys.
Q3: Single hand typing -> Sticky Keys.
Q4: Blindness -> Screen Reader.
173. [Descriptive] Best Password Practices: [CBSE 2023]
1. Length > 8.
2. Mix Alpha/Num/Symbol.
3. No Dictionary words.
4. Change often.
174. [Descriptive] Instant Messaging: [CBSE 2020]
Features: Text, Audio/Video, Files, History.
Types: App-based (WhatsApp), Web-based (Skype Web).
⚡ EXAM DAY CHEAT SHEET: MENU MAP
Memorize which command is in which Menu (LibreOffice).
FILE: Templates, Print, Export PDF
EDIT: Track Changes, Find & Replace
VIEW: Toolbars, Data Sources (F4)
INSERT: Image, TOC, Hyperlink, Header/Footer
FORMAT: Page/Para/Char Style, Group, Anchor, Wrap
STYLES: Manage Styles (F11), Load Styles
TOOLS: Mail Merge, Solver, Goal Seek, Macros, Spelling (F7)