CBSE Sample Papers for Class 10 IT Set 7 with Solutions

Time: 2 Hours Maximum Marks: 50

Instructions:
 Please read the instructions carefully.
 This Question Paper consists of 21 questions in two sections: Section A & Section B.
 Section A has Objective Type Questions whereas Section B contains Subjective Type Questions.
 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.
 All questions of a particular section must be attempted in the correct order.
 Section A: Objective Type Questions (24 Marks)

 This section has 5 questions.

 Marks allotted are mentioned against each question/part.
 There is no negative marking.
 Do as per the instructions given.
 Section B: Subjective Type Questions (26 Marks)
 This section has 16 questions.
 A candidate has to do 10 questions.
 Do as per the instructions given.
 Marks allotted are mentioned against each question/part.

Section A
Objective Type Questions [24 Marks]

Question 1.
Answer any 4 out of the given 6 questions on Employability Skills. (4×1=4)
(i) Rita is giving a presentation but keeps looking away from the audience, folds her arms tightly and
avoids eye contact. What type of communication is Rita failing to use effectively?
(a) Verbal Communication (b) Visual Communication (c) Non-verbal Communication
(d) Written Communication
Answer:
(i) (c) Non-verbal Communication

(ii) What is the first step to demonstrate independent working skills effectively?
(a) Avoid all responsibilities (b) Wait for detailed instructions (c) Set a clear goal and make a plan
(d) Ask a friend to do the task
Answer:
(c) Set a clear goal and make a plan

(iii) Raghav always makes a daily schedule, sets small goals and tracks his progress to complete
homework on time. This is an example of _________.
(a) procrastination (b) goal-oriented planning (c) external motivation (d) time wastage
Answer:
(b) goal-oriented planning

(iv) A …………. is a system software that manages hardware and software resources and provides services
for computer programs.
(a) File Manager (b) Operating System (c) Anti-virus (d) Web browser
Answer:
(b) Operating System
(v) Reading or hearing about success stories of first-generation entrepreneurs helps students to –
(a) copy their business idea. (b) understand entrepreneurial challenges and gain inspiration.
(c) give up early. (d) avoid planning.
Answer:
(b) Understand entrepreneurial challenges and gain inspiration.

(vi) Which of the following best defines sustainable development?

(a) Rapid use of natural resources for profit.
(b) Development that meets current needs without harming future generations.
(c) Development focused only on industries.
(d) Development without using any resources.
Answer:
(b) Development that meets current needs without harming future generations.

Question 2.
Answer any 5 out of the given 6 questions. (5×1=5)

(i) Reena inserted a drawing object in her document. She wants to duplicate it multiple times without
redrawing. Which option should she use?
(a) Copy and Paste (b) Insert Object (c) Clone Formatting (d) Redraw Tool
Answer:
(a) Copy and Paste

(ii) Arjun is preparing a brochure and wants to organise multiple objects together as a single unit. Which
option should he use?
(a) Align (b) Anchor (c) Group (d) Wrap
Answer:
(c) Group

(iii) Which one is not a valid method to insert an image into Writer?
(a) Insert → Image (b) Drag and Drop (c) Copy and Paste (d) Link from Clipboard
Answer:
(d) Link from Clipboard

(iv) What is the purpose of Fill Format in Styles and Formatting?

(a) Deletes a style (b) Creates a paragraph (c) Applies a style quickly to multiple items
(d) Resets styles
Answer:
(c) Applies a style quickly to multiple items.

(v) What is the purpose of hierarchy in headings?

(a) It stores passwords. (b) It determines the print size.
(c) It helps in generating the Table of Contents. (d) It renames the title.
Answer:
(c) It helps in generating the Table of Contents.

(vi) Dev wants to update an existing style after changing text formatting. Which method should he use?
(a) Load Style b) Update Style from Selection (c) Clone Style (d) Fill Format
Answer:
(b) Update Style from Selection
Question 3.
Answer any 5 out of the given 6 questions. (5×1=5)

(i) In LibreOffice Calc, which option is used to merge data from multiple sheets into a single sheet?
(a) Goal Seek (b) Sort (c) Consolidate (d) Format Cells
Answer:
(c) Consolidate
A. Mistake Alert:----Some students confuse consolidate with sort-sorting doesn’t combine data across
sheets.

