CBSE Class 10 Information Technology (402) Sample Paper 6 - 2026-27

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

CBSE Sample Practice Paper — 6  (Session 2026–27)

Class: X (10th)

Subject: Information Technology — Code: 402

Time: 2 Hours

Max. Marks: 50

Student Name: ______________________

Roll No.: __________

Section: __________

General Instructions:

1. This paper is divided into two parts — Part A: Employability Skills (10 Marks), and Part B: Subject Specific Skills (40 Marks).

2. Part B is further divided into three sections: Section 1 — Objective Type/MCQ (10 Marks), Section 2 — Short Answer (10 Marks), Section 3 — Long Answer (20 Marks).

3. All questions are compulsory. Marks for each question are indicated against it.

4. Write short and precise answers wherever asked.

PART A — EMPLOYABILITY SKILLS  (10 Marks)

Choose the correct option for each of the following questions: 10 × 1 = 10

Q1. Which of the following is a barrier to effective communication?

(A) Clear language(B) Noise or distractions during conversation(C) Active listening(D) Appropriate body language

Q2. "Prioritisation" as a time-management technique means:

(A) Doing all tasks simultaneously(B) Arranging tasks in order of importance/urgency and tackling them accordingly(C) Ignoring less important tasks entirely(D) Working randomly without a plan

Q3. Which of the following is an example of cloud computing/storage?

(A) Storing files on Google Drive(B) Saving a file only to a local hard disk(C) Printing a document(D) Using a landline telephone

Q4. Which of the following best describes "innovation" in entrepreneurship?

(A) Copying an existing business model exactly(B) Introducing new ideas, methods or products that create value(C) Avoiding any change(D) Reducing product quality to cut costs

Q5. Which of the following contributes to a "sustainable" workplace practice?

(A) Reducing paper usage by digitising records(B) Using excessive packaging materials(C) Discarding electronic waste in regular trash(D) Ignoring energy consumption

Q6. "Empathy" in interpersonal skills refers to:

(A) Ignoring others' feelings(B) The ability to understand and share the feelings of another person(C) Criticising others openly(D) Avoiding social interactions

Q7. Which of the following is considered good workplace etiquette?

(A) Being punctual and respectful to colleagues(B) Interrupting meetings frequently(C) Ignoring deadlines(D) Using inappropriate language at work

Q8. Which of the following is an example of an "occupational hazard"?

(A) A comfortable office chair(B) Risk of eye strain from prolonged computer use(C) A well-lit workspace(D) Regular breaks during work

Q9. A "resume" or "CV" is primarily used to:

(A) Record daily expenses(B) Summarise a person's education, skills and work experience for job applications(C) Store personal photographs(D) List favourite hobbies only

Q10. Which of the following is an example of "phishing" in cyber security?

(A) Regularly updating antivirus software(B) A fraudulent email/message designed to trick users into revealing personal information(C) Using a strong password(D) Enabling two-factor authentication

PART B — SUBJECT SPECIFIC SKILLS  (40 Marks)

Section 1 — Objective Type Questions  (1 Mark each) — Q11 to Q20

Q11. Which feature in a word processor is used to check the total number of words, characters and pages in a document?

(A) Word Count(B) Spell Check(C) Mail Merge(D) Thesaurus

Q12. Which LibreOffice Calc function checks a logical condition and returns one value if true, another if false?

(A) SUM()(B) IF()(C) COUNT()(D) AVERAGE()

Q13. In a database, which of the following is used to establish a link between two related tables?

(A) A report(B) A relationship(C) A macro(D) A form

Q14. Which option in LibreOffice Impress allows slides to advance automatically after a set time interval?

(A) Manual advance(B) Automatic slide timing(C) Rehearse Timings/Automatic after(D) Slide deletion

Q15. Which of the following is used in a spreadsheet to display data as a visual summary using bars, lines or pie segments?

(A) Table(B) Chart(C) Form(D) Filter

Q16. Which feature in a word processor allows text to automatically move to the next line when it reaches the page margin?

(A) Word Wrap(B) Page Break(C) Column Break(D) Text Box

Q17. A table that stores only unique, non-duplicate values in its primary key column enforces:

(A) Referential integrity only(B) Entity integrity(C) Data redundancy(D) None of these

Q18. Which of the following is used to insert an audio or video clip into a slide in LibreOffice Impress?

(A) Insert → Audio or Video(B) Format → Slide Layout(C) View → Normal(D) Tools → Options

Q19. What does the term "cell range" refer to in a spreadsheet?

(A) A single cell only(B) A group of two or more contiguous (adjacent) cells(C) The entire spreadsheet(D) A chart object

Q20. Which of the following is the correct hierarchy of organisation in a typical database, from largest to smallest?

(A) Database → Table → Record → Field(B) Field → Record → Table → Database(C) Table → Database → Field → Record(D) Record → Field → Database → Table

--- Continued on next page ---

Page 1 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

Section 2 — Short Answer Questions  (2 Marks each) — Q21 to Q25

Q21. What is "Word Wrap" in a word processing document? Why is it useful? 2

Q22. Explain the purpose of the IF() function in a spreadsheet, with a simple example. 2

Q23. What is meant by "Entity Integrity" in a database? 2

Q24. What is the purpose of "Rehearse Timings" in a presentation? 2

Q25. Differentiate between a "cell" and a "cell range" in a spreadsheet. 2

Section 3 — Long Answer Questions  (4 Marks each) — Q26 to Q30

Q26. Explain the steps to insert and format a bulleted or numbered list in a LibreOffice Writer document. 4

Q27. Explain the concept of a "nested IF" function in a spreadsheet, and describe a situation where it would be useful, with an example. 4

Q28. What is the importance of establishing relationships between tables in a relational database? Explain with reference to a simple example involving a "Students" table and a "Marks" table. 4

Q29. Explain the steps to add and customise a "Slide Transition" effect for slides in LibreOffice Impress. 4

