Mamasaheb Khandge English Medium School (CBSE)

Talegaon Dabhade
Mid Term Exam (A.Y. 2024-25)
Subject:- Information Technology Time: – 2 Hours
Class:- X Div:- Marks:- 50
******************************************************************************
General Instructions:
(i) Please read the instructions carefully.
(ii) This question paper consists of 21 questions in two Sections: Section A and Section B.
(iii) Section A has Objective Type questions, whereas Section B contains Subjective type questions.
(iv) All questions of a particular section must be attempted in the correct order.
(v) Section A : Objective Type Questions (24 marks) :
(vi) Section B : Subjective Type Questions (26 marks) :

SECTION A: OBJECTIVE TYPE QUESTIONS (24 Marks)

1. Answer any 4 out of the given 6 questions on Employability Skills (4 x 1 = 4 marks)
i._____________operating system enables multiple users to work on the same computer at different times or
simultaneously.
a. Multiprogramming b. Multiprocessors c. Multi-user d. Multi-tasking.

ii. Which of the following is not the benefit of stress management?

[Link] immunity b. Reduces efficiency c. Improves mood d. Prevents behavioral problems

iii. From the following statements, which one is not correct about the Qualities of an entrepreneur?
(a) Successful entrepreneurs adapt the habit of hard work from a very early stage.
(b) Entrepreneur should not think optimistically about the future of the business.
(c) Confident entrepreneur must not deviate from his/her decisions too early in case success is delayed.
(d) Entrepreneurs like to function at their own will and rules.

iv.___________are computer programs that can damage the data and software programs or steal the
information stored on a computer.
(a) Spam (b) Viruses (c) Junk mail (d) BIOS

v. Which of the following practices should be avoided for cleaning a computer?

(a) Use lint free swabs to clean parts of computer
(b) Spray a liquid before wiping the parts with cloth
(c) Turn off computer before cleaning
(d) Use natural bristle brush to clean internal part

vi. _________ refers to focusing human efforts for maintaining a healthy body and mind, capable of
withstanding stressful situations.
(a) Artificial Intelligence (b) Stress management (c) Motivation (d) Emotional intelligence
2. Answer any 5 out of the given 6 questions (5 x 1 = 5 marks)
i.____________is a horizontal bar present at bottom of the Windows 7 desktop.
(a) Status Bar (b) Menu Bar
(c) Task Bar (d) Recycle bin

ii. In Writer, you can create your own template in _________ way(s).
(a) One (b) Two (c) Three (d) Four

iii. State whether the following statement is a myth or reality: Entrepreneurs are born a certain way.
Answer: Entrepreneurs are born a certain way is a myth.

iv. When you open a new spreadsheet, by default, it has a sheet named which is managed using tabs at the
bottom of the spreadsheet.

a. Sheet1 b. Worksheet1 c. Untitled1 d. New Sheet

v. Which one of the following is not true for entrepreneurs?

(a) They create needs and demand. (b) They provide raw materials.
(c) They do not create jobs. (d) They help society by supporting infrastructure
development.
vi. Multiple copies of the same file leads to_________________.

a. Data Inconsistency b. Data Redundancy c. Data Consistency d. Foreign Key

3. Answer any 5 out of the given 6 questions (5 x 1 = 5 marks)
i. Which of the following is not an antivirus software?
(a) McAfee (b) Norton (c) MSOffice (d) Kaspersky

ii. ______________controls all aspects of a paragraph's appearance, such as text alignment, tab stops, line
spacing, and borders, and can include character formatting.
(a) Page Style (b) Character Style (c) Cell Style (d) Paragraph Style

iii. Which of the following is not a use of Firewall?

(a) Monitors all communications (b) Traps the unauthorized access
(c) Prevents passage of unwanted contents (d) Prevents viruses and malicious software

iv. Which of the following is not used when creating a mail-merge document?
(a) Spreadsheet (b) Document (c) Paint (d) Database

v. Reviewers and authors can add their _____________ to explain their changes in the cell of Spreadsheet.
a. Comments b. Worksheet c. Hyperlink d. Macros

