SANSKAR VIDYA SAGAR

K.D.K College of Engg campus, Nandanvan, Nagpur

Information Technology(402)
TERM-I

Date: Class X – 2024-25 Time Allowed: 2 Hours

Maximum Marks: 50

General Instructions:

 Please read the instructions carefully.

 This (Question Paper consists of 21 questions in two sections:
Section A & Section B.
 Section A – Objective Type Questions (24 Marks):
o This section has 05 questions.
o Maries allotted are mentioned against each question/part:
o There is no negative marking.
o Do as per the instructions given.
 Section B – Subjective Type Questions (26 Marks):
o This section has 16 questions.
o A candidate has to do 10 questions.
o Do as per the instructions given.
o 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)
(A) Distress is the term given to
(a) Good stress (b) Bad stress
(c) Eustress (d) None of these

(B) Choose the option which is not a sustainable development goal

according to the United Nations.

(a) Clean Water and Sanitation (b) Gender Equality

(c) Population (d) Reduced Inequalities

C) Physical exercise is technique to ……………….. .

(a) Relieve stress (b) Manage time

(c) Boost self confidence (d) All of these

1
D) How many sustainable development goals are given by the United
Nations?
(a) 18 (b) 17 (c) 15 (d) 20

(E) 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 parts

(F) Which of the following is not a disadvantage of entrepreneurship?

(a) Risks involved with success of new venture ‘

(b) Working for long hours
(c) No regular income initially
(d) No higher authority

Question 2.
Answer any 5 out of the given 6 questions. (5*1=5)
(A) You can a ……………………… text selection into the Styles and Formatting
window to create a new style.
(a) Drag and drop (b) Cut and paste
(c) Copy and paste (d) Update

B) ……………………. means that the query uses criteria you provide to hide some
data and display only required data.
(a) Filtering (b) Report
(c) Sorting (d) Forms

(C) ……………………… adds data arranged in an array that is a group of cells with
labels for columns or rows.
(a) Consolidate (b) Group data
(c) Subtotal (d) Subtotal Query

D) (A) key is used to reduce repetitive strain,

(a) Sticky (b) Serial

(c) Mouse (d) Toggle

E) 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 Sheet1

2
F) State whether True or False:
“It is not possible to create a default template in a Word processor”
(a) True (b) False

Question 3.
Answer any 5 out of the given 6 questions.
A) John has written a book consisting of fifteen chapters. He wanted to make the
index of the book. Suggest him the option used to create the index automatically
in a word processor.
(a) Tables (b) Columns .
(c) Mail Merge (d) Table of Content

(B) Kritika is creating an annual sales report for her company. She uses the
articles and charts of all the branch offices to create the final report. Now she
wants all the reports to be identical Which of the following word processor
features would help her to create such identical documents?
(a) Mail merge (b) Graphics
(c) Template (d) None of these

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

D) 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. [1]
(a) Cell reference (b) Sheet Reference
(c) Block (d) Autofill

E) ………………… function takes data from a series of worksheets or workbooks

and summaries it into a single worksheet that you can update easily. [1]
(a) Data Combination (b) Data Consolidation
(c) Data Merging (d) Data Concatenation

F) State whether true or false:

“Entrepreneurs who do not have an innovative idea cannot succeed”. [1]
(a) True (b) False

Question 4.
Answer any 5 out of the given 6 questions. (5*1=5)
(A) You can add an image into a document from -
(a) Scanner (b) Gallery
(c) Clipboard (d) All of these

3
B) …………………….. is used to format a single character, or an entire word or a
phrase.

(a) Paragraph styles (b) Page styles

(c) Character styles (d) Frame styles

(C) A company has its offices in four major cities in India. The data of all regional
offices is stored on separate worksheets. The company wants to consolidate this
data. To use data from another worksheet, which of the following is most
appropriate?
(a) Copying data from all the sheets into a new one
(b) Creating Links to the data from another sheet
(c) Copy data into same sheet and then create link
(d) All of these

D) Scenario in Calc is used to solve …………………….. type of questions.

(a) Numeric (b) Calculation

(c) Text (d) What If

E) When multiple users can view, edit and review the changes in a spreadsheet, it
is called …………………….. .
(a) Linking (b) Sharing
(c) Reviewing (d) Merging