Q30. What is meant by "print preview" and "page setup" in office applications? Explain their importance before printing a document. 4

--- End of Question Paper --- All the best! ---

Page 2 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

Answer Key & Marking Scheme (Key Points)

PART A — EMPLOYABILITY SKILLS

Q	Ans	Q	Ans
1	(B)	6	(B)
2	(B)	7	(A)
3	(A)	8	(B)
4	(B)	9	(B)
5	(A)	10	(B)

PART B — SUBJECT SPECIFIC SKILLS

Section 1 — Answer Key

Q	Ans	Q	Ans
11	(A) Word Count	16	(A) Word Wrap
12	(B) IF()	17	(B) Entity integrity
13	(B) A relationship	18	(A) Insert → Audio or Video
14	(C) Rehearse Timings	19	(B) Group of adjacent cells
15	(B) Chart	20	(A) Database→Table→Record→Field

Section 2 — Key Answers

Q21. Word Wrap automatically moves text to the beginning of the next line once it reaches the right margin of the page, without the user needing to press Enter manually; it is useful because it allows continuous typing while keeping the text neatly contained within the page margins.

Q22. The IF() function tests a given condition and returns one specified value if the condition is true, and another if it is false; for example, =IF(B2>=33,"Pass","Fail") displays "Pass" if the value in B2 is 33 or more, and "Fail" otherwise.

Q23. Entity Integrity ensures that the primary key field of a table always contains a unique, non-null value for every record, guaranteeing that each record in the table can be distinctly identified.

Q24. Rehearse Timings allows the presenter to practise delivering a presentation while the software records how long each slide is displayed; these recorded timings can then be used to automatically advance the slides at the same pace during the actual presentation.

Q25. A cell is a single, individual box formed by the intersection of a row and a column (e.g., B3); a cell range is a group of two or more adjacent cells treated together, referred to using the first and last cell separated by a colon (e.g., B3:B10).

Section 3 — Key Answers

Q26. Steps: (1) Select the text/paragraphs to be converted into a list. (2) Go to the Bullets and Numbering options in the toolbar (or Format → Bullets and Numbering menu). (3) Choose the desired bullet style or numbering format. (4) Click Apply/OK, after which the selected text is displayed as a bulleted or numbered list. (5) Further formatting (indentation, list style) can be adjusted using the same dialog box if needed.

Q27. A nested IF function is an IF() function placed inside another IF() function, allowing multiple conditions to be tested in sequence, useful when there are more than two possible outcomes; for example, =IF(B2>=90,"A Grade",IF(B2>=75,"B Grade","C Grade")) assigns grades based on multiple score ranges rather than just a simple pass/fail.

Q28. Relationships between tables (e.g., linking a "Students" table's StudentID field to a "Marks" table's StudentID field) prevent data duplication, ensure that data (like each student's details) is stored only once, and allow related information (like a student's marks) to be retrieved together accurately through queries, maintaining consistency between the tables.

Q29. Steps: (1) Select the desired slide(s) in Slide Sorter or Normal view. (2) Go to Slide → Slide Transition (or the Transition panel/tab). (3) Choose a transition effect (e.g., Fade, Wipe) from the available list. (4) Adjust the speed/duration and sound (if any) for the transition. (5) Choose whether to apply the transition to the selected slide only or to all slides, and confirm.

Q30. Print Preview shows how the document/spreadsheet/presentation will actually appear when printed, without using paper, allowing the user to check formatting and layout beforehand; Page Setup allows adjustment of settings like paper size, orientation (portrait/landscape) and margins. Checking both before printing helps avoid wasted paper/ink from incorrectly formatted printouts and ensures the final output looks as intended.

This sample paper and answer key are prepared for CBSE Class X Information Technology (Code 402) practice, Session 2026–27.

Page 3 of 3 (Answer Key)  |  www.careerinformationportal.in

CBSE Class 10 Information Technology (402) Sample Paper 5 - 2026-27

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

CBSE Sample Practice Paper — 5  (Session 2026–27)

Class: X (10th)

Subject: Information Technology — Code: 402

Time: 2 Hours

Max. Marks: 50

Student Name: ______________________

Roll No.: __________

Section: __________

General Instructions:

1. This paper is divided into two parts — Part A: Employability Skills (10 Marks), and Part B: Subject Specific Skills (40 Marks).

2. Part B is further divided into three sections: Section 1 — Objective Type/MCQ (10 Marks), Section 2 — Short Answer (10 Marks), Section 3 — Long Answer (20 Marks).

3. All questions are compulsory. Marks for each question are indicated against it.

4. Write short and precise answers wherever asked.

PART A — EMPLOYABILITY SKILLS  (10 Marks)

Choose the correct option for each of the following questions: 10 × 1 = 10

Q1. Which of the following is an example of formal communication in a workplace?

(A) Casual chat with a friend(B) An official memo or report(C) Gossip(D) A personal social media post

Q2. "Self-awareness" as a self-management skill means:

(A) Ignoring one's own strengths and weaknesses(B) Understanding one's own emotions, strengths, weaknesses and values(C) Only focusing on others' opinions(D) Avoiding self-reflection

Q3. Which of the following is an example of an ICT device used for communication?

(A) Smartphone(B) Stapler(C) Offline calculator(D) Whiteboard

Q4. Market research before starting a business helps an entrepreneur to:

(A) Avoid understanding customer needs(B) Understand customer needs and assess business viability(C) Increase costs unnecessarily(D) Skip planning

Q5. Which of the following represents a "carbon footprint" reduction practice?

(A) Using public transport or carpooling(B) Using private vehicles for every short trip(C) Wasting electricity(D) Burning waste in open areas

Q6. Conflict resolution skills help in:

(A) Avoiding all conflicts by ignoring problems(B) Resolving disagreements constructively and maintaining relationships(C) Making conflicts worse(D) Blaming others without discussion

Q7. Which of these is an example of a "hard skill"?