(ii) What-if scenarios are useful for ________.

(a) sorting data. (b) data entry. (c) exploring different outcomes based on varying inputs.
(d) printing documents.
Answer:
(c) Exploring different outcomes based on varying inputs

(iii) Which menu in LibreOffice Calc is used to run a recorded macro?

(a) File → Open (b) Tools → Macros → Run Macro (c) Insert → Macro (d) View → Record Macro
Answer:
(b) Tools → Macros → Run Macro

(iv) When you use a complete file path in a hyperlink, it is known as

(a) Relative hyperlink (b) Absolute hyperlink (c) External hyperlink
(d) Document hyperlink
Answer:
(b) Absolute hyperlink

(v) Which option is used to compare two different versions of the same spreadsheet file in Calc?
(a) Merge Document (b) Combine Cells (c) Compare Document (d) Scenario Manager
Answer:
(c) Compare Document

(vi) In Calc, which feature allows you to view the list of changes made by different users in a shared
spreadsheet?
(a) Share Document (b) Accept or Reject Changes (c) Insert Comment (d) Goal Seek
Answer:
(b) Accept or Reject Changes

Question 4.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) What is the main function of a report in Libre Office Base?
(a) To enter data (b) To edit records (c) To present data in printable format (d) To relate tables
Answer:
(c) To present data in printable format

(ii) Which of the following is an object in a Base database?

(a) Slide (b) Cell (c) Table (d) Cell group
Answer:
(c) Table

(iii) Which control in a form is used to display a list of predefined options?

(a) Label (b) Combo Box (c) Button (d) Text Box
Answer:
(b) Combo Box
(iv) What kind of key is used to link two related tables?
(a) Display Key (b) Secondary Key (c) Foreign Key (d) Data Key
Answer:
(c) Foreign Key

(v) Which form control allows users to add a command button like Submit?
(a) Text Box (b) Push Button (c) Label (d) Option Box
Answer:
(b) Push Button

(vi) In the Form Design, to make the form visually appealing, you can use
(a) Macros (b) Query Wizard (c) Label and Formatting tools (d) SQL command
Answer:
(c) Label and Formatting tools

Question 5.
Answer any 5 out of the given 6 questions. (5×1=5)
(i) What is the first step in handling an accident at the workplace?
(a) Fill out a report (b) Take photos (c) Attend to the injured person
(d) Post on notice board
Answer:
(c) Attend to the injured person

(ii) Which of these is considered a physical hazard?

(a) Improper lighting (b) Poor air quality (c) Excessive screen time (d) High stress level
Answer:
(a) Improper lighting

(iii) What is the full form of OHS?

(a) Occupational Health and Security (b) Occupational Health and Safety
(c) Office Health Service (d) Organizational Health Standard
Answer:
(b) Occupational Health and Safety

(iv) An accident caused by a box falling from a shelf is an example of _________.

(a) Trip hazard (b) Slipping hazard (c) Falling object hazard (d) Health hazard
Answer:
(c) Falling object hazard

(v) A safety checklist is important because ________.

(a) it increases paperwork. (b) it reduces productivity.
(c) it ensures hazards are identified and prevented. (d) it replaces fire drills.
Answer:
(c) It ensures hazards are identified and prevented.

(vi) Water on the office floor is an example of a_________.

(a) Fire hazard (b) Health hazard (c) Slipping hazard (d) Noise hazard
Answer:
(c) Slipping hazard
 Section B
Subjective Type Questions [26 Marks]

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

Question 6.
What are the three basic methods of communication?
Answer:
The three basic methods of communication are verbal, non-verbal and visual. Verbal includes spoken or
written words. Non-verbal involves gestures, facial expressions, posture and body language. Visual
communication uses images, graphs and charts. These methods help convey messages effectively in
different contexts and situations.

Question 7.
How do vacations and holidays help in stress management?
Answer:
Vacations and holidays help reduce stress by providing a break from daily routines and work pressure.
Spending time with family and friends, exploring new places, and relaxing in a peaceful environment
refresh the mind, improve mood, and boost mental health, making it easier to return to tasks with
renewed energy.

