Class 10 Information Technology (402)
Important Questions 2026–27
High-Level, Competency-Based, Case-Based and CBSE Paper Practice
50 Questions
Answers in Dropdown
CBSE Pattern
Full English
1400px Autofit
Based on the CBSE 2026–27 Curriculum:
Digital Documentation – Advanced Writer, Electronic Spreadsheet – Advanced Calc, Database Management System – LibreOffice Base, and Healthy, Safe and Secure Working Environment.
Practice Strategy:
These questions focus on application, reasoning, situation-based learning and competency-based problem solving. Click the answer dropdown below each question to view the answer.
Digital Documentation – Advanced Writer, Electronic Spreadsheet – Advanced Calc, Database Management System – LibreOffice Base, and Healthy, Safe and Secure Working Environment.
Practice Strategy:
These questions focus on application, reasoning, situation-based learning and competency-based problem solving. Click the answer dropdown below each question to view the answer.
UNIT 1 – DIGITAL DOCUMENTATION (ADVANCED)
Question 1 HIGH LEVEL
A student manually formats all Heading 1 entries in a document using bold, blue colour and 18-point font. Later, the student needs to change the formatting of all headings. What is the most efficient method?
View Answer
Answer: Modify the Heading Style. When a style is modified, the formatting of all text using that style is updated automatically.
Question 2 COMPETENCY
A 50-page project report contains properly arranged headings and subheadings. The student wants to create a contents page automatically and update it whenever page numbers change. Which feature should be used?
View Answer
Answer: Table of Contents. It creates a contents page based on heading styles and can be updated whenever the document changes.
Question 3 CASE BASED
A teacher sends a document to a student for review. The student makes several changes. The teacher wants to identify who made each change and accept or reject the changes. Which feature should be used?
View Answer
Answer: Track Changes. It records modifications made in a document and allows the reviewer to accept or reject them.
Question 4
In Writer, a student wants the text to flow around an inserted image. Which option is required?
View Answer
Answer: Text Wrapping. It controls how text flows around an image.
Question 5 HIGH LEVEL
A school has prepared a standard report format that must be used every month by different teachers. What should be created to avoid designing the format repeatedly?
View Answer
Answer: A Template. A template stores predefined formatting and structure for repeated use.
Question 6
Which Writer feature can be used to apply the same formatting quickly to several different places in a document?
View Answer
Answer: Fill Format. It helps apply a selected style or formatting to multiple areas quickly.
Question 7
A teacher has two versions of a report and wants to identify the differences between them. Which feature is suitable?
View Answer
Answer: Compare Documents. It identifies differences between two document versions.
Question 8 APPLICATION
A student updates a Heading 1 entry, but the new heading does not appear in the Table of Contents. What should the student do?
View Answer
Answer: Update the Table of Contents. It must be refreshed after changes are made to the document structure.
Question 9
Which image-positioning concepts are relevant when an image must be placed properly in a Writer document and move with the paragraph?
View Answer
Answer: Arrangement, Anchoring, Alignment and Text Wrapping are the relevant image-positioning concepts.
Question 10 CBSE STYLE
A student wants all main headings in a document to look consistent and wants to update all of them by making a change in only one place. What should be used instead of direct formatting?
View Answer
Answer: Styles should be used. Styles maintain consistency and make global formatting changes easy.
UNIT 2 – ELECTRONIC SPREADSHEET (ADVANCED)
Question 11 VERY HIGH LEVEL
A shop owner wants to know how many units must be sold to achieve a monthly profit of ₹50,000. The number of units is an input and profit is the output. Which Calc tool is most suitable?
View Answer
Answer: Goal Seek. It finds the required input value for achieving a specified output.
Question 12 CASE BASED
A company wants to compare three situations: Low Sales, Normal Sales and High Sales. Sales, expenses and profit change in each situation. Which feature is most useful?
View Answer
Answer: Scenario. Scenarios store different sets of input values for What-If Analysis.
Question 13
January, February and March data is stored in separate sheets with the same structure. The manager wants to prepare one consolidated summary. Which facility should be used?
View Answer
Answer: Consolidating Data. It combines data from multiple sources into a summary.
Question 14 HIGH LEVEL
A spreadsheet contains thousands of sales records. The manager wants to view the total sales for each department. Which Calc feature is most suitable?
View Answer
Answer: Subtotals. They calculate summary values for grouped data.
Question 15
Which feature can be used to execute a repetitive spreadsheet task automatically instead of performing it manually every time?
View Answer
Answer: Macro. A macro automates repetitive tasks.
Question 16 APPLICATION
A workbook contains student marks in Sheet1 and attendance in Sheet2. The attendance value must be displayed in Sheet1. Which concept is required?
View Answer
Answer: Reference to another sheet. A cell in one sheet can refer to a value stored in another sheet.
Question 17
A spreadsheet must contain a clickable link to an external document or website. Which feature should be used?
View Answer
Answer: Hyperlink. It provides quick access to another document, sheet or website.
Question 18 COMPETENCY
Four employees have made changes to a shared spreadsheet. The manager wants to review the changes and accept or reject each one. Which feature should be used?
View Answer
Answer: Review Changes. It allows the user to inspect modifications and accept or reject them.
Question 19
A reviewer wants to add additional information about a cell without changing the main data. What should be used?
View Answer
Answer: Comment. A comment adds explanatory information without changing the cell value.
Question 20 HIGH LEVEL
A business manager wants to compare expected profit under different assumptions in the same spreadsheet model. Which approach is most appropriate?
View Answer
Answer: What-If Analysis using Scenarios. It compares possible outputs under different input assumptions.
UNIT 3 – DATABASE MANAGEMENT SYSTEM
Question 21 VERY IMPORTANT
A school database contains StudentID, Name, Class and MobileNo fields. Which field is most suitable as the primary key for uniquely identifying each student?
View Answer
Answer: StudentID. It can uniquely identify each student.
Question 22
What is a complete row containing the information of one student in a database table called?
View Answer
Answer: Record. A record is a complete row of related field values.
Question 23
What are columns such as StudentName, RollNo, Class and Marks called in a database?
View Answer
Answer: Fields. The columns of a database table are called fields.
Question 24 HIGH LEVEL
Table A contains StudentID and Name. Table B contains StudentID and Marks. The two tables must be connected using StudentID. What type of key can StudentID be in Table B?
View Answer
Answer: Foreign Key. It refers to the primary key of a related table.
Question 25 CONCEPTUAL
A database contains a large amount of information, but the user needs only the records of Class 10 students. Which object can retrieve the required records using a condition?
View Answer
Answer: Query. It retrieves records according to specified conditions.
Question 26
Which database object provides a user-friendly interface for entering and updating student details?
View Answer
Answer: Form. It makes data entry and editing easier.
Question 27 CASE BASED
The principal wants a printable list of only those students whose marks are above 80. Which combination is most appropriate?
View Answer
Answer: Query and Report. The query filters the required students, and the report presents the selected data in a printable format.
Question 28
What is the main characteristic of a hierarchical database model?
View Answer
Answer: It uses a tree-like parent-child structure to organise data.
Question 29
How is data generally organised in a relational database?
View Answer
Answer: Data is organised in related tables.
Question 30 HIGH LEVEL
Why is it risky to use Name as the primary key if two students in a database can have the same name?
View Answer
Answer: A primary key must be unique. Since two students may have the same name, StudentID or RollNo should be used instead.
Question 31
What is the main difference between data and information?
View Answer
Answer: Data consists of raw facts or values, whereas information is processed and meaningful data used for decision-making.
Question 32 CBSE COMPETENCY
A library database contains BookID, BookName and Author fields. The librarian wants a list of books written by “A. Sharma”. Which database object should be used first?
View Answer
Answer: Query. A condition such as Author = “A. Sharma” can be applied to retrieve the required records.
Question 33
A school creates a table in Base for student information and a separate screen for entering data. Which database object is this screen?
View Answer
Answer: Form. A form provides a convenient interface for entering and editing table data.
UNIT 4 – HEALTHY, SAFE AND SECURE WORKING ENVIRONMENT
Question 34 CASE BASED
An employee works continuously on a computer with an incorrect posture and develops neck and back pain after a few months. What type of workplace risk is involved?
View Answer
Answer: Ergonomic risk. Incorrect posture and improper workstation setup can cause ergonomic problems.
Question 35
A damaged electrical wire is found in the workplace. What is the safest action?
View Answer
Answer: Report the hazard and ask a qualified person to repair it. Do not attempt to repair damaged electrical equipment yourself.
Question 36 HIGH LEVEL
After identifying a hazard during risk assessment, what is the next important objective?
View Answer
Answer: Evaluate and control the risk by applying suitable control measures.
Question 37
What should an employee prioritise first during a fire emergency in an office?
View Answer
Answer: Personal safety and the emergency procedure should be prioritised. The employee should follow the alarm and evacuate through the safe route.
Question 38
Why is it unsafe to keep liquids near computers in a computer laboratory?
View Answer
Answer: Liquid can cause short circuits, electric shock, equipment damage or fire if it comes into contact with electrical equipment.
Question 39 COMPETENCY
An employee experiences eye strain because the computer screen is placed too close or too far away. What preventive approach should be followed?
View Answer
Answer: Use proper workstation ergonomics, maintain a suitable screen distance and height, ensure proper lighting and take regular breaks.
Question 40
Why is it important to report a hazard in the workplace?
View Answer
Answer: Reporting hazards helps prevent accidents, allows corrective action and improves workplace safety.
MIXED HIGH-LEVEL AND CBSE PAPER PRACTICE
Question 41 CASE BASED
A school has a Student table and a Marks table. The principal wants a report of only those Class 10 students who scored more than 75 marks. What is the correct workflow?
View Answer
Answer: Create a condition-based Query first and then create a Report to present the selected records in an organised and printable format.
Question 42 HIGH LEVEL
A company needs to prepare a monthly report. It uses Writer for the standard format, Calc for automatic calculations and Base for employee records. How can these tools be used in an integrated workflow?
View Answer
Answer: Use Writer for documentation and formatting, Calc for calculations and data analysis, and Base for storing, querying and reporting structured employee data.
Question 43
In a spreadsheet model, changing Sales changes Profit. The manager wants to find the Sales value required to achieve a target profit. Should Scenario or Goal Seek be used? Give a reason.
View Answer
Answer: Goal Seek should be used because the desired output, Profit, is known and the required input, Sales, must be calculated.
Question 44
A manager wants to compare three possible input combinations and view the result of each combination. Which feature is more suitable than Goal Seek?
View Answer
Answer: Scenario or What-If Analysis is more suitable because it compares results for different predefined input combinations.
Question 45 VERY HIGH LEVEL
A document has inconsistent formatting because every heading was formatted manually. What is a better long-term strategy for maintaining the document?
View Answer
Answer: Use Heading and Paragraph Styles. They maintain consistency and make future global changes easier.
Question 46 CASE BASED
A team is working on a shared spreadsheet. One member changes an incorrect value, and a reviewer needs to identify and reject the change. Which two features are most relevant?
View Answer
Answer: Record Changes and Review Changes. The first tracks modifications, while the second allows the reviewer to inspect and accept or reject them.
Question 47
Which two main properties should be considered when selecting a primary key in a database?
View Answer
Answer: The primary key should be unique and should reliably identify each record. Duplicate values should not be allowed.
Question 48 APPLICATION
A school administrator wants to make database data entry easy and also wants to provide the principal with a formatted printable output. Which two Base objects should be used?
View Answer
Answer: Use a Form for easy data entry and a Report for formatted printable output.
Question 49 INTEGRATED CASE STUDY
A school is preparing an annual performance project. Student data is stored in Base, marks analysis is performed in Calc and the final report is prepared in Writer. If the marks data is already available in multiple sheets, which Calc facility can be useful?
View Answer
Answer: Consolidating Data can be used to prepare a summary from multiple sheets or data sources. The final documentation can then be prepared in Writer.
Question 50 SUPER HIGH LEVEL
A school wants an efficient digital workflow. It needs a standard report format, comparison of different marks-analysis situations, calculation of the input required for a target result, structured student data and safe workplace practices. Which concepts should be used?
View Answer
Answer:
1. Writer: Templates and Styles for standard documentation.
2. Calc: Scenarios or What-If Analysis for comparing different situations.
3. Calc: Goal Seek for finding the input required to achieve a target result.
4. Base: Tables, Queries, Forms and Reports for structured data management.
5. Workplace Safety: Ergonomics, hazard identification, risk assessment and emergency procedures for a safe working environment.
This combination demonstrates software knowledge, real-world problem solving and competency-based IT skills.
1. Writer: Templates and Styles for standard documentation.
2. Calc: Scenarios or What-If Analysis for comparing different situations.
3. Calc: Goal Seek for finding the input required to achieve a target result.
4. Base: Tables, Queries, Forms and Reports for structured data management.
5. Workplace Safety: Ergonomics, hazard identification, risk assessment and emergency procedures for a safe working environment.
This combination demonstrates software knowledge, real-world problem solving and competency-based IT skills.
