BHARATHI VIDYALAYA SENIOR SECONDARY SCHOOL

HALF YEARLY EXAMINATION -2022-2023

INFORMATION TECHNOLOGY –(Code:402)
CLASS-IX
Time Allowed: 2hr Max. Marks : 50
No of Pages: 4 Date: .12.2022

General Instructions:
1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. Section A has Objective type questions whereas Section B contains Subjective type
questions.
4. 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.
5. All questions of a particular section must be attempted in the correct order.
6. SECTION A - OBJECTIVE TYPE QUESTIONS (24 MARKS):
i. This section has 05 questions.
ii. Marks allotted are mentioned against each question/part.
iii. There is no negative marking.
iv. Do as per the instructions given.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (26 MARKS):
i. This section has 16 questions.
ii. A candidate has to do 10 questions.
iii. Do as per the instructions given.
iv. Marks allotted are mentioned against each question/part

SECTION A: OBJECTIVE TYPE QUESTIONS

Q. 1 Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks)

1. “Be respectful, friendly and honest “. Which of the following is the principle of 7C’s
represented in the statement.
a. Completeness b. Courteous c. Concrete d. Consideration
2. Grooming is a term associated to _____________
a. Time management b. Problem solving
c. Neat and clean appearance d. Self management
3. ______________ is an application or software program which helps to access across
websites
a. Notepad b. HTML c. Office d. Browser
4. From the following statements, which one is not the positive impact of
Entrepreneurship on society:
a. Stimulates Innovation and Efficiency
b. Creates Jobs and Employment Opportunities
c. Solves the problems of the society
d. Discourages welfare of the society
5. In which of the following section ,we write the email ids of all the people whom we
want to send the copies of the message______________________
a. Subject b. Compose c. CC d. Main Body
6. It is created by the decomposition of buried dead animals and plants in lakes and oceans.
It’s found in oil wells above the oil. Vehicles are powered by compressed ________.
a. CNG b. Biomass c. Nuclear Energy d. LPG
Q.2 Answer any 5 questions out of the given 6 questions (1 x 5= 5 marks)

1. ___________ organization caters the need of the parent company only and do not serve
external clients
a. ISP b. MNC c. GIC d. BPO
2. Which of the following is a way of selecting a word in a word processor using mouse?
a. Single click b. Double click c. Right Click d. Triple Click
3. Mail merge wizard in writer is available in which of the following menus?
a. File Menu b. Insert Menu c. Tools Menu d. Edit Menu
4. Anita is working in an IT company. She has typed the names in Calc. His Boss told her
arrange the names in Alphabetical order (A to Z). What feature of Calc should she use?
a. Filtering b. Sorting c. Formatting d. Describing
5. Chart is available in _________menu.
a. File Menu b. Insert Menu c. View Menu d. Edit Menu
6. If you enter 34 +20 in a cell, Calc will display _________.
a.54 b. A34+A20 c. A20+ A 34 d.34 +20

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

1. BPM stands for _____________.

a. Business Process Manager b. Business Process Management
c. Business Protocol Management d. Broad Process Management
2. Mr. Rajan wants to write x . But when he writes this, it shows x2. Which option he
2

should use to get 2 at its proper place?

a. Superscript b. Strikethrough c. Subscript d. Change Case
3. ____________is called toggle key.
a. SHIFT b. ALT c. CAPSLOCK d. ESC
4. Which of the following is an extension of a worksheet created in Calc?
a. .ods b. .odd c. .xls [Link]
5. By default the labels are ____________ aligned.
a. left b. center c. right d. justify
6. ___________ is the short cut key to go to a page in a writer.
a. Ctrl+F b. ctrl+H c. ctrl+G d. ctrl+O
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)

1. The typing speed is measured in ________________..

