Class 10 IT 402 Sample Pre-Board QP 2026 with Solution

The Class 10 IT 402 Sample Pre-Board Question Paper 2026 with solutions is designed to help students practice important concepts from notes of both Part A (Employability Skills) and Part B (Subject-Specific Skills). This sample paper follows the latest CBSE exam pattern and includes a balanced mix of objective-type questions, short answers, and scenario-based questions to improve real exam readiness. With fully explained solutions, students can easily understand the correct approach to writing answers and avoid common mistakes. This model paper is especially useful for self-study, revision, and last-minute preparation. Practicing this question paper ensures better confidence, improved conceptual clarity, and higher chances of scoring full marks in the final board examination.

Class 10 IT 402 Sample / Pre-Board Question Paper Session (2025-26)

INFORMATION TECHNOLOGY (SUBJECT CODE – 402)
Sample / Pre-Board Question Paper Solution for Class X – SET 1 (Session 2025-2026)

Max. Time: 2 Hours
Max. Marks: 50

General Instructions:

1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type questions.
4. Out of the given (5 + 16 =) 21 questions, a candidate has to answer (5 + 10 =) 15 questions in the
   allotted (maximum) time of 2 hours.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A – OBJECTIVE TYPE QUESTIONS (24 MARKS):
   i. This section has 05 questions.
   ii. Marks allotted are mentioned against each question/part.
   iii. There is no negative marking.
   iv. Do as per the instructions given.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
   i. This section has 16 questions.
   ii. A candidate has to do 10 questions.
   iii. Do as per the instructions given.
   iv. Marks allotted are mentioned against each question/part

SECTION A: OBJECTIVE TYPE QUESTIONS

Q.1 Answer any 4 out of the given 6 questions on Employability Skills (1X4=4 marks)

i) Mohan, who recently moved from Egypt to Canada, speaks little English and struggles to communicate effectively with his colleagues. This language difficulty causes frequent misunderstandings and affects his work performance. This situation is an example of a:
a) Interpersonal barrier
b) Cultural barrier
c) Physical barrier
d) Linguistic barrier

ii) James has been consistently following a strict routine at work, always ensuring that he meets deadlines and sticks to his schedule. However, he is now feeling mentally drained and overwhelmed due to the rigid structure and lack of flexibility in his approach. This is likely caused by an overemphasis on:
a) Stress
b) Discipline
c) Timeliness
d) Goal – Setting

iii) Maya wants to access websites and browse the internet on her computer. She opens a software that allows her to search for information, view web pages, and interact with online content. What is this software called?
a) Web Browsers
b) Designing Software
c) Office Software
d) Operating System

iv) To build a successful business, an entrepreneur must focus on providing high-quality __ that meet the needs of their target market. These offerings should cater to customer demands and help differentiate the business from competitors.
a) Satisfying human need
b) Product and Service
c) Calculated Risk
d) Regular Production

v) The Sustainable Development Goals (SDGs) are designed to address a wide range of global challenges. Which of the following is not one of the SDGs focused on improving the world for future generations?
a) Gender Equality
b) Affordable and Clean Energy
c) Climate Action
d) Industrial Growth

vi) The SMART method helps in setting effective goals for career and personal growth. In this method, what does the ‘R’ stand for?
a) Realistic
b) Resourceful
c) Responsible
d) Relevant

Q.2 Answer any 5 out of the given 6 questions (1X5=5 marks)

i) Frame Styles are commonly used to format graphic and text frames, including text wrap, borders, backgrounds, and columns. Which of the following tools would help Ria format and apply consistent styles to text and graphic frames in her document?
a) Use Format Painter; stop it by pressing Ctrl + Shift + F
b) Use Style Inspector; stop it by clicking on Close
c) Use Frame Styles; stop it by selecting a different frame style
d) Use AutoFormat; stop it by closing the document

ii) Ravi is working on a report where he needs to apply the same style to several scattered paragraphs and headings throughout the document. Instead of selecting each section individually and applying the style, he wants a quicker way to apply the style to multiple areas at once. Which feature should Ravi use to streamline this process?
a) Create New Style
b) Update Selected Style
c) AutoFormat
d) Fill Format