(A) Communication(B) Typing/data entry speed(C) Leadership(D) Teamwork

Q8. Time management involves:

(A) Doing all tasks at the last minute(B) Prioritising tasks and planning how time is spent(C) Ignoring deadlines(D) Avoiding planning altogether

Q9. An "elevator pitch" is:

(A) A long, detailed business plan(B) A brief, persuasive speech to spark interest in an idea/business(C) A type of resume(D) A formal legal document

Q10. Cyber safety practices include:

(A) Sharing passwords with strangers(B) Using strong, unique passwords and being cautious with personal information online(C) Clicking on all links received via email(D) Ignoring software updates

PART B — SUBJECT SPECIFIC SKILLS  (40 Marks)

Section 1 — Objective Type Questions  (1 Mark each) — Q11 to Q20

Q11. Which feature in a word processor allows the automatic checking and correction of spelling errors?

(A) Spell Check(B) Mail Merge(C) Track Changes(D) Word Count

Q12. In LibreOffice Calc, which function is used to find the smallest value in a range of cells?

(A) MAX()(B) MIN()(C) SMALL()(D) LOW()

Q13. Which of the following is a valid data type commonly used for storing numeric values in a database field?

(A) Text(B) Number/Integer(C) Memo(D) Hyperlink

Q14. Which of the following allows a presenter to display a presentation on one screen while viewing notes on another?

(A) Slide Show mode(B) Presenter view(C) Outline view(D) Handout view

Q15. Which of the following is used to combine two or more cells into a single cell in a spreadsheet?

(A) Split Cells(B) Merge Cells(C) Freeze Cells(D) Format Cells

Q16. In a document, "Track Changes" is used to:

(A) Delete the document permanently(B) Record edits made by different users for review before accepting/rejecting them(C) Print the document(D) Change the page orientation

Q17. Which term describes the situation where the same data is unnecessarily stored multiple times in a database?

(A) Data integrity(B) Data redundancy(C) Data normalization(D) Data query

Q18. Which file format is native to LibreOffice Impress presentations?

(A) .odp(B) .odt(C) .ods(D) .odb

Q19. What is the purpose of "Freeze Rows/Columns" in a spreadsheet?

(A) To delete rows and columns(B) To keep specific rows/columns visible while scrolling through large data(C) To hide all data(D) To sort data alphabetically

Q20. Which of the following database objects is used to present data in a formatted, printable layout?

(A) Table(B) Form(C) Report(D) Query

--- Continued on next page ---

Page 1 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

Section 2 — Short Answer Questions  (2 Marks each) — Q21 to Q25

Q21. What is the purpose of the "Spell Check" feature in a word processor? Explain briefly. 2

Q22. What is meant by "data normalization" in a database? Why is it important? 2

Q23. Explain the difference between a "Form" and a "Report" in a database application. 2

Q24. What is the use of the "Freeze Panes" feature in a spreadsheet? 2

Q25. What are "Speaker Notes" in a presentation, and why are they useful? 2

Section 3 — Long Answer Questions  (4 Marks each) — Q26 to Q30

Q26. Explain the steps to protect a document with a password in LibreOffice Writer, and discuss why this feature is important. 4

Q27. Explain the concept of "filtering" data in a spreadsheet. Describe the steps to apply AutoFilter to a range of data. 4

Q28. What is meant by "normalization" in database design? Briefly explain the first three normal forms (1NF, 2NF, 3NF) with simple examples. 4

Q29. Explain the steps to insert and format a table (rows and columns) within a slide in LibreOffice Impress. 4

Q30. What are "templates" in office applications (word processor, spreadsheet, presentation)? Explain their advantages with an example. 4

--- End of Question Paper --- All the best! ---

Page 2 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

Answer Key & Marking Scheme (Key Points)

PART A — EMPLOYABILITY SKILLS

Q	Ans	Q	Ans
1	(B)	6	(B)
2	(B)	7	(B)
3	(A)	8	(B)
4	(B)	9	(B)
5	(A)	10	(B)

PART B — SUBJECT SPECIFIC SKILLS

Section 1 — Answer Key

Q	Ans	Q	Ans
11	(A) Spell Check	16	(B) Record edits for review
12	(B) MIN()	17	(B) Data redundancy
13	(B) Number/Integer	18	(A) .odp
14	(B) Presenter view	19	(B) Keep rows/columns visible
15	(B) Merge Cells	20	(C) Report

Section 2 — Key Answers

Q21. Spell Check automatically scans the document text and identifies possible spelling errors, suggesting corrections, helping ensure the document is free of typing/spelling mistakes before finalising it.

Q22. Data normalization is the process of organising data in a database to reduce redundancy and improve data integrity, typically by dividing large tables into smaller, related tables; it is important because it prevents inconsistent/duplicate data and makes the database more efficient to maintain.

Q23. A Form provides a user-friendly interface for entering, viewing and editing data in a database (usually one record at a time); a Report is used to present and print selected data in a formatted, organised layout, often for summarising or sharing information, but is not typically used for direct data entry.

Q24. Freeze Panes keeps specific rows and/or columns (e.g., header rows) fixed and visible on screen while the user scrolls through the rest of a large spreadsheet, making it easier to reference column/row labels for distant data.

Q25. Speaker Notes are additional text notes attached to each slide, visible only to the presenter (not the audience), used to remind the presenter of key points, explanations, or reminders to mention while delivering that particular slide.

Section 3 — Key Answers

Q26. Steps: (1) Open the document in LibreOffice Writer. (2) Go to File → Save As (or File → Properties, depending on version) and look for security/password options, or use File → Save As and check "Save with password". (3) Enter and confirm the desired password. (4) Save the file. This feature is important as it restricts unauthorised access to sensitive or confidential documents, ensuring only people with the password can open/view the content.

Q27. Filtering allows the user to temporarily display only rows of data that meet specific criteria, hiding the rest, without permanently altering the data. Steps for AutoFilter: (1) Select the data range including headers. (2) Go to Data → AutoFilter. (3) Drop-down arrows appear on each header; click the arrow for the desired column. (4) Select the specific value(s) or condition to filter by, and the spreadsheet displays only matching rows.

