i) Statement 1: Feedback is an important part of the communication cycle because it shows whether the receiver has understood the message.
Statement 2: Communication is complete even if the receiver does not understand the message and provide feedback.
Choose the correct option:
a) Both Statement 1 and Statement 2 are false
b) Both Statement 1 and Statement 2 are true
c) Statement 1 is false and Statement 2 is true
d) Statement 2 is false and Statement 1 is true
ii) Which of the following is an example of computer hardware?
a) Operating System
b) Keyboard
c) Application software
d) Web browser
iii) Which action reflects an individual's role towards sustainable development?
a) Wasting water because it is renewable
b) Increasing the use of disposable plastic
c) Protecting natural resources and reducing pollution
d) Ignoring environmental problems
iv) Which of the following is a type of motivation?
a) Internal
b) External
c) Both a) and b)
d) Intermediate
v) Several entrepreneurs selling mobile phones in the same market are likely to:
a) Increase competition and potentially benefit customers
b) Eliminate all customer choices
c) Stop all innovation
d) Prevent businesses from identifying market needs
vi) Which of the following is an example of an initiative that reduces plastic waste?
a) Switching from paper cups to plastic cups for better durability
b) Using clay pots (kulhads) instead of plastic and paper cups
c) Replacing plastic straws with biodegradable plastic straws
d) Recycling plastic waste into new plastic packaging
Q.2 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Setting a numeric field's AutoValue property to "Yes" means:
a) The field will always remain blank
b) The field automatically receives auto-numeric values
c) The field becomes a primary key automatically
d) The field will store only text
ii) What is the full form of DoIT?
a) Department of Information Technology
b) Division of Information Transfer
c) Directorate of Internet Technologies
d) Division of Integrated Telecommunications
iii) To rename a worksheet tab, you can do all of the following EXCEPT:
a) Double-click the worksheet tab name
b) Right-click on the sheet tab and select the Rename Sheet option
c) Click on Sheet menu and then select Rename Sheet option
d) Press Ctrl+R
iv) Which data model organises data in tree-like structure?
a) Network data model
b) Hierarchical data model
c) Relational data model
d) Client data model
v) On the Entries tab of the Table of Contents, Index or Bibliography dialog box, which button on the Structure line represents the page number?
a) E
b) E#
c) T
d) #
vi) Under which menu is the Consolidate option available?
a) View
b) Tool
c) Insert
d) Data
Q.3 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) What is the primary purpose of water quality monitoring?
a) To measure temperature
b) To check for contamination and ensure safe drinking water
c) To identify the type of fish in a water body
d) To check for water colour
ii) Which of the following is NOT one of the style types supported by OpenOffice.org?
a) Page styles
b) Frame styles
c) Macro styles
d) List styles
iii) Which feature allows a spreadsheet to perform a repeated task automatically?
a) Macro
b) Solver
c) Scenario
d) Hyperlink
iv) Which clause is used to specify conditions for the rows retrieved by a SELECT statement?
a) ORDER BY
b) WHERE
c) FROM
d) SET
v) Which pair is correctly matched?
a) Smooth - softens the contrast of the image
b) Sharpen - removes single pixels from the image
c) Remove Noise - increases the contrast of the image
d) Solarization - brings the impact of time with age
vi) In a relational database, data is primarily organised in the form of:
a) Slides
b) Tables
c) Frames
d) Paragraphs
Q.4 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) Identify the incorrect statements:
Statement 1: Class A Materials include substances like wood, cloth, and paper.
Statement 2: Class B Materials refers to electrical materials and equipment that can cause fires quickly.
Statement 3: Class C Materials: This category encompasses liquids, greases, and gases that readily burn when exposed to an ignition source.
a) Statements 1 and 2 are incorrect
b) Statements 1 and 3 are correct
c) Statements 2 and 3 are incorrect
d) Statements 1 and 2 are correct
ii) Which feature is specifically designed to find the value of a variable required to achieve a particular target value?
a) Scenario Manager
b) Goal Seek
c) Data Consolidation
d) Macro
iii) A teacher wants to retrieve all columns from SDetails and arrange the records according to RollNo in ascending order. Which query is correct?
a) SELECT * FROM SDetails WHERE RollNo ASC;
b) SELECT * FROM SDetails ORDER BY RollNo ASC;
c) SELECT RollNo ASC FROM SDetails;
d) SELECT * FROM SDetails SORT BY RollNo;
iv) You are using the Report Wizard and need to specify whether the report should automatically reflect changes made to the table. Which option should you choose?
a) Static report
b) Dynamic report
c) Print preview report
d) Simple report
v) Which SQL command is primarily used to retrieve records from a database?
a) UPDATE
b) DELETE
c) SELECT
d) INSERT
vi) A spreadsheet has several unknown variables and constraints and the user wants to maximize or minimize a result. Which tool should be preferred?
a) Goal Seek
b) Solver
c) Sort
d) Filter
Q.5 Answer any 5 out of the given 6 questions (1X5=5 marks)
i) A school wants to send the same invitation letter to 500 parents, but with each parent's name and address appearing differently. Which feature is most appropriate?
a) Template
b) Mail Merge
c) Table of Contents
d) Character Style
ii) Consider the following statements:
Statement 1: Field Type option allows you to specify the data type for each field.
Statement 2: Field properties control how data is handled in a database.
Statement 3: Auto value sets a predefined value for new records in the field.
Which option is correct?
a) Statements 1 and 2 are correct
b) Statements 2 and 3 are correct
c) Statements 1 and 3 are correct
d) All three statements are correct
iii) Which key uniquely identifies a record in a table?
a) Foreign key
b) Primary key
c) Candidate value
d) Field value
iv) Which of these is a common symptom of musculoskeletal problems in the office?
a) Skin rash
b) Neck and shoulder pain
c) Sneezing
d) Increased energy
v) Which of the following is NOT listed as a basic fire safety rule at the workplace?
a) Install fire escape plans at proper levels
b) Conduct regular drills
c) Keep workplace a no-smoking zone
d) Allow storage of flammable material near electrical equipment
vi) Examine the statements and mark the correct option:
Statement 1: Loading styles from a template allows users to apply predefined formatting to their current document.
Statement 2: The Load Styles from Template option is used to copy styles from another document or template into the current document.
a) Statement 1 is correct, Statement 2 is correct
b) Statement 1 is incorrect, Statement 2 is incorrect
c) Statement 1 is correct, Statement 2 is incorrect
d) Statement 1 is incorrect, Statement 2 is correct
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 What are the 7 Cs of effective communication?
Ans:
Q.7 What is self-awareness? Why is it important?
Ans:
Q.8 Why is taking responsibility an important entrepreneurial quality?
Ans:
Q.9 Why should daily activities be divided into "Must Do", "Should Do" and "Nice to Do"?
Ans:
Q.10 State any 4 myths about entrepreneurship.
Ans:
Answer any 4 out of the given 6 questions (2X4=8 marks) Answer each question in 20 – 30 words.
Q.11 What are occupational hazards? Mention any two types.
Ans:
Q.12 What is referential integrity? State one situation that it helps to avoid.
Ans:
Q.13 Differentiate between styles and templates.
Ans:
Q.14 List the purposes to create a hyperlink in a spreadsheet.
Ans:
Q.15 What is Scenario Manager? How is it useful in analysing different possible outcomes?
Ans:
Q.16 A user has created a document with several headings and subheadings. Instead of manually typing the contents and page numbers, which feature should be used and what must be done for it to work correctly?
Ans:
Answer any 3 out of the given 5 questions (4X3=12 marks) Answer each question in 50 – 80 words.
Q.17 Define reports in a database and write the steps to insert the date and time in a report.
Ans:
Q.18 A database contains an SDetails table. The teacher wants to display only students whose favourite colour is Blue and then arrange the displayed records according to RollNo in ascending order. Write the appropriate SQL statement and explain the purpose of the WHERE and ORDER BY clauses.
Ans:
Q.19 Explain the anchoring options available in LibreOffice Writer.
Ans:
Q.20 A business owner wants to determine how much should be invested in two funds to achieve a specified total interest while obeying investment constraints. Explain why Solver is more appropriate than Goal Seek for this situation. Also describe the major steps involved in setting up Solver.
Ans:
Q.21 a) What is a healthy lifestyle?
b) Mention any four components of a healthy lifestyle.
Ans:
In this post, a comparison of step-based questions for MS Office and OpenOffice is provided, including MS Word vs OpenOffice Writer, MS Excel vs OpenOffice Calc, and MS Access vs OpenOffice Base. So, make sure to revise this for OpenOffice preparation.
Download Now - Class 10 IT 402 Sample Pre-Board Question Paper with Solution
Year wise Pre-Board and CBSE Sample Question Papers with Solution – Class 10 Information Technology (Code 402)
CBSE Class 10 IT 402 Sample QP 2026-27 with Solution
CBSE Class 10 IT 402 Sample Pre-Board QP 2026-27 Set 1 with Solution