iii) Aarti is working on a document that includes several references to external websites and email addresses. She wants to make it easy for readers to click on these references and open them directly in their browser or email client. Which feature should Aarti use to achieve this?
a) Index of Keywords
b) Hyperlink Tool
c) Table of Contents
d) Bookmark

iv) Assertion (A): A macro is a single instruction that executes a set of instructions.
Reason (R): These set of instructions can be a sequence of commands or keystrokes that can be used for any number of times later.
a) Both A and R are true, and R is the correct explanation of A
b) Both A and R are true, but R is NOT the correct explanation of A
c) A is true, but R is false
d) A is false, but R is true

v) A manager wants to determine the sales target required to reach a specific profit in a financial model. She knows the current sales figures and desired profit, but needs to calculate the exact target sales figure that will achieve this goal. Which feature of LibreOffice Calc will help her calculate this?
a) Data Consolidate
b) External References to other documents
c) What-if Scenarios
d) Goal Seek

vi) Which option should you choose to start tracking changes in a spreadsheet in LibreOffice Calc?
a) Tools > Review Changes > Manage
b) File > Options > Track Changes
c) Edit > Track Changes > Record
d) View > Track Changes > Review

Q.3 Answer any 5 out of the given 6 questions (1X5=5 marks)

i) Ravi is working on a report in LibreOffice Writer and wants to ensure that the Table of Contents (ToC) he generates is clear, well-organised, and easily accessible. Which of the following characteristics is most important for a good Table of Contents?
a) It should include decorative borders and stylish fonts to make it look attractive.
b) It should be given after the title and copyright page.
c) It must be accurate and easily accessible.
d) It should be formatted with colourful fonts and complex styles.

ii) During an office inspection, it is noted that there are exposed electrical wires, and some employees have their desks too close to heating devices, creating a fire risk. Additionally, heavy objects are stored in unsafe locations, posing a risk of physical injury. Which type of hazards are most relevant in this situation?
a) Physical and Fire Hazards
b) Ergonomic and Health Hazards
c) Chemical and Safety Hazards
d) Biological and Health Hazards

iii) Which key is used to uniquely identify each record in a database table, ensuring that no two records have the same value in this field?
a) Primary Key
b) Foreign Key
c) Composite Key
d) Candidate Key

iv) Which of the following is true, if a database field is defined as float?
a) Only whole numbers
b) Numbers with decimals, length 7, 1 decimal
c) Stores text and numbers
d) Numbers up to 100 digits

v) John, a database designer, is tasked with creating a system where multiple records are associated with the same master file. The structure of the database is similar to an inverted tree, where the master file is at the base, and the branches hold information linked to the master. Which data model should John use for this design?
a) Relational Data Model
b) Network Data Model
c) Hierarchical Data Model
d) All of these

vi) In the Query Design View of a database, what does the window consist of?
a) Navigation Pane and Query Preview
b) Objects Relationship Pane and Design Grid
c) Report Pane and Data Grid
d) Form Design Grid and SQL Pane

Q.4 Answer any 5 out of the given 6 questions (1X5=5 marks)

i) What is the shortcut key to start recording changes in a document when Track Changes is activated?
a) Ctrl + Shift + T
b) Ctrl + Alt + N
c) Ctrl + Shift + C
d) Ctrl + N

ii) Ravi wants to summarize and analyze a large dataset in LibreOffice Calc, grouping data from multiple categories and finding key trends. He wants a flexible way to create summaries and view different perspectives of the data. Which feature should he use?
a) Use Pivot Table
b) Use Consolidate with the “Link to source data” option enabled
c) Use Data Validation with “Cell Range” enabled
d) Use Scenario Manager with “Copy Results To” option

iii) Which of the following best describes Minimal Data Redundancy in a database?
a) Redundancy causes data inconsistencies
b) DBMS keeps all data at one location
c) Redundancy is controlled and minimised
d) Redundancy improves data retrieval speed

iv) During office work, employees are concerned about safety hazards, including the risk of fire. Which approach is most effective in reducing this workplace hazard?
a) Conflict resolution training and promoting hobbies
b) Only installing ergonomic chairs
c) Providing fire extinguishers to ensure safety
d) Routine electrical inspections