Q28. Normalization organises data to minimise redundancy and dependency issues. 1NF: eliminates repeating groups, ensuring each field contains only atomic (single) values (e.g., splitting a "Subjects" field containing multiple subjects into separate rows). 2NF: builds on 1NF, ensuring all non-key fields depend on the entire primary key (relevant for composite keys). 3NF: builds on 2NF, ensuring non-key fields do not depend on other non-key fields (removing transitive dependencies), such as separating a "City" and "Pincode" that depend on each other into a related table.

Q29. Steps: (1) Select the slide where the table is needed. (2) Go to Insert → Table. (3) Specify the required number of rows and columns in the dialog box, and click Insert/OK. (4) Click into individual cells to type the required data. (5) Use the Table toolbar/properties to format the table — adjusting borders, cell colours, and column widths as needed.

Q30. Templates are pre-designed layouts (with formatting, structure and sometimes placeholder content) that can be used as a starting point for creating new documents, spreadsheets, or presentations; advantages include saving time, ensuring visual consistency, and providing a professional look without designing from scratch — for example, using a pre-made invoice template in a spreadsheet application instead of building one from an empty sheet each time.

This sample paper and answer key are prepared for CBSE Class X Information Technology (Code 402) practice, Session 2026–27.

Page 3 of 3 (Answer Key)  |  www.careerinformationportal.in

CBSE Class 10 Information Technology (Code 402) Sample Paper – 4 (2026–27)

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

CBSE Sample Practice Paper — 4  (Session 2026–27)

Class: X (10th)

Subject: Information Technology — Code: 402

Time: 2 Hours

Max. Marks: 50

Student Name: ______________________

Roll No.: __________

Section: __________

General Instructions:

1. This paper is divided into two parts — Part A: Employability Skills (10 Marks), and Part B: Subject Specific Skills (40 Marks).

2. Part B is further divided into three sections: Section 1 — Objective Type/MCQ (10 Marks), Section 2 — Short Answer (10 Marks), Section 3 — Long Answer (20 Marks).

3. All questions are compulsory. Marks for each question are indicated against it.

4. Write short and precise answers wherever asked.

PART A — EMPLOYABILITY SKILLS  (10 Marks)

Choose the correct option for each of the following questions: 10 × 1 = 10

Q1. Which of the following best describes "active listening"?

(A) Interrupting the speaker frequently(B) Paying full attention and responding appropriately to the speaker(C) Only hearing without understanding(D) Thinking about your reply while the other person speaks

Q2. Setting SMART goals means goals should be:

(A) Specific, Measurable, Achievable, Realistic, Time-bound(B) Simple, Manageable, Achievable, Reliable, Testable(C) Specific, Manageable, Actionable, Realistic, Timely(D) None of these

Q3. Which of the following is an example of a computer input device used in ICT?

(A) Monitor(B) Printer(C) Scanner(D) Speaker

Q4. A business plan is primarily useful for:

(A) Decorating an office(B) Outlining the goals and strategy of a business venture(C) Hiring employees only(D) Filing taxes

Q5. Which of the following is an example of a green practice at a workplace?

(A) Printing every document unnecessarily(B) Using energy-efficient lighting and recycling paper(C) Leaving computers on overnight(D) Using single-use plastic extensively

Q6. Emotional intelligence includes the ability to:

(A) Ignore others' feelings(B) Understand and manage one's own and others' emotions(C) Avoid all emotional situations(D) Only express anger effectively

Q7. Which of the following is a characteristic of good teamwork?

(A) Working in isolation(B) Sharing responsibilities and communicating openly with team members(C) Avoiding all group discussions(D) Taking credit for others' work

Q8. "Stress management" techniques can include:

(A) Ignoring the problem completely(B) Practising relaxation techniques and time management(C) Working continuously without breaks(D) Avoiding all forms of communication

Q9. Which of these best describes a "career pathway"?

(A) A single, fixed job for life(B) A sequence of jobs/experiences that leads towards a career goal(C) A random selection of unrelated jobs(D) A physical path to the workplace

Q10. "Digital footprint" refers to:

(A) The physical space taken by a computer(B) The trail of data a person leaves while using digital devices and the internet(C) A type of keyboard shortcut(D) A printer's ink usage

PART B — SUBJECT SPECIFIC SKILLS  (40 Marks)

Section 1 — Objective Type Questions  (1 Mark each) — Q11 to Q20

Q11. Which shortcut key is commonly used to insert a hyperlink in a document?

(A) Ctrl+K(B) Ctrl+H(C) Ctrl+L(D) Ctrl+U

Q12. In LibreOffice Calc, which function returns the number of numeric cells in a range?

(A) SUM()(B) COUNT()(C) COUNTA()(D) AVERAGE()

Q13. In a database, a "query" is used to:

(A) Design a table structure(B) Retrieve specific data from one or more tables based on given criteria(C) Print a report(D) Create a new database file

Q14. Which view is used to add speaker notes to a slide in LibreOffice Impress?

(A) Normal view(B) Notes view(C) Slide Sorter view(D) Handout view

Q15. Which of the following is a text-wrapping option available for images inserted in a word processor document?

(A) Bold(B) Square/Wrap around(C) Italic(D) Underline

Q16. In a spreadsheet, which operator is used for exponentiation (power)?

(A) *(B) /(C) ^(D) %

Q17. Which term refers to a set of rules that ensures the accuracy and consistency of data in a database?

(A) Data redundancy(B) Data integrity(C) Data duplication(D) Data corruption

Q18. Which file format is commonly used to export a presentation as a set of static images/pages for easy sharing?

(A) .odp(B) .pdf(C) .pptx(D) .csv

Q19. What is the purpose of "Find and Replace" in a Digital Documentation tool?

