PRUDENCE SCHOOL

FINAL EXAMINATION
SESSION: 2023-24
SUBJECT: INFORMATION TECHNOLOGY (CODE 402) (SET A)
Class: IX
Name of the Student: _____________________ Max. Marks: 50
Day & Date: Monday, 5th February 2024 Duration: 2 hrs.
General Instructions:
1. Please read the instructions carefully.
2. This Question Paper consists of 21 questions in two sections: Section A & Section B.
3. 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.
4. All questions of a particular section must be attempted in the correct order.
5. 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.
6. 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)
i. What type of sentence is given below? 1
Preheat the oven before baking a pie.
a. Interrogative b. Exclamatory c. Imperative d. Assertive
ii. _______________ is the processing device. It is also known as the brain of the computer. 1
a. ALU b. CPU c. MU d. I-P-O cycle
iii. The factors which play a vital role in building self-confidence are: 1
a. Social factors b. Cultural factors c. physical factors d. All of these
iv. A restaurant, which provide fine dining experience along with the food served to its 1
customers as product is an example of ___________ business.
a. Hybrid b. Manufacturing c. Service d. ownership
v. Name the limitations of being an Entrepreneur. 1
a. risk of failure b. be your own boss c. learning never stops d. be creative

vi. _____________ can be defined as an economy with the vision of growth and development 1
for mankind while reducing environmental risk or ecological balance.
a. conservation b. Green consumer c. Green economy d. low carbon
Q. 2 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Confidential information are transmitted through: 1
a. Decryption b. Encryption c. Transmission d. Telnet

Page 1 of 5
ii. The companies that are registered and have facilities, assets and operations in more than one 1
country at a time.
a. GIC b. ISP c. MNC d. Both A and B
iii. ________________ are the services related to giving information to clients by responding 1
through chat bots, chats, mail etc.
a. Accounting services b. Technical support c. Data-entry services d. Customer Support
iv. __________________ gives complete freedom to create and edit lesson. 1
a. Lesson Editor b. Statistics c. Table Analysis d. None of these

v. __________ key is used to cancel the previous task or to come out of an opened application. 1
a. Enter b. Function c. Ctrl d. Escape
vi. ______ is a standard hand-held pointing device that helps to select any object on the screen. 1
a. Keyboard b. Virtual Keypad c. Mouse d. Virtual Mouse

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

i. The space between the text and the left edge of the page is referred to as _________ margin. 1
a. Top b. Bottom c. Right d. Left
ii. ____________ refers to the layout of the paper in which the document gets printed i.e. 1
Landscape or Portrait.
a. Orientation b. Pivot c. Style d. Default
iii. ______ is the mark of separation between two pages where one page ends and the other 1
begins.
a. section break b. Page break c. Document break d. Separation break
iv. Division of cells into two or more sub-cells is known as _______________ of cells. 1
a. Right Margin b. Page Break c. Merging d. Splitting
v. __________ spacing is the vertical gap between lines of text in a paragraph. It is measured 1
in lines or in points.
a. Line b. Paragraph c. Page d. Column
vi. _____________ is the space of text from the edge/margin of the page. 1
a. Indentation b. Margin c. Spacing d. Formatting
Q. 4 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. ______________ is a visual graphic representation for a worksheet which is useful for 1
instant analysis of data and decision making.
a. Data b. Table c. Chart d. All the options

ii. _____________ is an additional feature in spreadsheet package in which a certain kind of 1

predefined series of data are automatically generated once the user feeds the initial data.
a. Autofill b. Custom List c. Series d. None of the option
iii. A rectangular area formed by the intersection of a row and a column is called a _________. 1
a. Sheet b. Cell c. Worksheet d. Workbook
iv. One of the most important feature of spreadsheet package is doing calculations. 1
___________ are used to perform mathematical operations such as addition, subtraction,
multiplication etc.
a. Operation b. Mod c. Functions d. Formulas
v. Which of the following is an extension of a worksheet created in Calc? 1
a. .ods b. .odt c. .odp d. .xlsx
vi. While working in a worksheet ____________ shortcut can be used to apply Undo command. 1
a. Ctrl+X b. Ctrl+Y c. Ctrl+Z d. Ctrl+V
Page 2 of 5
 Q. 5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Tansition effects are present under _____________ tab. 1