(F) Header option is available under ______________ group in Insert Tab.

a) Header & Footer b) Format
c) Insert d)View

Question 5.
Answer any 5 out of the given 6 questions. (5*1=5)
a Sahil and his partners have created a list of their company employees in one of the spreadsheets in
the office. Now the rest of the task they want to complete from home. Which option they should use
to access the same Spreadsheet from home?
a. Consolidate Worksheet b. Link Worksheet
c. Merge Worksheet d. Lock Worksheet

b) When it is difficult to communicate with someone who is not willing to talk or

express their feelings and views it means there is a/an ____________
a. Culture Barrier b. Interpersonal Barrier
c. Physical Barrier d. Language Barrier

c) __________ is not the quality of self-confident people.

4
a. Dependent c. Positive Attitude
b. Hard Working d. Commitment
d) Which out of the following is the best example of a strong password?
a. 9412356789 b. 14Hd{]$_Sb10 c. HarryPotterSeries d. 14Oct2004
e) “It is not possible to create a default template in a Word processor” True/False
f) Which one is not the tab of the insert/index Table window of Writer Document?
a. Entries b. Background c. Style d. Row
.
Answer any 3 out of the given 5 questions. (3*2=6)
A) List any two ways you can use to protect your data.

Ans. The various ways to protect our data from theft and viruses are:

(a) Use passwords to login to your computer: Use passwords that are difficult
to guess. Passwords are difficult to hack if they are a mix of small (For example ‘a
b c d’) and capital letters (For example, ‘H J E R’), numbers (For example ‘8 7 6 5’)
and special characters (For example, ’% ^ # $’). This would prevent unauthorised
people from using your computer.

(b) Install Anti-virus and Firewall: Anti-viruses and Firewall monitor the data
coming in and out of a computer and prevent viruses from entering. Anti-viruses
can also detect and clean viruses that may have entered a computer.

(c) Encrypt Data: This is usually done by banks and companies in which
important customer information is stored. They can encrypt their entire hard
disk using the encryption feature in Windows (Bitlocker). This would force users
to use a decryption password (or key) before starting the computer thus
preventing unauthorised usage.

(d) Secure sites: Give details of your credit card or bank account only on secure
sites. See in the address bar of the browser. If the site address starts with
https://and a lock symbol, then it is safe to give your credit card and bank details.

B) Write any 2 important functions of an entrepreneur?

Ans. The functions of an entrepreneur are:

Making Decisions: An entrepreneur makes decisions everyday. This includes

what to produce or sell, how much and where to sell.

Managing the Business: An entrepreneur plans the future of his or her business.
He/she arranges for raw material, hires people for work and tells everyone what
to do. They also check if the plan is being followed.

5
Divide Income: The entrepreneur divides the business money into many groups.
He/she spends money to buy material, pays rent of the building and salaries to
people.

Taking Risk: Risk is the chance of something going wrong. An entrepreneur

takes risks against fires, lost items and theft.

Create a new Method, Idea or Product: An entrepreneur is always trying new

things. He/she does this to increase their importance and income.

C) Write one sentences of each type of sentence

i) question ii) exclamatory
Ans. The two sentences of each type of sentence are:

Question

1) Do you want tea or coffee?

2) Is it raining?

Exclamatory

1) This is the best day of my life!

2) Oh, my goodness, we won!
D) What are two ways to increase performance of computer?

(a) Add extra ram

(b) check virus spyware

© Use diskcleanup

(d) uninstall unnecessary software

E) What is stress ?Write any 2 stress management techniques.

Ans: Stress is our emotional, mental, physical and social reaction to any
perceived demands or threats.

Following are two most common stress management techniques:

(i) Meditation: Meditation calms our mind and body by clearing all the thoughts.
It reduces our mental and physical stress.
(ii) Taking breaks and good sleep: taking break from usual routine lowers the
stress. Sleep relaxes and recharges brain and makes it ready to work again next

6
day.
Answer any 4 out of the given 6 questions in 20-30 words each. (4*2=8)

Question 11.What are advantages of sharing worksheet data?

Answer:
 Speed up data entry
 Make things easier for collaboration purposes