vi. In Calc, Arguments passed to a macro from Calc are always .

a. Cell Reference b. Both a and b c. Value d. Sheet Reference
4. Answer any 5 out of the given 6 questions. (5 x 1 = 5 marks)
i. ___________feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows.
(a) Average (b) Subtotal (c) Goal seek (d) Solver

ii. In Writer, styles and formatting option is available under _________ menu.
(a) Insert (b) Tools (c) Format (d) Window

iii. ______________feature of Calc is used to test 'what-if questions.

(a) Solver (b) Goal seek (c) Scenario (d) Styles

iv. A healthy lifestyle helps to keep and improve people’s health and well-being. It does not include:
a. healthy eating habits b. physical activities c. stress management d. less sleep

v. Which of the following features allows one to apply a group of formats at the same time?
(a) Fill (b) Styles (c) Images (d) Drag and Drop

vi. A ______________refers to a cell or a range of cells on a worksheet and can be used to find the values or
data that you want formula to calculate.

a. Cell reference b. Sheet Reference c. Block d. Autofill

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

i. A __________ operating system is a computing environment that reacts to input within a specific period
of time.
a) Single User b) Multi-User c) Real Time d) Distribute

ii. Macros are especially useful for ______________ the same way over and over again.
(a) repeat a task (b) reject a task (c) report a task (d) comment a task

iii. Which function cannot be performed through Subtotal in a Spreadsheet?

a) Sum b) Product c) Average d) Percentage
iv. _____________function takes data from a series of worksheets or workbooks and summaries it into a
single worksheet that you can update easily.
a .Data Combination b. Data Consolidation c. Data Merging d. Data Concatenation

v. __________feature of Calc helps to track what data was changed, when the change was made, who made
the change and in which cell the change has occurred.
(a) Record Changes (b) Edit record (c) Change record (d) Macro

vi. ____________communication is the use of body language, gestures and facial expressions to convey
information to others.
a. Verbal b. Written c. Non-Verbal d. Visual
 SECTION B: SUBJECTIVE TYPE QUESTIONS (26 Marks)

Answer any 3 out of the given 5 questions on Employability Skills in 20 – 30 words. (3 x 2 = 6 marks)
6. What are the advantages of the ability to Work Independently?
Answer: Advantages of the Ability to Work Independently
Self-Motivation: Working independently fosters self-discipline and enhances motivation to achieve
personal goals.
Flexibility: It allows for flexible work hours and environments, enabling better work-life balance.
Decision-Making: Individuals can make decisions without needing consensus, speeding up the
workflow.
Skill Development: It encourages the development of problem-solving and critical thinking skills.
Increased Productivity: Some people may find they are more productive without distractions from
coworkers.

7. Name the Stress causal agents.

Answer:  Workload: Excessive demands and tight deadlines can lead to overwhelm.
 Job Insecurity: Concerns about job stability can cause anxiety.
 Poor Work Environment: Toxic workplaces, lack of support, or uncomfortable settings can increase
stress.
 Interpersonal Conflicts: Difficult relationships with colleagues or supervisors can lead to emotional
strain.
 Life Changes: Personal issues, such as family problems or financial concerns, can contribute to stress.

8. What do you mean by Disk Defragmentation?

Answer: Disk defragmentation is the process of reorganizing the data on a hard disk to ensure that
related data is stored closer together. This improves the efficiency of the disk, leading to faster file
access and improved system performance. Over time, files can become fragmented, meaning pieces of
the same file are scattered across the disk. Defragmentation consolidates these pieces to enhance
read/write speeds.

9. Explain any two Myths about Entrepreneurship.