(A) To format text as bold(B) To search for specific text and replace it with new text throughout the document(C) To insert an image(D) To check spelling only

Q20. Which of the following is NOT a valid database object typically found in a DBMS?

(A) Table(B) Query(C) Report(D) Slide

--- Continued on next page ---

Page 1 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

Section 2 — Short Answer Questions  (2 Marks each) — Q21 to Q25

Q21. What is the purpose of using "Styles" (such as Heading 1, Heading 2) in a word processing document? 2

Q22. What is a "chart" in a spreadsheet? Name any two types of charts commonly used. 2

Q23. What is the significance of enforcing "referential integrity" between related tables in a database? 2

Q24. Explain the term "Custom Animation" in a presentation software. 2

Q25. What is the difference between relative and absolute cell referencing when a formula is copied to another cell? 2

Section 3 — Long Answer Questions  (4 Marks each) — Q26 to Q30

Q26. Explain the steps to create a table of contents automatically in a LibreOffice Writer document using heading styles. 4

Q27. Explain the concept of "conditional formatting" in a spreadsheet, and describe how it can be applied, with a suitable example. 4

Q28. Describe the steps to create a query in a database to retrieve specific records based on given criteria (e.g., students scoring above 80 marks). 4

Q29. Explain any four features/tools available in LibreOffice Impress that help make a presentation more effective and engaging. 4

Q30. What are macros in a spreadsheet/document application? Explain their purpose, and describe one situation where using a macro would be beneficial. 4

--- End of Question Paper --- All the best! ---

Page 2 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

Answer Key & Marking Scheme (Key Points)

PART A — EMPLOYABILITY SKILLS

Q	Ans	Q	Ans
1	(B)	6	(B)
2	(A)	7	(B)
3	(C)	8	(B)
4	(B)	9	(B)
5	(B)	10	(B)

PART B — SUBJECT SPECIFIC SKILLS

Section 1 — Answer Key

Q	Ans	Q	Ans
11	(A) Ctrl+K	16	(C) ^
12	(B) COUNT()	17	(B) Data integrity
13	(B) Retrieve specific data	18	(B) .pdf
14	(B) Notes view	19	(B) Search and replace text
15	(B) Square/Wrap around	20	(D) Slide

Section 2 — Key Answers

Q21. Styles allow consistent, reusable formatting to be applied to text (e.g., all main headings look the same); they also make it possible to automatically generate features like a table of contents based on the heading levels used.

Q22. A chart is a graphical representation of spreadsheet data, making trends and comparisons easier to understand visually; examples include Bar chart, Pie chart, and Line chart (any two correctly named types).

Q23. Referential integrity ensures that relationships between tables remain consistent — for example, preventing a record from referencing a foreign key value that does not exist in the related table — thereby maintaining accurate and reliable data across the database.

Q24. Custom Animation allows the presenter to apply and control specific entrance, emphasis, or exit visual effects to individual objects (text, images) on a slide, controlling how and when each element appears or moves during the presentation.

Q25. A relative reference automatically adjusts (changes) to reflect its new position when a formula is copied to another cell; an absolute reference (marked with $) remains fixed and does not change, always referring to the same specific cell regardless of where the formula is copied.

Section 3 — Key Answers

Q26. Steps: (1) Apply appropriate heading styles (Heading 1, Heading 2, etc.) to the section titles throughout the document. (2) Place the cursor where the table of contents should appear. (3) Go to Insert → Table of Contents and Index → Table of Contents, Index or Bibliography. (4) Configure the desired settings (number of levels, etc.) and click OK. (5) The table of contents is generated automatically, listing headings with page numbers, and can be updated later if the document changes.

Q27. Conditional formatting automatically changes the appearance (e.g., cell colour, font) of cells based on specified conditions/rules; for example, in a marks sheet, cells with values below 33 could be automatically highlighted in red to flag failing scores, making such data instantly visible without manually checking each cell.

Q28. Steps: (1) Open the database and go to the Queries section. (2) Choose "Create Query in Design View" (or use the Query Wizard). (3) Select the required table(s) and add the necessary fields to the query grid. (4) In the "Criteria" row under the relevant field (e.g., Marks), enter the condition (e.g., >80). (5) Run the query to view only the records matching the specified criteria.

Q29. Features include: Slide Master (for consistent design across all slides), Slide Transitions (visual effects between slides), Custom Animation (effects for individual objects), and multimedia insertion (audio/video) to make the presentation more engaging and professional-looking.

Q30. A macro is a recorded sequence of commands/actions that can be replayed with a single command, automating repetitive tasks; for example, if a user regularly needs to format a report in a specific way (fonts, borders, headers) each week, a macro can be recorded once and then run automatically to perform all those steps instantly, saving time and reducing errors.

This sample paper and answer key are prepared for CBSE Class X Information Technology (Code 402) practice, Session 2026–27.

This sample paper and answer key are prepared for CBSE Class X Information Technology (Code 402) practice, Session 2026–27.

Page 3 of 3 (Answer Key)  |  www.careerinformationportal.in

CBSE Class 10 Information Technology (402) Sample Paper 4 - 2026-27

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

CBSE Sample Practice Paper — 4  (Session 2026–27)

Class: X (10th)

Subject: Information Technology — Code: 402

Time: 2 Hours

Max. Marks: 50

Student Name: ______________________

Roll No.: __________

Section: __________

General Instructions:

1. This paper is divided into two parts — Part A: Employability Skills (10 Marks), and Part B: Subject Specific Skills (40 Marks).

2. Part B is further divided into three sections: Section 1 — Objective Type/MCQ (10 Marks), Section 2 — Short Answer (10 Marks), Section 3 — Long Answer (20 Marks).

3. All questions are compulsory. Marks for each question are indicated against it.

4. Write short and precise answers wherever asked.

PART A — EMPLOYABILITY SKILLS  (10 Marks)

Choose the correct option for each of the following questions: 10 × 1 = 10