v) Rahul is working on a spreadsheet to calculate the monthly savings required to reach a target amount for a vacation fund. The savings amount depends on the monthly contribution, interest rate, and investment duration (in years). He fixes the interest rate and the investment duration but wants the monthly contribution to be exactly ₹5,000. Which feature of Calc should he use, and why?
a) Goal Seek –because it adjusts the input (monthly contribution) to reach the exact target output (₹5,000).
b) Scenario Manager – because it allows creating multiple possible outcomes with different sets of inputs.
c) Consolidate – because it combines data from different sheets into one summary.
d) Data Validation – because it restricts the type of values that can be entered into a cell.

vi) To prevent fire hazards, materials in a workplace are categorized based on their combustion properties. Which of the following correctly identifies a fire class and its associated material type?
a) Class A – Electrical fires; Class B – Combustible metals
b) Class C – Electrical fires; Class D – Wood, paper, and cloth
c) Class B – Flammable liquids and gases; Class A – Wood, paper, and cloth
d) Class D – Paper and cloth; Class C – Electrical equipment

Q.5 Answer any 5 out of the given 6 questions (1X5=5 marks)

i) Sneha needs to create multiple project reports, all of which require the same header, footer, and formatting. Instead of applying these elements individually for each report, which feature of LibreOffice Writer would allow her to automate this process?
a) Template
b) Style Inspector
c) AutoFormat
d) Track Changes

ii) Which feature in LibreOffice helps users generate structured reports by selecting fields from a database and applying predefined layouts?
a) Report Wizard
b) AutoFormat
c) Both a) and b)
d) Neither a) nor b)

iii) The primary purpose of conducting an evacuation drill in the workplace is to ensure that employees are familiar with _____ and _____ in case of an emergency.
a) fire extinguishers, safety protocols
b) emergency exits, evacuation procedures
c) safety equipment, fire alarms
d) office layout, first aid kits

iv) Priya notices a chemical spill in the laboratory. Which sequence of actions demonstrates the correct approach to handling the spill according to safety protocols?
a) Evacuate area → inform supervisor → clean up spill
b) Inform supervisor → evacuate area → clean up spill
c) Clean up spill → inform supervisor → evacuate area
d) Ignore the spill → continue work → report at the end of the day

v) Raj works in a manufacturing plant where machine malfunctions, exposed wires, and sharp tools are common hazards. Which of the following actions should he prioritise to maintain a safe workspace?
a) Fix workstation, report wires, leave machine issues for technicians
b) Report machine issues, clean surfaces, remove sharp tools, and ensure safety guards
c) Focus on personal workspace, ignore common areas, wait for technicians
d) Clean common areas, ignore machine problems

vi) A company’s HR team is preparing an employee performance review document. Two team members, Mr. Arun and Ms. Neha, work on the same file separately (Review_Arun.ods and Review_Neha.ods). Before finalising the report, the team needs to:
1. Compare the differences in both versions.
2. Merge the approved changes into one final document.
As the data entry operator, which steps should you follow in LibreOffice Calc?
a) Directly open Review_Arun.ods and overwrite it with Review_Neha.ods.
b) Open Review_Arun.ods, use Compare Document to review differences, then use Merge Document to finalise.
c) Open Review_Neha.ods and delete conflicting data manually.
d) Use only Merge Document, since it automatically compares files too.

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills (2X3=6 marks) Answer each question in 20 – 30 words.

Q.6 Explain the three main parts of communication and their importance in ensuring effective communication.
Ans: Communication consists of three main parts: Transmitting, Listening, and Feedback.
Transmitting: This refers to the process where the sender conveys a message to the receiver using an appropriate medium of communication.
Listening: Listening is the act of receiving and understanding the message sent by the communicator.
Feedback: Feedback is the response or reaction from the receiver after receiving the message.