a. Slide b. Slide show c. Tools d. Insert
ii. Which of the following feature is used to create a new slide show with the current slides but 1
presented in different order?
a. Slide sorter b. Custom slide show c. Slide show setup d. Slide show view
iii. Ms. Shelly is a Mathematics teacher. She wants to create a geometric figure by adding 1
different shapes. Which tool bar in Impress can help her use different shapes to create
customized geometric figure.
a. Group b. Ungroup c. Drawing d. Insert
iv. Mr. Sam wants to insert an image in the presentation. Images in the presentation can be 1
inserted from_________ menu option.
a. Tools b. format c. Insert d. Slide Show
v. The feature that enables to set timings between the display of content in a special sequence 1
of typical effects leading to interesting and lively presentation.
a. Animation b. Transition c. Display time d. Graphics
vi. ____________ option under Insert tab help us to quickly copy and paste a slide with all its 1
contents.
a. Cut and paste b. Copy and paste c. Slide d. Duplicate

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks)
Q. 6 Give two advantages of visual communication? 2
Q. 7 Convert active voice to passive voice. 2
1. I ate the strawberry pie
2. We ought to respect our elders.
Q. 8 There are many keys of self-management that help in regulating day-to-day activities. Name 2
the below mentioned self-management techniques.

1. The art of handling pressurized situations by keeping oneself cool and calm with
patience.
2. Being fearless in the face of any difficult situation and finding solution to any kind
of problem.
Q. 9 Give the full form for: 2
1. ALU
2. MU
Q. 10 Answer the following: 2
1. Ramu is chai wala selling tea near a busy bus stop. He earns a lot and makes a good
profit. He is a ______________.

2. Rani started a tea stall on the road side. She decided to sell different flavours of tea,
just like expensive tea parlour in the mall, at a reasonable price. Her clients vary
from daily wage earners to actors and politicians because of her unique idea. She is
an_____________.

Page 3 of 5
 Answer any 4 out of the given 6 questions (2 x 4 = 8 marks)
Q. 11 Give two applications of IT in the field of : 2
1. News and Broadcasting
2. Law Enforcement
Q. 12 Answer the following: 2
1. Dolly needs to appear for a competitive exam wherein she needs to practice typing
using the keyboard. Which software will you recommend her at this level?
2. Give two home keys on a keyboard.
Q. 13 Answer the following: 2
1. Mr. Saurav is organizing Annual fest in school. He has to maintain number of lists
for all performances along with participants. Name any one feature from Open
Office writer that can help him organize the data.
2. Ms. Ankita is an office assistant. She need to send letters to the associates of the
company. While using Mail Merge, which document along with main document can
she use to create the merged document.
Q. 14 Name four type of data that can be entered in Spreadsheet package? 2
Q. 15 Name the feature: 2
1. Which option in open office impress help to combine different shapes which can be
used as a single unit to flip, rotate or resize objects as a single object.
2. A powerful way to convey structured information quickly and clearly using a grid.
Q. 16 Match the following: 2
1. Normal a. It enables to show the presentation in full screen
2. Notes b. It refers to the basic frame of the slide in which contents can be
added
3. Slide Show c. Slides are displayed in reduced form on the top. Towards the
bottom, there is a text box in which the notes for the slide can be
added.
4. Slide Layout d. By default, a blank slide appears on the workspace. It enables
user to make a presentation as per the need.

Answer any 3 out of the given 5 questions (4 x 3 = 12 marks)

Q. 17 Mrs. Bala created an assignment for her students. Before closing with the assignment, help 4
her do certain tasks as mentioned below.
1. Name the feature that can be used to check the document for grammatical mistakes.
2. She wants to replace word rational with pragmatic in the entire document. Name the
feature which can be used for the same.
3. Name the shortcut to select the entire document to change the font face and size for
the document.
4. Which feature can help her raise the text above the baseline.
Q. 18 Name the terms used in a chart. 4
(Axis title, Data series, Gridlines, Chart Area, Plot area, Chart title, Legend, Data label)
1. It refers to the label that provides additional information about the data, thus
represents a single data item or value of a cell.
2. It refers to the titles given to the three axis.
3. It is the set of values which the user wants to plot in the chart.
4. It refers to the total area surrounded in the chart.
Page 4 of 5
Q. 19 4

The teachers have recorded student’s data for class tests. Give function:
1. To count the number of students in appearing for Test1 in cell B8.
2. To find the average of marks for Kavya in cell G3.
3. To show todays date in the spreadsheet document.
4. To check the largest value entered for test2 in C8.
Q. 20 I am the view in a presentation, Guess Who am I? 4
1. I am the miniature or summarized view of the slides in a presentation. Here, only
title, sub-title and the main text excluding pictures and tables are displayed.
2. I allow user to make presentation as per the need. I allow you to get blank slide in
the workspace.
3. I allow user to view more than one slides on the screen. The user can rearrange the
order of slides which are numbered according to the sequence of the presentation.
4. I help view the complete presentation and help display each slide in full screen one
by one.
Q. 21 Fill in the blanks: 4
1. A new presentation can be made with the help of predesigned
__________________ in Impress. This option helps to make presentation by
using existing designs.
2. _____________ preserves formatting of the slide and enables file sharing
without any changes in formatting styles of presentation.
3. All the impress files have an extension as _________.
4. The ____________ contains thumbnails of the slides of a presentation in the
sequence of display. If any one of the slide is clicked, it gets opened in the
workspace.

Page 5 of 5