a. WPM b. CPM c. KPM d. PERCENTAGE
2. Gautam has prepared a project for his school in a Word Processor. In his document, he
wants the change the all the occurrences of the word “when” to be changed to “where”.
Which option of the word processor he will use to complete the task?
a. Change Case b. Orientation c. Find and Replace d. Find
3. If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60;20) will
display______________.
a. 30 b.20 c.50 d.40
4. It is a business practice of hiring a third party to provide some required goods or
services, while focusing on core work inhouse.
a. IT b. Outprocessing c. Outsourcing d. Contracting
 5. Address of the cell formed by the intersection of the tenth column and nineteenth row
is ___________
a. K19 b.19K c.J19 d.19J
6. By default the name of the slide is ________
a. Slide 1 b. Slide_1 c.Slide1 [Link]-1
Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
1. E-learning and smart board presentation are showing integration of ICT in_________
a. Library b. Office c. Class room d. Bank
2. Rashi is an accountant. She wants to take out the printout of the balance sheet
widthwise. Which option she should use to print the document so that the height of
the page is less than its width?
a. Portrait b. Indent c. Landscape d. Tab Settings
3. The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will
change to _____________.
a. = B1 +C2 b. = B1 + C4 c. = D2 + E3. d. =E2+D3
4. _________ key is used in combination with the number keys to type the symbols like
@,#?
a. Shift key b. Caps Lock key c. Enter key d. Alt Key
5. _________ is the shortcut key for Spelling and grammar
a. F5 b. F7 c. F9 d. F11
6. The small black square in the bottom-right corner of the selected cell or range is
called a _______.
a. Fill content b. Fill range c. Fill handle d. Fill document

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)
Answer each question in 20 – 30 words.
6. What is verbal communication. List out one advantage and disadvantage of verbal
communication.
7. What are the keys of self-management skill. Explain any two
8. Explain any two ports used to connect the computer.
9. Write the difference between product business and service business.
10. Write any four components of Green economy.
Answer any 4 out of the given 6 questions in 20 – 30 words each (2 x 4 = 8 marks)
11. How IT -BPO industry help in the economic growth of India?
12. What is function keys and delete key.
13. Aman is writing telephone number along with STD code (starting from zero ‘0’). He
noticed that the first digit zero (‘0’), disappears from the telephone number. Write the
reason for this. What can be done to store telephone number starting from zero in a
cell?
14. How is mixed referencing different from relative referencing in a spreadsheet?
Explain with an example.
15. What is mail merge? What are the important components of mail merge
16. How Charts are beneficial feature of Calc? Name any types of Charts in Calc and
its purpose .
 Answer any 3 out of the given 4 questions in 50– 80 words each (4 x 3 = 12 marks)

17. Explain the different views to display a document.

18. Consider the following work sheet and answer the questions that follow:

A B C D E F
1 FURNITUR DESCRIPTION MRP DISCOUN AMOUNT AMOUNT
ECODE T +C7
2 F001 Chair 1200 500
3 F002 Sofa 85000 1200
4 F003 Chair 3000 800
5 F004 Table 3000 1000
6
7 EXTRA 300
OFFER
i) Write formula to Calculate amount after discount for F001 in cell
E2 considering the discount in cell D2.
ii) Insert function in cell E6 to calculate average AMOUNT.
iii) Display how many furniture items are there using a function in cell
A6.
iv) Write the formulae in cell F2 to add extra offer through out the
column.
19. Explain the role of typing Ergonomics.
21. Consider the following work sheet and answer the questions that follow:

i. Write formula in H2 to calculate total marks of Amit

ii. Write formula in D12 to calculate minimum marks in English.
iii. Write the cell range which has marks of Nikki (of all subjects).
iv. Write formula in H7 to calculate percentage of Meena.(Assume all marks are out
of 100)
v. Write formula in I2 to calculate the grade
If H2>450, value is “A”.
If 400<H2<450 value is”B”.
If 350<H3<400 value is “C”,
If 300<H3<350 value is “D”, otherwise “E”