Q. 7 Ravi finds it difficult to manage his emotions when facing criticism at work. He often becomes defensive and reacts angrily, which affects his relationships with colleagues. What steps can Ravi take to improve his emotional intelligence and handle criticism more constructively?
Ans: To manage emotional intelligence and handle criticism constructively, Ravi can:
Understand his emotions: Observe his own behaviour and identify areas that need improvement. Once he becomes aware of his emotional triggers, he can work on managing them effectively.
Rationalise: Avoid making decisions abruptly. He should think calmly and make decisions that are logical and not influenced by emotions.
Practise self-control: Engage in meditation and yoga to stay calm and focused. These practices help in reducing stress and improving emotional balance.

Q. 8 What is the primary difference between the life of an entrepreneur and that of his corporate counterpart?
Ans: The primary difference is that an entrepreneur typically assumes greater risk, manages all aspects of the business, and has more control over decisions, while a corporate counterpart works within an established structure, with defined roles and less personal risk.

Q. 9 What are the key challenges faced in achieving sustainable development in relation to food security and water management?
Ans: Key challenges related to sustainable development in food and water include:

• Climate change affecting crop yields and water availability.
• Water scarcity due to overuse and pollution.
• Food waste leading to inefficiency in food production.
• Population growth increasing demand for resources

Q. 10 Amit is concerned about his personal and work data being compromised or attacked by malware. What measures can he take to safeguard his data effectively?
Ans: To safeguard his data effectively, Amit can take the following measures:
Use Strong Passwords: Create complex and unique passwords for all accounts.
Install Antivirus Software: Use trusted antivirus programs to detect and remove malware.
Enable Firewall Protection: Ensure that the firewall is activated to block unauthorized access.
Backup Data Regularly: Keep copies of important data in secure locations, such as external drives or cloud storage.
Update Software and Systems: Regularly update operating systems and applications to patch vulnerabilities.
Be Cautious with Emails and Links: Avoid clicking on suspicious links or downloading attachments from unknown sources.

Answer any 4 out of the given 6 questions (2X4=8 marks) Answer each question in 20 – 30 words.

Q. 11 Ravi is exploring formatting options in LibreOffice Writer. His teacher asked him to describe two types of paragraph styles and one feature of each. What should Ravi write?
Ans: To answer the question, Ravi should write:
Text Styles: These styles control the appearance of individual text elements. A key feature of text styles is that they allow users to set attributes such as font, size, and colour, ensuring consistent text formatting throughout the document.
Paragraph Styles: These styles control the formatting of entire paragraphs. A key feature of paragraph styles is that they can manage alignment, line spacing, and indentation, providing uniform formatting for all paragraphs with the same style.

Q. 12 a) What steps must you take before activating the Track Changes feature in LibreOffice Calc?
Ans: Before activating the Track Changes feature in LibreOffice Calc, you must ensure that the document is saved and shared for collaborative editing. Then, go to Tools > Track Changes > Record to enable it.

b) How can you check if the “Edit Document” option is disabled in a shared LibreOffice Calc spreadsheet?
Ans: To check if the “Edit Document” option is disabled in a shared LibreOffice Calc spreadsheet, go to File > Properties > Security. If the “Edit Document” option is unchecked or disabled, it means the document cannot be edited by others.

Q. 13 Differentiate between a One-to-One relationship and a Many-to-One relationship in a database.
Ans: One-to-One Relationship: In a One-to-One relationship, each record in Table A is associated with only one record in Table B, and vice versa. Example: Each employee has one unique employee ID, and each employee ID is assigned to only one employee.
Many-to-One Relationship: In a Many-to-One relationship, many records in Table A can be associated with a single record in Table B.
Example: Multiple employees can belong to one department, but each employee belongs to only one department.

Q. 14 What are the common causes of slips, trips, and falls in the workplace?
Ans: Common causes of slips, trips, and falls in the workplace include:
Wet or slippery floors: Spills or cleaning activities can make surfaces slippery.
Cluttered walkways: Items like cables, boxes, or materials left in walkways can cause trips.
Uneven flooring: Damaged carpets, rugs, or flooring can create tripping hazards.
Poor lighting: Inadequate lighting can make it difficult to spot potential hazards.