Question 12.
Define the following terms:
(A) Toggle keys 15.
(B) Sticky keys
Answer:
(A) Toggle Keys: Toggle key are the keys on the keyboard that is operated in the
same way but with opposite effect on successive occasions. E.g. Caps Lock is a
toggle key, pressed to switch between upper case and lower case alphabets.

(B) Sticky Keys: Sticky keys is an accessibility feature of Windows that assists
users having physical disabilities to reduce repetitive strain injury. It enables
user to enter key combinations by pressing keys is sequence rather than
simultaneously. It helps users who find difficulty in pressing shortcut key
combinations.

1. Question 13. What do you understand by the terms:

a. Text Wrapping

b. Anchoring
Ans. Text Wrapping: It refers to the relation of graphics to the
surrounding text, which may wrap around the graphic on one or both
sides, be overprinted behind or in front of the graphic or treat the
graphics as a separate paragraph or character.

Anchoring: It refers to the reference point for the graphics. This point
could be the page, or frame where the object is, a paragraph, or even a
character. An image always has an anchor point.

Question 14.

Anshita is preparing spreadsheet notes for her Term Exam. Help her to write
short note on the following: (ANY 2)

1. Scenarios
2. Goal Seek

7
 3. SubtotaL

Detailed Answer
1. Scenario: A scenario is a type of What- If anaLysis in which you can store
multiple values of data in the same ceLls. This helps in comparing the results of
varying input values.

2. Goal Seek: A goal seek is a type of What- If analysis tool that is used to find out
the correct input value to get a desired output. The target value is first
determined and the spreadsheet calculates backwards to find which input value
would yieLd the given output.

4. Subtotal Subtotal is a feature of spreadsheets to simplify the addition process

when working with huge amounts of data. It lets you do the addition of group
wise data which makes it easy to understand the calculation and makes it more
meaningful and presentable.

Question 15. Write the steps to insert header, footer. in your

document.

To insert header in the document, select Insert → Header and

Footer → Header.
To insert footer in the document, select Insert →Header and
Footer → Footer.

Question 16. What are styles? What are the advantages of using styles?
Ans. A style is a set of formats that can be applied to selected pages, text,
frames and other elements in a document to quickly change their
appearance. The advantages of using style are:

i) It helps to improve consistency in a document.

ii) It makes major formatting changes easy.

Answer any 3 out of the given 5 questions in 50 – 80 words each. (3*4=12)

Question 17. Write the steps to

Insert a Table in the document. Ans.

8
The steps to Insert a table in the

document are:

i) Position the cursor where the table must appear.

ii) Choose Table> Insert> Table option. The dialog box appears.

iii) Enter the number of rows and columns for the table in the number of
columns and the number of row boxes.

iv) Click on the Insert button.

1. Question 18.
Write down the ways of renaming a worksheet?
Ans: There are three ways you can rename a worksheet, and the only
difference between them is the way in which you start the renaming
process. You can do any of the following:

 Double-click on one of the existing worksheet names.

 Right-click on an existing worksheet name, then choose Rename from
the resulting Context menu.
 Select the worksheet you want to rename (click on the worksheet
tab) and then select the Sheet option from the Format menu. This
displays a submenu from which you should select the Rename option.

Question 19. . Explain features of accepting or rejecting changes.

Answer – The beauty of the recording changes mechanism becomes apparent

when you receive a worksheet with changes. You can now go through each
change like the original author and decide how to proceed. To get started, do the
following:

1. Open the worksheet that has been changed.

2. Select Edit > Changes > Accept or Reject from the drop-down menu. The
dialogue box displayed below will appear.

3. Calc goes through each modification one by one. As you go through the
process, you can accept or reject each adjustment. If you wish to, you can also
pick Accept all and reject all.

9
Question 20. What are Macros? How can we record a Macro?

Answer – When the same set of operations must be completed repeatedly, such
as formatting or applying a similar formula to a similar piece of data, macros can
save time. It can be used to name and track a sequence of events.

To record a macro, follow these steps:

1. Input data

2. Before performing any operation, go to tools->macro->record macro.

3. Now repeat the motion you just did.

4. Select “Stop Recording” from the drop-down menu. Now save the macro by
giving it a name

Question 21. A stranger has helped your grandfather and you want to appreciate
him for the help extended by him. Write any four lines to thank him.

10