Nothing Special   »   [go: up one dir, main page]

G9 - Final Exam It

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 7

ANNUAL EXAM – 2023-24

SUBJECT- Information Technology (402)


Grade: 9
Marks: 50

Date: 22-2-2024 Time: 2 Hours

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)
i. Which among the following is not an element of a communication 1
skill?
a. Message b. Receiver c. Feedback d. Time
ii. Write 2 steps to build self- confidence. 1
iii. Which is the backbone of a computer? 1
a. Motherboard b. Kernel c. OS d. Memory Unit
iv. Green economy benefits 1
a. Society b. Environment c. Economy d. All of the above
v. Who created Facebook in 2004? 1
vi. UNEP stands for ____________. 1

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


i. Cursor is also known as ________ 1
a. Mouse b. Insertion point c. Symbol d. Block

ii. You want to make a table for the scores achieved by the 1
students. While typing “Name of the students”, you noticed
that the text couldn’t be accommodated within a cell. In this
case, for creating a proper table what should you do?

a. Wrap text b. Navigation c. Hide d. Merging all surrounding


cells
iii. ________ is the basic layout or working area where the content is 1
entered in a cell.
a. Slide pane b. Task pane c. Workspace d. Drawing tool bar
iv. ______ button changes the mis-spelt words in the whole document 1
automatically.

a. Auto correct b. Autoformat c. Auto reduce d. None of


these
v. _______ is located just below the Title bar. 1
a. Status bar b. Menu bar
c. Formatting Toolbar d. Standard Tool bar

vi. Which of the following is used to combine different objects together 1


to display as a single object?
a. Grouping b. Ungrouping c. Motion d. None of the
above
Q.3 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. Extension of file in Impress is ____ 1
a. .odf b. .odn c. .odp d. .opd

ii. _________ menu allows to start and control the Open office Help 1
system to get information about any topic related with Open
office package.
a. View b. File c. Menu d. Help
iii. The cell reference in a spreadsheet for cell range B2 to F15 is 1
________.
a. B2. F15 b.B2; F15 c.B2: F15 d. B2-F15
iv. Identify the part of a Spreadsheet using which a user can 1
manage multiple sheets.
a. Status Bar b. Sheet Tab c. Formula Bar d. Worksheet Area
v. The default setting of margins on top and bottom in a 1
document is:
a. 0.79” b. 0.83” c. 0.81” d. 0.80”
vi. Which of the following is not true about currently selected cell? 1
a. Currently selected cell is called Active cell.
b. Currently selected cell’s Address is visible in Name box.
c. Currently selected cell has thick border.
d. None of the above.

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


i. Quick Access Tool Bar icon is present on ________ in a 1
spreadsheet.
a. Menu Bar b. Standard Tool bar c. Title Bar d. Status Bar
ii. State whether True or False: -“It is not possible to create a 1
default template in a word processor.”
a. True b. False
iii. A large cell can be divided into individual cells known as ______ 1
of cells.
a. Merging b. Splitting c. Center d. Format
iv. If you combine F4, G4, F5 and G5 cells, you will get a big cell. 1
What address will be reflected for this big cell?
a. F4G5 b. FG45 c. F4 d. G5
v. Which of the following stores pre-downloaded and pre- 1
designed images?
a. Images b. Splitting c. Center d. Format
vi. Which tab is used to add Header in a document? 1
a. Insert b. Design c. File d. Layout
Q.5 Answer any 5 out of the given 6 questions (1 x 5 = 5 marks)
i. ______ refers to the layout of paper in which the document 1
gets printed.
a. Margin b. Page orientation c. Alignment d. Indentation
ii. When we are selecting multiple columns in a spreadsheet, it is 1
called as _______
a.Column range b. Row Range c. Cell Range d. None of the
above
iii. Which view displays the slide in a miniature format? 1
a. Slideshow b. Notes c. Outline d.
Handout
iv. Which out of the following is a way of selecting a paragraph in 1
word processor using mouse?
a. Single click b. Alt + Drag c. Click 4 times d. Double
click
v. You can easily comprehend, compare, analyze, or present data 1
in spreadsheets using _________
a. Formula b. Chart c. Filter d. None of the
above
vi. Which of the following options raises the selected text above 1
baseline?
a. Superscript b. Subscript c. Font style d. None of the
above

SECTION B: SUBJECTIVE TYPE QUESTIONS

Answer any 3 out of the given 5 questions (2 x3= 6 marks)


Answer each question in 20 – 30 words.
Q. 6 Name 4 ports that are useful in connecting your computer to 2
external devices and explain in short about them.
Q. 7 Mention any 4 factors affecting perspectives in 2
communication.
Q. 8 Mention the difference between interests and abilities. 2
Q. 9 Explain the factors causing imbalance in environment. 2
Q. 10 What are the features of mobile devices? 2

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


4 = 8 marks)
Q. 11 Define the terms Watermark and Template based on the 2
presentation software.
Q. 12 Write in short about any 4 types of charts present in spreadsheet. 2
Q. 13 What is Animation? What is the use of custom animation? 2
Q. 14 What is margin? Write about the different types of margins. 2
Q. 15 List the types of alignments. 2
Q. 16 Write short notes on a) Operands and b) Formulae bar. 2

Answer any 3 out of the given 5 questions in 50– 80 words each


(4 x 3 = 12 marks)
Q. 17 What is a mail merge facility in word processor? Write down the 4
main components and the required steps involved in a basic mail
merge process.
Q. 18 a) Write 2 different options of formatting a cell and its contents 4
along with the steps.
b) Write formulas for the operation given below based upon the
spreadsheet provided:

A B C D E F
1 NAME BASIC HRA DA Bonus NET
(Monthly) (% of (Rs) SALAR
(Rs.) Basic) Y
2 Suresh 5000 10 450 600
3 Karishma 5600 13 800 600
4 Atul 3500 15 900 400
5 Harmeet 4500 15 500 500
6 Abhay 6000 20 400 700
7 Jyotsana 7500 12 500 700
8 Amit 2500 10 300 700
9 Total
salary
10 No. of
Emp

i. To calculate the net salary as sum of Basic, HRA and DA for


each employee.
ii. To find the total salary of the employees and display in cell F9.

iii. To count the number of employees and display in cell B10.

iv. The manager wants to insert a new column next to HRA for
Travel Allowance. How will he do it?

v. To calculate Travel Allowance which will be 10 % of Basic.

Q. 19 Explain the different modes to view a presentation. 4


Q. 20 a) Explain the concept of word processing. 4
b) List the various software available for word processing.
c) In a document, all the occurrences of word “this” have to be
changed to “these”. Which option is suitable and what is the
shortcut command used for it?
d) What are non-printing characters?
Q. 21 (a) Write the steps to insert a new slide, delete and rename slide. 4
(b) Write the steps to insert a table in digital presentation.
(c) Arrange the jumble steps and rewrite to copy and paste content
in a slide:
 Place the insertion point on the desired area where content is
required to appear.
 Press ‘Ctrl+ V’ keys from keyboard.
 The copied text will appear at the insertion point.
 Select the content to be copied, then click the ‘Copy’
command on standard toolbar.

You might also like