Q. 15 What is the purpose of using macros in LibreOffice applications? Mention two scenarios in which macros can automate tasks and improve efficiency.
Ans: Macros in LibreOffice automate repetitive tasks to improve efficiency.
Examples: Automating Report Generation: A macro can generate reports by pulling data, applying formatting, and summarizing automatically.
Data Cleanup: A macro can clean data by removing extra spaces or formatting text and numbers consistently.

Q. 16 During a routine inspection, Rina discovers that a co-worker has come into contact with a live electrical wire. What immediate actions should she take to safely assist the victim without putting herself at risk?
Ans: If Rina discovers a co-worker stuck to a live electrical wire, she should follow these steps:
Do not touch the victim directly: Never touch the victim while they are still in contact with the live wire to avoid electrocution.
Disconnect the power source: If it’s safe to do so, turn off the power supply to the electrical source to stop the current.

Answer any 3 out of the given 5 questions (4X3=12 marks) Answer each question in 50 – 80 words.

Q. 17 Case Study: A graphic design team is working on creating a brochure in LibreOffice Writer for a new product launch. The designer wants to ensure that the document looks visually appealing and the images are well-integrated with the text. While designing, the team faces the following challenges:

• In one section, the image and text are not aligned properly, causing a misaligned layout.
• On the front page, the logo needs to be placed at the top-left corner and remain in the same position regardless of text changes.
• In a product description section, the designer wants the text to wrap neatly around the image on the right side, with no overlapping or awkward gaps.
• For a special offer section, the product image needs to appear on top of the text so that it’s the focal point.

a) Which feature should the team use to fix the issue of misaligned image and text in the section?
Ans: To fix the issue of misaligned image and text in the section, the team should use Text Wrapping. This allows the image to be placed in the desired position with text flowing neatly around it.

b) Which setting will help the designer fix the logo at the top-left corner of the front page, ensuring it stays in place when text is added or removed?
Ans: To fix the logo at the top-left corner of the front page and ensure it stays in place regardless of text changes, the editor should use Anchor to a paragraph or “Fixed position on the page” setting. This will lock the logo’s position, so it doesn’t move when the text changes.

c) Which option will allow the text to wrap smoothly around the image in the product description section?
Ans: To allow the text to wrap smoothly around the image in the product description section, the designer should use Text Wrapping options and select the “Wrap around” option. This ensures that the text flows neatly around the image, without overlapping.

d) What arrangement tool should the team use to ensure the product image appears on top of all other elements in the special offer section?
Ans: To ensure the product image appears on top of all other elements in the special offer section, the team should use the “Bring to Front” or “Raise” option in the Arrange tool. This will ensure the image is placed above the text and other elements.

Q. 18 Consider the table below and answer the questions that follow:

Employee Name	Employee ID	Department	Salary	Date of Joining
John	1001	HR	50000	01/01/2020
Jack	1002	IT	60000	15/03/2019
Emily	1003	Sales	55000	20/06/2018
Robin	1004	IT	65000	10/07/2017

a) Name all the fields in the given table.
Ans: The fields in the given table are: Employee Name, Employee ID, Department, Salary, Date of Joining

b) Which field should be made the primary key?
Ans: The Employee ID field should be made the primary key because it uniquely identifies each employee in the table, ensuring there are no duplicate records.

c) Suggest a possible alternate key, if any.
Ans: A possible alternate key could be Employee Name, assuming that employee names are unique in this scenario. However, this is not ideal in real-world scenarios because employee names are more likely to be duplicated.

d) Explain how a primary key differs from a foreign key with an example.
Ans: Primary Key: A primary key is a unique identifier for a record in a table. It ensures that each record can be uniquely identified. In this case, the Employee ID is the primary key, as it uniquely identifies each employee in the table.
Foreign Key: A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between the two tables.
For example, if there was another table called Employee Attendance that records employee attendance, it might have a foreign key field called Employee ID that references the Employee ID from the Employee table. This helps link attendance records to specific employees.