Answer: The myths of entrepreneurship are as follows
(i) It is Easy to Start a Business: This depends on the scale of the enterprise. Starting up a large
entrepreneurial venture is a challenging process. Small scale enterprises are easier to set up.
Moreover, the rate of failure of new ventures is quite high all over the world. Just about one-third of
all enterprises become profitable only after operating for several years.
(ii) Lot of Money is needed to Startup a New Venture: Again, this depends on the type and scale
of the business venture. There are ventures that can be started with a small amount of money. Big
ventures need a lot of investment.
(iii) A Startup cannot Borrow from the Banks: Today our government is promoting startup
ventures and offering them loans on easy terms under various government schemes such as
MUDRA (Micro-units Development and Refinance Agency) and MSME (Micro, Small & Medium
Enterprises) scheme.
(iv) Businesses either Flourish or Fail: This is not always the case. Some ventures initially falter or
have lackluster growth rates. However, with right re-planning and effort they may go on to achieve a
healthy growth.
(v) A Good Idea is the only Requirement for a Successful Enterprise: Remember that even the
best of ideas need proper execution to become a reality. Ideas are important, but so are planning,
talent, leadership, communication and a host of other factors.

10. Write any four roles of Entrepreneurs.

Answer: Ans. The role and significance of entrepreneurs are discussed below
(i) Organiser of Society’s Productive Resources: An entrepreneur is the organises of society’s
productive resources. He is the person who assembles the unused natural, physical and human
resources of the society, combines them properly, establishes effective coordination between them
and makes the economic activities dynamic.
(ii) Helpful in Capital Formation: An entrepreneur is helpful in capital formation or we know that
increase in the rate of capital formation is quite essential for the economic development of any
country.
(iii) Increase in Employment Opportunities: An entrepreneur creates maximum employment
opportunities in the society by way of establishing new industries, developing and expanding the
existing industries and by undertaking innovative activities.

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

11. State any two purposes of using Templates in a word document.
Answer: The purpose of using templates is:
i. To save the time.
ii. It is a predesigned document you can use to create documents quickly
without having to think about formatting.

12. Mention any two operations that can be performed using Macros in a spreadsheet.
Answer: 1. Automating Repetitive Tasks
Macros can automate tasks that you frequently perform, such as formatting cells, applying formulas,
or generating reports. For example, if you regularly need to format a specific range of data with
borders, font styles, and colors, you can record a macro to execute all these formatting steps at once.
2. Data Manipulation
Macros can be used to manipulate data efficiently, such as sorting, filtering, or summarizing data. For
instance, you can create a macro that consolidates data from multiple sheets into a summary report,
applying necessary calculations and organizing the information in a specific format.
13. What do you mean by Hyperlinks in Spreadsheets? Give the two different types of
Hyperlinks that can be used in Spreadsheets.
Answer: Hyperlinks in spreadsheets are clickable links that connect to other locations within the same
document, to other documents, or to web pages. They are useful for navigating large datasets, linking
to external resources, or referencing additional information without cluttering the main interface.

Two Different Types of Hyperlinks in Spreadsheets

Internal Hyperlinks
These links direct users to a different cell or range within the same spreadsheet or to another sheet
within the same workbook.
External Hyperlinks
These links connect to external resources, such as websites, documents stored on a cloud service, or
other files on your computer.
14. Explain any Three Types of Feedback.
Answer: 1. Positive Feedback
It reinforces good behavior, encourages continued effort, and boosts confidence. For example,
praising a colleague for a successful presentation can motivate them to maintain high performance.
2. Constructive Feedback
It aims to help the recipient grow and develop their skills. For instance, telling a team member that
their report needs clearer data presentation, along with tips on how to improve it, provides them with
a path to enhance their work.
3. Negative Feedback
While it can alert someone to issues that need to be addressed, it often lacks the guidance needed for
positive change. For example, simply stating that a project is not meeting expectations without
explaining why can leave the recipient feeling discouraged and unsure of how to improve.
15. What are the Functions of Operating System. (Any four)
Answer: Functions of operating system are :
1 It checks whether the device is functioning properly or not.
2. It controls software resources of the computer.
3. It manages the computer memory

16. Explain any two factors affecting on oral Communication?