Q1. Which of the following best describes "self-awareness" as a life skill?

(A) Understanding others' feelings only(B) Recognising one's own strengths, weaknesses, values and emotions(C) Avoiding all self-reflection(D) Copying the behaviour of others

Q2. In a SWOT analysis, increasing competition from a new company entering the market would be classified as a:

(A) Strength(B) Weakness(C) Opportunity(D) Threat

Q3. Which of the following is an example of "stress management"?

(A) Ignoring deadlines completely(B) Practising deep breathing and taking short breaks during work(C) Avoiding all responsibilities(D) Working continuously without rest

Q4. Which of the following is an example of an ICT-enabled service?

(A) Online banking(B) Handwritten ledger(C) Postal money order only(D) In-person cash counting

Q5. Which of the following is a key characteristic that helps an entrepreneur adapt to a changing market?

(A) Rigid thinking(B) Flexibility and openness to innovation(C) Refusal to learn new skills(D) Avoiding customer feedback

Q6. Using energy-efficient LED bulbs instead of traditional bulbs is an example of practising:

(A) A financial skill(B) A green/sustainable practice(C) A communication skill(D) A technical programming skill

Q7. Which of the following is an example of a "soft skill"?

(A) Adaptability(B) Coding in Python(C) Operating a spreadsheet(D) Database design

Q8. Repairing a broken appliance instead of throwing it away is an example of which "R" among the 4 Rs of sustainability?

(A) Recycle(B) Reuse(C) Recover(D) Refuse

Q9. Which of the following best supports effective goal-setting?

(A) Setting vague, undefined goals(B) Setting specific, measurable and time-bound goals(C) Avoiding any planning(D) Changing goals randomly every day

Q10. Which of the following is a barrier to effective communication?

(A) Clear language(B) Noise and distractions during a conversation(C) Active listening(D) Appropriate body language

PART B — SUBJECT SPECIFIC SKILLS  (40 Marks)

Section 1 — Objective Type Questions  (1 Mark each) — Q11 to Q20

Q11. Which of the following is a presentation application?

(A) LibreOffice Writer(B) LibreOffice Calc(C) LibreOffice Impress(D) LibreOffice Base

Q12. Which function is used to find the smallest value in a range of cells?

(A) MIN()(B) MAX()(C) SUM()(D) COUNT()

Q13. A set of rules that ensures the accuracy and consistency of data in a database is known as:

(A) Data redundancy(B) Data integrity(C) Data loss(D) Data duplication

Q14. Which of the following file extensions is used for a LibreOffice Impress presentation file?

(A) .odt(B) .ods(C) .odp(D) .odb

Q15. In mail merge, the file that contains the list of names, addresses or other varying information is called the:

(A) Main document(B) Data source(C) Merge field(D) Template file

Q16. Which of the following is a valid formula to add the values in cells A1 and A2 in a spreadsheet?

(A) A1+A2(B) =A1+A2(C) SUM A1 A2(D) ADD(A1,A2)

Q17. Which SQL command is used to remove a record from a database table?

(A) SELECT(B) INSERT(C) UPDATE(D) DELETE

Q18. Which feature allows you to add a running commentary or explanation below each slide, visible only to the presenter?

(A) Slide Animation(B) Speaker Notes(C) Slide Transition(D) Slide Master

Q19. Which of the following is the correct order of operator precedence in a spreadsheet formula (from highest to lowest)?

(A) Addition, Multiplication, Exponentiation(B) Exponentiation, Multiplication/Division, Addition/Subtraction(C) Subtraction, Exponentiation, Division(D) All operators have equal precedence

Q20. A form in a database application is primarily used for:

(A) Storing raw table structures only(B) Entering and viewing data in a user-friendly interface(C) Deleting entire databases(D) Creating slide presentations

--- Continued on next page ---

Page 1 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

Section 2 — Short Answer Questions  (2 Marks each) — Q21 to Q25

Q21. What is the purpose of "Find and Replace" in a Digital Documentation application? Give one example of its use. 2

Q22. Write the steps to change the font style and size of selected text in a word processing document. 2

Q23. What is meant by "freezing panes" in a spreadsheet? State one situation where it would be useful. 2

Q24. What is a "report" in a database application? State one purpose it serves. 2

Q25. What is "slide animation" in a presentation? How is it different from a "slide transition"? 2

Section 3 — Long Answer Questions  (4 Marks each) — Q26 to Q30

Q26. Explain the steps to insert and format an image (resize, wrap text) within a word processing document. 4

Q27. Explain the steps to create a simple formula-based budget spreadsheet that calculates total income, total expenses, and the balance remaining, using at least two different functions. 4

Q28. Explain the steps to create a query in a database application to display specific fields from a table based on a given condition (e.g., listing students who scored more than 80 marks). 4

Q29. Explain the steps to insert and customise a chart/graph (e.g., a bar chart) within a slide of a presentation to visually represent data. 4

Q30. What is meant by "cell protection" in a spreadsheet? Explain its importance with a suitable example (e.g., protecting formula cells in a shared worksheet from accidental editing). 4

--- End of Question Paper --- All the best! ---

Page 2 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

Answer Key & Marking Scheme (Key Points)

PART A — EMPLOYABILITY SKILLS

Q	Ans	Q	Ans
1	(B)	6	(B)
2	(D)	7	(A)
3	(B)	8	(B)
4	(A)	9	(B)
5	(B)	10	(B)

PART B — SUBJECT SPECIFIC SKILLS

Section 1 — Answer Key

Q	Ans	Q	Ans
11	(C) LibreOffice Impress	16	(B) =A1+A2
12	(A) MIN()	17	(D) DELETE
13	(B) Data integrity	18	(B) Speaker Notes
14	(C) .odp	19	(B) Exponentiation, Multiplication/Division, Addition/Subtraction
15	(B) Data source	20	(B) Entering and viewing data in a user-friendly interface

Section 2 — Key Answers