Question 8.
What is a maintenance schedule for a computer and why is it needed?
Answer:
A maintenance schedule outlines regular tasks like software updates, disk cleanup, scanning for viruses,
and cleaning hardware. It helps in early detection of issues, improves performance and reduces repair
costs. Regular maintenance ensures smooth functioning and a longer life span of the computer system.

Question 9.
How does entrepreneurship help in solving social problems?
Answer:
Entrepreneurship helps solve social problems by creating products and services that address community
needs-like education, health, sanitation and employment. Social entrepreneurs focus on improving lives
rather than just earning profit. Their innovative ideas lead to long-term, sustainable changes in society.

Question 10.
Suggest two ways to overcome problems in sustainable development.
Answer:
(i) Awareness and Education Teach people the importance of conservation and responsible use of
resources.
(ii) Use of Clean Technology Adopt renewable energy sources like solar and wind power to reduce
pollution and carbon emissions, supporting sustainable growth.

Answer any 4 out of the given 6 questions in 20-30 words each. (4×2=8)
Question 11.
What is the Frame Style category in LibreOffice Writer?
Answer:
Frame styles in LibreOffice Writer are used to format text frames, graphics and other objects. These styles
control attributes like borders, background colour, text wrapping and positioning. By applying a frame
style, users can ensure consistency across all inserted frames or images in a document, making
formatting efficient and visually uniform.
Question 12.
What is Data Consolidation in Calc? How can it be useful while working with multiple sheets?
Answer:
Data Consolidation in Calc is used to combine data from multiple sheets into one summary sheet. It
allows users to apply functions like Sum, Average, Count, etc., across ranges from different sheets. This is
useful when data is spread across departments or time periods and a unified report is needed.
Consolidation helps in quicker analysis and accurate comparisons of collected data.

Question 13.
What do you understand by the term Macro as a Function? Give one advantage of using it.
Answer:
Macro as a Function refers to the use of a recorded or written macro that behaves like a built-in function
in Calc. It can take inputs (arguments), perform calculations or tasks and return outputs. This allows
users to automate repetitive tasks within formulas. One major advantage is the ability to customise
actions beyond what standard Calc functions offer, saving time and reducing errors.

Question 14.
What are the main features of LibreOffice Base interface?
Answer:
The LibreOffice Base interface includes components such as the Database pane, Tasks pane and Object
pane. The Database pane allows users to access Tables, Queries, Forms and Reports. The Tasks pane
provides quick actions like creating or opening tables. The layout is user-friendly and helps users
navigate between different database objects smoothly, making tasks like data entry, querying and report
creation efficient and accessible.

Question 15.
What are two key safety practices to follow while using a computer for long hours?
Answer:
When using a computer for extended periods, it’s important to maintain proper posture-sit upright with
your back supported and feet flat on the floor. Position the monitor at eye level and about an arm’s length
away. Use a wrist rest while typing and take regular breaks to stretch and relax your eyes. These
practices help prevent musculoskeletal problems, eye strain and fatigue.

Question 16.
What actions should you take if someone receives an electric shock at the workplace?
Answer:
If someone gets an electric shock, do not touch the person with bare hands. First, turn off the power
source or unplug the equipment if it’s safe to do so. Use a non-conductive object, like a wooden stick, to
separate the person from the electrical source. Call emergency services immediately. Provide first aid if
trained, and stay with the person until help arrives. Always follow workplace electrical emergency
protocols.

Answer any 3 out of the given 5 questions in 50-80 words each. (3×4=12)
Question 17.
(a) Describe how to use the Image Toolbar to crop an image in Writer.
Answer:
Click on the inserted image to activate the Image Toolbar. Then, click on the ‘Crop’ icon. Adjust the crop
lines around the image to remove unwanted parts. Click outside the image to apply the crop. Cropping
helps in focusing on specific parts of the image and removing unnecessary elements, improving the
document’s clarity and presentation.
(b) Explain the importance of hierarchy of headings in a document.
Answer:
The hierarchy of headings in Writer ensures a logical structure in the document. Heading 1 is typically
used for main sections, Heading 2 for subsections and so on. This hierarchy helps in creating a well-
organised Table of Contents and allows readers to navigate large documents efficiently. It also enhances
readability and maintains consistency in formatting.