Answer: 1. Clarity and Articulation
Impact: If a speaker uses jargon, speaks too quickly, or mumbles, it can lead to misunderstandings.
Clear pronunciation and a well-structured message help ensure that the audience comprehends the
information being conveyed.
2. Non-Verbal Cues
Impact: These cues can reinforce or contradict verbal messages. For example, maintaining eye contact
can convey confidence and engagement, while crossed arms may suggest defensiveness or disinterest.
Effective use of non-verbal cues enhances the overall message and helps build rapport with the
audience.
Answer any 3 out of the given 5 questions in 50– 80 words each (3 x 4 = 12 marks)
17. Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following:
a. Scenarios b. Goal Seek c. Solver d. Subtotal
Answer: a. Scenarios: Scenarios in spreadsheets allow users to create and save different sets of values
for a particular group of cells. This feature is useful for comparing various outcomes based on
changing input values without manually altering each cell. For example, a financial analyst might use
scenarios to project different sales outcomes based on varying market conditions.

b. Goal Seek: Goal Seek is a built-in tool that helps users find the input value needed to achieve a
specific goal in a formula. By setting a target value for a particular cell, users can determine what
input value will result in that target. For instance, if you want to find out what sales figure is needed
to achieve a profit of $10,000, Goal Seek can calculate the required sales figure automatically.

c. Solver: Solver is an advanced tool that helps in optimizing a particular outcome by adjusting
multiple variables while adhering to specific constraints. It can handle complex problems where
several factors need to be considered. For example, if a business wants to maximize profits while
staying within budget and resource limits, Solver can provide the best solution.

d. Subtotal: The Subtotal feature allows users to calculate aggregate values (such as sum, average,
count, etc.) for grouped data in a spreadsheet. It automatically inserts subtotal rows in a list of data,
making it easier to analyze information. For example, in a sales report, users can calculate the total
sales per region without having to create separate formulas.

18. Kaustav found the given question on a homework. “Name the one word used for an entity used as a basis
for creating documents that contains pre-defined formatting styles, graphics, tables, objects and other
information”. Help Kaustav in answering the question.
a. Document b. Foundation c. Template d. Blank Document
Answer: Template A template is the one word used for an entity that serves as a basis for creating documents,
containing pre-defined formatting styles, graphics, tables, and other information.

19. Suppose that Nirav has a few constraints and must manage the values of variables based on these
constraints. How can such a situation be handled in Excel using good general tool. Explain the tool.
a. Goal Seek b. Solver tool c. Data Table [Link]

Answer: Solver tool The Solver tool in Excel is designed to handle situations where users must manage
values of variables based on certain constraints. It allows users to set an objective (like maximizing
profit or minimizing cost) and then adjust the variables while ensuring that the constraints (such as
resource limitations) are satisfied. Solver is particularly useful for complex optimization problems.
20. Millennium University is organizing a reunion meet for their alumnae students. For this purpose,
university wants to send the invite to all these students with their different addresses. Which feature of the
Word Processor University should use to accomplish the task? Explain the feature?
a. Mail Merge b. E-Mail c. Templates d. Data Source

Answer: Mail Merge Mail Merge is the feature a word processor should use to send personalized
invitations to alumnae students with different addresses. This feature allows users to create a single
document template that automatically pulls in data from a data source (like a list of names and
addresses), generating individual documents for each recipient. This streamlines the process of
sending out bulk invitations efficiently.

21. The Great school has invited its old student Zoe, who has become a famous scientist, to the school to
encourage students about sciences. However, while addressing the school students, Zoe used highly
scientific terms and jargons and thus students could not get what exactly she wanted to say. What type of
communication barrier is this? Explain it.
(a) Physical Barrier (b) Cultural Barrier (c) Linguistic Barrier (d) Interpersonal Barrier

Answer: Linguistic Barrier The communication barrier in Zoe's case is a Linguistic Barrier. This occurs when
the speaker uses specialized terminology or jargon that the audience does not understand, leading to confusion.
In this situation, Zoe’s use of highly scientific terms prevented the students from grasping her message,
highlighting the importance of using language appropriate for the audience's understanding.