NEW
Font size
WorksheetsInformation Technology – Class X Worksheet
Total questions: 60
Worksheet time: 30mins
Which of the following is not an example of ignition sources of open flames?
Gas ovens
Lighters in smoking areas
Welding torches
Space heaters
Which action contributes to a healthy and safe working environment?
Keeping emergency exits clear
Leaving cables loose on the floor
Ignoring safety warnings
Using unapproved software
Aisha moved from Egypt to Germany for work but finds it difficult to adjust because she is not familiar with German customs and workplace etiquette, which affects her interactions with colleagues. This situation illustrates a:
Interpersonal barrier
Cultural barrier
Physical barrier
Linguistic barrier
Regular care and maintenance of computer is required
to avoid a condition of System Failure
so that system works efficiently
all of these
to detect any issues at an early stage
Which of the following are misconception about Entrepreneur?
All of these
A person needs a lot of money to start a business.
Entrepreneurs are born, not made.
A person having a big business is an entrepreneur.
Most of our day-to-day reading it done ________.
Loudly
Extensively
Silently
Intensively
Which organization has made the Sustainable Development Goals?
United Nations
UNICEF
League of Nations
World Health Organisation
How many methods are there to insert an image from file?
4
3
6
5
The default tab space is ________.
0.5
1.25
1.50
1.15
Color toolbar allows us to change
All of these
RGB Color Components
Gamma effect of image
Brightness
Which of the following setting is not used for positioning of graphic?
Alignment
Caption
Arrange
Wrap
Ananya wants that her company's logo should automatically appear on the top of the Writer document whenever she opens a new document. Which feature of Writer will help her to do so?
All of these
Style
Automatic
Template
The E# button in Entries tab of Insert Index/Table represent.
Entry Text
Chapter number
Tab Stop
Page Number
When you want to insert a blank imbedded excel object in a word document you can:
click the create worksheet button on the formatting toolbar
click the import excel command on the file menu.
click the object command on the insert menu
click the office links button on the standard toolbar
Which one is not a function in MS Excel?
MIN
MAX
SUM
AVG
Which of the following key is used for help in MS Excel?
F3
None of these
F2
F1
You can activate a cell by:
Pressing an arrow key
All of these
Pressing the Tab key
Clicking the cell
Which command will you choose to convert a column of data into row?
Edit >> Paste Special >> Transpose
Cut and Paste
None of these
Both Cut, Paste and Edit >> Paste Special >> Transpose
To copy a formula from one cell to another:
Drag the autofill handle
None of these
Cut the cell
Both drag the autofill hangle and cut the cell
In databases. Locking level is also called as:
X lock
Dead Lock
Granularity
S lock
Which of the following data types can not store decimal values?
Boolean
Real
Numeric
Decimal
Duplication of data is known as
None of these
data redundancy
data security
data incomplete
What are the different view to present a Table?
Pivot Table View
All of these
Datasheet View
Design View
Which of the following enables us to view data from a table based on a specific criterion.
Form
Report
Macro
Query
_____________ is an accessibility feature for persons with vision impairment or cognitive problems.
Filter Keys
Toggle Keys
Sticky Keys
Enter Keys
What are some of the measures to prevent electrical hazards and accidents?
All of these
Use only electrical equipment approved by a recognized organization.
Train workers to handle electric equipment safely.
Avoid overloading circuits.
What can we create in WordPress?
A blog
Both a website and a blog
A website
None of these
Aisha moved from Egypt to Germany for work but finds it difficult to adjust because she is not familiar with German customs and workplace etiquette, which affects her interactions with colleagues. This situation illustrates a:
Interpersonal barrier
Cultural barrier
Physical barrier
Linguistic barrier
Rohan has been working long hours every day without a break. Over time, he starts experiencing headaches, anxiety, and fatigue. This is likely caused by prolonged:
Stress
Discipline
Timeliness
Goal – Setting
When Ayaan switches on his computer, a particular software starts running automatically and manages all the hardware and other software. Which software is this?
Web Browsers
Designing Software
Office Software
Operating System
An entrepreneur must be ready to take a __________ and remain open to new ideas to grow their business.
Satisfying human need
Product and Service
Calculated Risk
Regular Production
The Sustainable Development Goals (SDGs) aim to tackle key challenges faced by businesses, governments, and society, such as:
Gender Equality
Energy & Climate Change
Biodiversity
All of the above
The SMART method helps in setting effective goals for career and personal growth. In this method, what does the ‘A’ stand for?
Abrupt
Accountable
Achievable
Admirable
Ria has a long document where she needs to apply the same paragraph style at multiple scattered locations. She wants to avoid the repetitive task of selecting each word/paragraph and applying the style separately. Which feature should she use, and how can she stop using it once she is done?
Use Fill Format option; stop it by clicking Fill Format button again or pressing Esc
Use AutoFormat; stop it by closing the document
Use Format Painter; stop it by pressing Ctrl+Shift+F
Use Style Inspector; stop it by clicking on Close
Arjun wants to slightly change the formatting of a predefined paragraph style in his Writer document. He does not want to create a new style, but rather update the existing one so that the changes apply wherever that style is used. Which option should he choose after formatting the text?
Create New Style
Update Selected Style
AutoFormat
Fill Format
Meena has prepared a project report with multiple headings and sub-headings. She wants to create a section at the beginning of the report that lists all topics in order and allows her to jump directly to any section by clicking on it. Which feature of Writer should she use?
Index of Keywords
Hyperlink Tool
Table of Contents
Bookmark
Assertion (A): In LibreOffice Calc, a Macro can be created as a function to perform repetitive calculations for which no predefined function exists. Reason (R): A function macro is written between Function and End Function statements, can accept arguments, perform operations, and return results. Which option is correct?
Both A and R are true, and R is the correct explanation of A
Both A and R are true, but R is NOT the correct explanation of A
A is true, but R is false
A is false, but R is true
A teacher wants to prepare a summary report in LibreOffice Calc by calculating the average marks of students from two different spreadsheet files: X-A.ods and X-B.ods. Which feature of Calc will help her achieve this?
Data Consolidate
External References to other documents
What-if Scenarios
Goal Seek
Which menu path in LibreOffice Calc is used to accept or reject changes made in a shared spreadsheet?
Tools > Review Changes > Manage
File > Options > Track Changes
Edit > Track Changes > Manage
View > Track Changes > Review
Rahul wants to generate a Table of Contents (ToC) in his LibreOffice Writer document. However, when he inserts the ToC, it appears empty. Which of the following is the MOST likely reason for this issue?
He did not protect the ToC against manual changes
He forgot to apply heading styles (Heading 1, Heading 2, etc.) to his document headings
He placed the cursor at the wrong location before inserting ToC
He did not rename the default title "Table of Contents" to "Contents"
During an audit, it is observed that employees are sitting for long hours with poor posture, and the computer screens cause glare. Which hazards are most relevant here?
Physical and Fire Hazards
Ergonomic and Health Hazards
Chemical and Safety Hazards
Biological and Health Hazards
In a database table, if more than one field is used together to uniquely identify a record, it is called:
Primary Key
Foreign Key
Composite Key
Candidate Key
If a database field is defined as VARCHAR(50) and the user enters 20 characters, how much storage is allocated?
50 bytes
20 bytes
64,000 bytes
255 bytes
A database designer wants to create a system where multiple tables are connected, allowing retrieval of related data from these tables efficiently. Which data model should the designer use?
Relational Data Model
Network Data Model
Hierarchical Data Model
All of these
The Query Design Window in LibreOffice Base is divided into how many parts?
One
Two
Three
Four
Which keyboard shortcut is used to open the Templates dialog box in LibreOffice Writer to manage or set default templates?
Ctrl + Shift + T
Ctrl + Alt + N
Ctrl + Shift + N
Ctrl + N
Rohit is analyzing sales data spread across four different sheets in LibreOffice Calc. He wants to combine the data into a single sheet to identify overall trends and relationships. He also wants any change in the source sheets to automatically update in the consolidated sheet. Which feature and option should he use?
Use Pivot Table with the "AutoFilter" option
Use Consolidate with the "Link to source data" option enabled
Use Data Validation with "Cell Range" enabled
Use Scenario Manager with "Copy Results To" option
Which of the following statements about forms in a database is incorrect?
A form provides a user-friendly interface for entering and modifying data.
Each field control in a form consists of a label and a field value text box.
Forms can include graphics, titles, and additional text for better presentation.
Forms are used to permanently store data like tables.
During office work, employees complain of stress due to long hours and conflicts with colleagues. Which approach is most effective in reducing this hazard?
Conflict resolution training and promoting hobbies
Only installing ergonomic chairs
Providing fire extinguishers
Routine electrical inspections
Ritika has created a spreadsheet to calculate the EMI for a car loan. The EMI depends on the loan amount, interest rate, and loan duration (years). She fixes the loan amount and interest rate, but wants the EMI to be exactly ₹12,000 per month. Which feature of Calc should she use, and why?
Goal Seek – because it adjusts the input (loan duration) to reach the exact target output (EMI = ₹12,000).
Scenario Manager – because it allows creating multiple possible outcomes with different sets of inputs.
Consolidate – because it combines data from different sheets into one summary.
Data Validation – because it restricts the type of values that can be entered into a cell.
Materials in a workplace are classified by risk to prevent fires. Which of the following correctly matches the material class with its description?
Class A – liquids, grease, and gas; Class B – wood, cloth, paper
Class C – electrical materials; Class D – volatile metals like magnesium and sodium
Class B – electrical equipment; Class C – paper and cloth
Class D – liquids and gas; Class A – electrical materials
Sneha is preparing 10 different project reports for her company. Each report requires the same header with the company logo, a footer with the legal notice, and predefined formatting for headings and text. Instead of manually inserting and formatting these elements in each report, which feature of LibreOffice Writer should she use?
Styles
Macros
Templates
Table of Contents
Which of the following components open along with the Report Wizard in LibreOffice Base?
Report Builder
Add Fields dialog box
Both a and b
Neither a nor b
Rohini works as a floor manager. She has been assigned the task of conducting regular __________ to ensure the safety of life in case of any disaster or emergency by evacuating the place of danger.
Cultural assembly
Open house events
Evacuation drill
Trips and excursions
Ramesh notices that a colleague has slipped and sustained a serious injury at work. Which sequence of actions demonstrates the correct approach to handling the accident according to safety protocols?
Attend to injured person → inform supervisor → assist supervisor
Report to supervisor → attend to injured person → assist supervisor
Assist supervisor → attend to injured person → inform supervisor
Ignore minor injury → continue work → report at the end of the day
Sonia works in a busy office where spills, broken glass, and clutter are common. To maintain a safe and productive workplace, which combination of actions should she prioritize?
Clean her own workstation, report faulty lights, leave spills for cleaning staff
Clean her workstation, clear spaces around machines, immediately clean spills, report faulty lighting
Focus only on her own desk, ignore common areas, and wait for maintenance to fix lighting
Only clean common areas and ignore her personal workspace
A company’s finance team is preparing the quarterly budget report. Two managers, Mr. Raj and Ms. Meera, work on the same spreadsheet file separately (Budget_Raj.ods and Budget_Meera.ods). Now, before submitting the final report to the CEO, the team needs to: 1. Check the differences in both versions. 2. Merge the approved changes into one final file. As the data entry operator, which steps will you follow in LibreOffice Calc?
Directly open Budget_Raj.ods and overwrite it with Budget_Meera.ods.
Open Budget_Raj.ods, use Compare Document to review differences, then use Merge Document to finalize.
Open Budget_Meera.ods and delete conflicting data manually.
Use only Merge Document, since it automatically compares files too.
Which feature in LibreOffice Writer allows users to create a consistent layout for documents by defining styles for text, paragraphs, and other elements?
Format Painter
Style
Page Layout
Template
What is the primary purpose of using a pivot table in LibreOffice Calc?
To create charts
To format cells
To summarize and analyze data
To protect data
Which of the following is a common method to ensure data integrity in a database?
Using forms for data entry
Allowing duplicate entries
Storing data in multiple locations
Ignoring validation rules