Question 18.
Mr. Prakash handles sales data for four branches. He uses multiple sheets and now wants better linking,
editing tracking and user collaboration.
(a) How can he create links from the summary sheet to each branch’s worksheet?
(b) Prakash wants to track team edits in the sales file. What can he do?
(c) A new team member wants to update the spreadsheet but needs to know which cells are editable.
What should be done?
(d) To find the effect of a discount on revenue, which tool should Prakash use?
Answer:
(a) He can use Insert → Hyperlink → Document → select the target sheet. This allows him to navigate
quickly between sheets from a summary dashboard.

(b) He should use Track Changes → Record, then use Manage Changes to see who made what edits and
approve them accordingly.

(c) Prakash can protect the spreadsheet and allow editing only for certain cells using Tools → Protect
Sheet and unprotecting specific ranges.

(d) He can use the What-If Analysis or Goal Seek to analyse how a change in discount affects the overall
revenue target.

Question 19.
An inspection revealed poor sanitation and low indoor air quality in your office. Management wants
immediate improvements and awareness sessions on cleanliness and air quality.
(a) Why is maintaining clean air and water important in workplaces?
Answer:
Clean air and water are essential to prevent the spread of infections and promote good health among
employees. Poor indoor air can cause headaches, fatigue and respiratory issues, while unsafe drinking
water may lead to serious illnesses. A hygienic environment increases productivity, morale and reduces
sick leaves. Ensuring regular cleaning of air filters, proper ventilation, and clean water supply supports a
healthy and efficient workplace environment.

(b) Give two workplace cleanliness practices that promote health.

Answer:
Regular cleaning of high-touch surfaces like keyboards, doorknobs and desks helps prevent the spread of
bacteria and viruses. Proper waste disposal, especially in pantry and restroom areas, prevents pest
infestations. Ensuring restrooms are well-stocked with soap and tissues also supports hygiene.
Implementing daily cleaning schedules and educating staff about personal hygiene contribute to a safer
and cleaner office environment, leading to better employee health and satisfaction.

Question 20.
(a) Define a primary key. Why is it important in a table?
Answer:
A primary key is a unique identifier for each record in a table. It ensures that no two rows have the same
value in the primary key column. This helps in maintaining the integrity of the data and establishes
relationships between tables in a relational database. Without a primary key, identifying and linking data
accurately becomes difficult, which can lead to duplication or inconsistencies.

(b) Explain the difference between using a wizard and design view to create a table.
Answer:
When using a wizard to create a table, LibreOffice Base guides users step-by-step through predefined
templates and options, making it suitable for beginners. In contrast, Design View allows more control,
enabling users to define custom fields, data types and constraints manually. Design View is preferred by
advanced users for complex table structures and for customising field properties beyond what the wizard
offers.

Question 21.
Consider the following table:
Book_ID Title Author Price
B101 Science Wonders A. Verma 350
B102 World Geography K. Sharma 400
B103 Science Wonders A. Verma 350
(a) Suggest a suitable data type for the Book_ID and Price fields.
Answer:
(a) Suggested Data Types
 Book_ID Character/Varchar (to store alphanumeric book IDs like B101)
 Price Decimal/Numeric (to store precise price values, e.g., 350.00)

(b) Which field should be set as the primary key and why?
Answer:
Primary Key Selection
 Field Book_ID
 Justification Book_ID uniquely identifies each book (no duplicates), is non-null and remains
constant (unlike titles or authors, which may repeat).

(c) Identify a possible alternate key and justify.

Answer:
Alternate Key
 Field Title + Author + Price combination
 Reason While titles and authors may repeat individually (e.g., Science Wonders by A. Verma), the
combination with Price ensures uniqueness, as no two books share the same title, author and price.

(d) How many attributes and records are present?

Answer:
Table Structure Analysis
 Attributes (Columns) 4 (Book_ID, Title, Author, Price)
 Tuples (Records) 3 (Rows for B101, B102, B103)

************