Q. 19 Musculoskeletal problems, such as pain in the back, neck, and shoulders, can occur due to prolonged sitting or poor ergonomics while working at a computer. List four ways to prevent musculoskeletal problems while working on a computer.
Ans: To prevent musculoskeletal problems while working on a computer, you can follow these four tips:
Maintain Proper Posture: Sit with your back straight, shoulders relaxed, and feet flat on the floor. Keep your monitor at eye level to avoid straining your neck.
Use an Ergonomic Chair: Ensure your chair supports your lower back and allows your feet to rest comfortably on the floor. The chair should also allow for adjusting height and armrests to ensure comfort.
Take Regular Breaks: Stand up, stretch, and walk around every 20-30 minutes to reduce strain on your muscles and joints.
Adjust Your Workstation: Position your keyboard and mouse at a comfortable height, with your arms bent at a 90-degree angle, and avoid leaning forward to prevent shoulder and arm strain.

Q. 20 Aakash is managing a library database in LibreOffice Base. He has a master table called Books and a transaction table called BorrowedBooks.
a) What is referential integrity?
Ans: Referential integrity ensures that relationships between tables remain consistent. It means that any foreign key field in a child table must have a corresponding primary key in the master (parent) table, or the foreign key must be null.

b) Aakash wants to ensure that if a book is being borrowed, it cannot be deleted from the Books table. Which option should he use to enforce this?
Ans: Aakash should use the “Restrict” option for deletion. This will prevent the deletion of a book record from the Books table if it is being referenced in the BorrowedBooks table.

c) If a BookID is changed in the Books table, how does the Update Cascade option affect the BorrowedBooks table? Provide an example.
Ans: Update Cascade: If the Update Cascade option is enabled, when a BookID is updated in the Books table, the corresponding BookID in the BorrowedBooks table will also be updated automatically to reflect the new BookID.
Example: If the BookID for a book called “Harry Potter” in the Books table is changed from 101 to 202, the BookID in the BorrowedBooks table for all records referencing “Harry Potter” will also be updated from 101 to 202.

d) If the Set NULL option is used and a book record is deleted from the Books table, what happens in the BorrowedBooks table? How is it different from the Set Default option?
Ans: Set NULL vs Set Default:
Set NULL: If a BookID is deleted from the Books table, the corresponding BookID field in the BorrowedBooks table will be set to NULL, indicating that the borrowed book is no longer available in the Books table.
Example: If BookID 101 is deleted from the Books table, all records in the BorrowedBooks table that reference BookID 101 will have their BookID set to NULL.
Set Default: If the Set Default option is used, the BookID in the BorrowedBooks table will be set to a default value (e.g., a specific BookID that is predefined) instead of NULL when a related record in the Books table is deleted.
Example: If the Set Default option is enabled, and BookID 101 is deleted, all corresponding records in the BorrowedBooks table will have their BookID set to a default BookID (e.g., 999).

Q. 21 Case Study: Neha is working on a financial analysis report in LibreOffice Calc that contains data from multiple sheets. She wants to include external links to reference market data from an online source. Initially, she uses an absolute hyperlink to link to a specific market data file on her computer, but when she shares the report with her colleague, the hyperlink is broken because the file path is different on their computer. Neha then decides to use a relative hyperlink. She also discovers the Target in Document feature, which allows her to link directly to a specific cell in a spreadsheet, and the Link to External Data feature, which fetches live data from a stock market website into her sheet.

a) Why did the absolute hyperlink fail when Neha shared the file, and how does a relative hyperlink fix this issue?
Ans: The absolute hyperlink failed because it pointed to a specific file path on Neha’s computer, which changed when shared. A relative hyperlink solves this by linking to the file based on its location relative to the current document, making it portable.

b) How does the Target in Document option improve navigation within large spreadsheets?
Ans: The Target in Document option allows quick navigation to specific cells or sections within a large spreadsheet, improving efficiency in large files.

c) Neha wants her report to automatically update with real-time stock market data when opened. Which feature should she use, and how does it benefit her report?
Ans: Neha should use the Link to External Data feature, which automatically updates her spreadsheet with live stock market data from an external website whenever the report is opened.

d) If Neha needs to modify or remove a hyperlink, what steps should she follow?
Ans: To modify or remove a hyperlink, Neha should right-click the hyperlink, choose Edit Hyperlink to modify or Remove Hyperlink to delete it.