Q21. "Find and Replace" locates specific words or phrases in a document and allows the user to automatically replace them with alternative text; e.g., quickly replacing every occurrence of an old company name with a new one throughout a long document.

Q22. Select the required text → open the Font Name dropdown on the toolbar and choose the desired font style → open the Font Size dropdown and select the desired size (alternatively, use Format → Character for more detailed options).

Q23. Freezing panes keeps selected rows and/or columns (such as headers) visible on screen while scrolling through the rest of a large spreadsheet; useful, for example, when scrolling through hundreds of rows of data while keeping the column headers always visible at the top.

Q24. A report is a formatted, print-ready presentation of data retrieved from one or more database tables/queries; it serves the purpose of summarising and presenting data in an organised, professional manner for viewing or printing (e.g., a monthly sales report).

Q25. Slide animation applies a visual effect to individual objects/text within a single slide (e.g., text flying in); a slide transition applies a visual effect to the change between two entire slides as the presentation moves from one to the next.

Section 3 — Key Answers

Q26. Steps: place the cursor at the desired location → Insert menu → Image → From File → select the required image and insert it → click on the inserted image to select it, then drag its corner handles to resize it proportionally → right-click and choose "Wrap Text" (e.g., "Wrap Around" or "Optimal Page Width") to control how surrounding text flows around the image.

Q27. Steps: create a spreadsheet with columns for income items and expense items, entering their respective amounts → use =SUM(range) to calculate total income and total expenses separately → use a subtraction formula, e.g., =TotalIncome−TotalExpenses (or =SUM(IncomeRange)−SUM(ExpenseRange)), to calculate the remaining balance in a designated cell.

Q28. Steps: open the database and go to the Queries section → choose "Create Query in Design View" → select the required table and add the necessary fields to the query grid → in the Criteria row under the "Marks" field, enter the condition (e.g., >80) → run the query to display only the records/fields meeting this condition.

Q29. Steps: select the slide where the chart is needed → Insert menu → Chart → a default chart with sample data appears → double-click the chart and edit the underlying data table to enter the actual values → choose the desired chart type (e.g., Bar) from the chart type options → click outside the chart to finalise it, then resize/reposition it on the slide as needed.

Q30. Cell protection restricts editing of specific cells in a spreadsheet, typically after the sheet is "protected," so that only unlocked cells remain editable; this is important, for example, in a shared worksheet where formula cells (which calculate totals automatically) should be locked/protected to prevent accidental changes, while data-entry cells remain open for users to fill in.

This sample paper and answer key are prepared for CBSE Class X Information Technology (Code 402) practice, Session 2026–27.

Page 3 of 3 (Answer Key)  |  www.careerinformationportal.in

CBSE Class 10 Information Technology (402) Sample Paper 3 - 2026-27

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

CBSE Sample Practice Paper — 3  (Session 2026–27)

Class: X (10th)

Subject: Information Technology — Code: 402

Time: 2 Hours

Max. Marks: 50

Student Name: ______________________

Roll No.: __________

Section: __________

General Instructions:

1. This paper is divided into two parts — Part A: Employability Skills (10 Marks), and Part B: Subject Specific Skills (40 Marks).

2. Part B is further divided into three sections: Section 1 — Objective Type/MCQ (10 Marks), Section 2 — Short Answer (10 Marks), Section 3 — Long Answer (20 Marks).

3. All questions are compulsory. Marks for each question are indicated against it.

4. Write short and precise answers wherever asked.

PART A — EMPLOYABILITY SKILLS  (10 Marks)

Choose the correct option for each of the following questions: 10 × 1 = 10

Q1. Which of the following is an example of formal communication?

(A) Chatting with a friend(B) An official office memo(C) A casual text message(D) Gossip among colleagues

Q2. In a SWOT analysis, a new government subsidy for small businesses would be classified as a:

(A) Strength(B) Weakness(C) Opportunity(D) Threat

Q3. Which of the following is an example of a self-management skill?

(A) Stress management(B) Web designing(C) Spreadsheet formulas(D) Database querying

Q4. Which of the following is an example of an ICT device?

(A) Smartphone(B) Chair(C) Notebook (paper)(D) Pen

Q5. Which of the following best describes an "entrepreneur"?

(A) A person who only follows others' instructions(B) A person who identifies an opportunity and organises resources to start a venture(C) A person who avoids all financial risk(D) A person employed only in government service

Q6. Which of the following is an example of a "green skill"?

(A) Knowledge of solar panel installation(B) Typing speed(C) Public speaking(D) Accounting

Q7. Which of the following is an example of a "hard skill" rather than a soft skill?

(A) Teamwork(B) Leadership(C) Operating spreadsheet software(D) Empathy

Q8. Composting kitchen waste to create fertiliser is an example of which "R" among the 4 Rs of sustainability?

(A) Reduce(B) Reuse(C) Recover(D) Refuse

Q9. Which of the following is generally considered a characteristic of a successful entrepreneur?

(A) Avoiding all decision-making(B) Self-confidence and initiative(C) Depending fully on others for ideas(D) Resisting all change

Q10. Active listening, as a communication skill, primarily involves:

(A) Interrupting the speaker frequently(B) Paying full attention and responding thoughtfully to the speaker(C) Only nodding without understanding(D) Ignoring non-verbal cues

PART B — SUBJECT SPECIFIC SKILLS  (40 Marks)

Section 1 — Objective Type Questions  (1 Mark each) — Q11 to Q20

Q11. Which of the following is a word processing application?

(A) LibreOffice Writer(B) LibreOffice Calc(C) LibreOffice Impress(D) LibreOffice Base

Q12. Which function returns the total number of numeric values in a given range in a spreadsheet?

(A) SUM()(B) COUNT()(C) AVERAGE()(D) MAX()

Q13. A field in one table that refers to the primary key of another table is called a:

(A) Primary key(B) Foreign key(C) Index(D) Query

Q14. Which view in a presentation application displays only the text content of all slides, without graphics?

(A) Normal view(B) Slide Sorter view(C) Outline view(D) Notes view

Q15. The main document used in a mail merge, which contains fixed text and merge fields, is called the:

(A) Data source(B) Main/master document(C) Merge record(D) Field list

Q16. Which of the following represents a range of cells from A1 to A10 in a spreadsheet?

(A) A1-A10(B) A1:A10(C) A1;A10(D) A1,A10

Q17. Which SQL command is used to add a new record to a database table?

(A) SELECT(B) INSERT(C) UPDATE(D) DELETE

Q18. Which feature allows you to preview how slides will look before printing or presenting them?

(A) Slide Show(B) Slide Master(C) Slide Layout(D) Slide Notes

Q19. Which of the following symbols is used to begin a formula in a spreadsheet cell?

(A) #(B) @(C) =(D) &

Q20. A collection of related tables in a database is referred to as a:

(A) Query(B) Report(C) Database(D) Form

--- Continued on next page ---

Page 1 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

Section 2 — Short Answer Questions  (2 Marks each) — Q21 to Q25

Q21. What is the purpose of the "spell check" feature in a Digital Documentation application? How is it typically accessed? 2

Q22. Write the steps to insert a table with 3 rows and 3 columns in a word processing document. 2

Q23. What is meant by "filtering" data in a spreadsheet? Give one example of when it would be useful. 2

Q24. What is a "query" in a database? State one purpose it serves. 2

Q25. What is a "slide layout" in a presentation application? Give one example of a common slide layout. 2

Section 3 — Long Answer Questions  (4 Marks each) — Q26 to Q30

Q26. Explain the steps to create a bulleted and numbered list in a word processing document, and describe one situation where each type would be preferred. 4

Q27. Explain any four types of charts/graphs available in a spreadsheet application, and describe a situation in which each type would be an appropriate choice for representing data. 4

Q28. Explain the steps involved in creating a simple table in a database application, including the process of defining fields and setting a primary key. 4

Q29. Explain the steps to add speaker notes to slides in a presentation, and describe why speaker notes are useful during a live presentation. 4

Q30. What is meant by "conditional formatting" in a spreadsheet? Explain its usefulness with a suitable example (e.g., highlighting cells with values above a certain threshold). 4

--- End of Question Paper --- All the best! ---

Page 2 of 3  |  www.careerinformationportal.in

www.careerinformationportal.in

APNA CAREER PORTAL

www.careerinformationportal.in

Answer Key & Marking Scheme (Key Points)

PART A — EMPLOYABILITY SKILLS

Q	Ans	Q	Ans
1	(B)	6	(A)
2	(C)	7	(C)
3	(A)	8	(C)
4	(A)	9	(B)
5	(B)	10	(B)

PART B — SUBJECT SPECIFIC SKILLS

Section 1 — Answer Key

Q	Ans	Q	Ans
11	(A) LibreOffice Writer	16	(B) A1:A10
12	(B) COUNT()	17	(B) INSERT
13	(B) Foreign key	18	(A) Slide Show
14	(C) Outline view	19	(C) =
15	(B) Main/master document	20	(C) Database

Section 2 — Key Answers

Q21. Spell check identifies and highlights potentially misspelt words in a document and suggests corrections, helping ensure accurate and professional-looking text; it is usually accessed via Tools → Spelling and Grammar, or automatically as red underlines while typing.

Q22. Place the cursor where the table is needed → go to Table menu → Insert Table → specify 3 columns and 3 rows in the dialog box → click OK/Insert to create the table.

Q23. Filtering displays only those rows of data that meet specified criteria, temporarily hiding the rest; useful, for example, when a teacher wants to view only the students who scored above 90% marks from a large class list.

Q24. A query is a request to retrieve or manipulate specific data from one or more database tables based on given criteria; it serves the purpose of extracting only the relevant information needed (e.g., listing all students from a particular class) without having to view the entire table.

Q25. A slide layout is a predefined arrangement of placeholders (for title, text, images, etc.) on a slide; a common example is the "Title, Content" layout, which has a title placeholder at the top and a content area below for text or bullet points.

Section 3 — Key Answers

Q26. Select the text → click the Bulleted List icon (for unordered points) or Numbered List icon (for ordered/sequential points) on the toolbar, or use Format → Bullets and Numbering for more options. Bulleted lists are preferred when listing items with no particular order (e.g., a shopping list); numbered lists are preferred when sequence matters (e.g., step-by-step instructions).

Q27. Bar chart — useful for comparing values across categories (e.g., sales of different products); Line chart — useful for showing trends over time (e.g., monthly temperature changes); Pie chart — useful for showing proportions of a whole (e.g., percentage market share of companies); Column chart — similar to bar chart but vertical, useful for comparing values across a small number of categories over time (any four correctly explained chart types with suitable use-cases).

Q28. Steps: (1) Open the database application and create a new table in Design view. (2) Define each field by entering its name and selecting an appropriate data type (e.g., Text, Number, Date). (3) Identify the field that will uniquely identify each record (e.g., ID). (4) Right-click that field and select "Primary Key" (or use the toolbar option) to set it as the primary key. (5) Save the table with an appropriate name.

Q29. Steps: switch to Notes view (or the Notes pane in Normal view) → click in the notes area below the slide → type the relevant reminders, explanations, or talking points for that slide → repeat for each slide as needed. Speaker notes are useful because they help the presenter remember key points, statistics, or explanations without cluttering the slide itself, which the audience does not see during the actual presentation (in Presenter View).

Q30. Conditional formatting automatically applies a specific visual format (such as a background colour or font style) to cells that meet a defined condition; for example, setting a rule so that any cell with a value above 90 in a marks column automatically turns green, making it easy to quickly identify high performers at a glance without manually checking every value.

This sample paper and answer key are prepared for CBSE Class X Information Technology (Code 402) practice, Session 2026–27.

Page 3 of 3 (Answer Key)  |  www.careerinformationportal.in