KENDRIYA VIDYALAYA, SECTOR 24 NOIDA

TERM-1 PREBOARD
INFORMATION TECHNOLOGY (402)
CLASS X
SESSION 2021-22
TIME:60 MINS MM:25

General Instructions:
1. Please read the instructions carefully
2. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C.
3. Section A is of 05 marks and has 06 questions on Employability Skills.
4. Section B is of 15 marks and has 20 questions on Subject Specific Skills.
5. Section C is of 05 marks and has 07 competency-based questions.
6. Do as per the instructions given in the respective sections.
7. Marks allotted are mentioned against each section/question.
8. All questions must be attempted in the correct order

Section:A
Answer any 5 questions out of the given 6 questions on Employability Skills (1 x 5 = 5 marks)
1._______________ is a process of sharing information between two or more people.
a) Communication b) Communication Skills
c) Tone d) None of these
[Link] communication is a two way communication with a higher scope for______________.
a) argument b) clarification
c) time consuming d) None of these
3. _____________ is the quality that makes the writing understandable.
a) Unity b) Order
c) Coherence d) Completeness
4. __________feedback is specific information, in the form of written comments or verbal conversations
that help the learner understand what she or he needs to do in order to improve.
a) Descriptive b) Specific
c) General d) Sign
5. Sonika gets up at 6 am and goes for her hobby classes. Then she comes back home and finishes
her homework before going to school. She does all work by herself. No one tells her to do so.
This is called ___________.
a) Self-Awareness b) Self-Motivation
c) Self-Regulation d) Discipline

1
6. 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

SECTION B
Answer any 10 questions out of the given 12 questions (1 x 10= 10 marks)

1. Which extension is by default given to an Open Office Writer document?

a) .odt b) .com c) .docx d) None of these

2. Fatima has inserted a picture in a document. But she wants to cut off a part of the picture .Which
option she should use to accomplish the task?
a) Cut b) Copy c) Crop d) Paste

3. _____________ refers to the vertical or horizontal placement of a graphic in relation to the chosen
anchor point.
a) Alignment b) footer c) Margin d) Headings

4. Images can be added to a document:

a) From File b) Fropm OpenOffice gallery c) directly from Scanner d) All of the
above

5. ____________ Style is a combination style that can be applied to both paragraphs and individual
[Link] difference depends upon which text is selected when we apply the style.
a) Linked Style b) List c) Table d) Paragraph

6. On which tab does the Footer option exist?

a) Insert b) Header and Footer c) Home d) None of these

7. To insert an image from a file,click on the Insert tab and select the _________button in the illustrations
group.
a) Image b) Picture c) Shapes d) Screenshot

8. Document in mail merge which contains the common data is called _____________.
a) Data source b) Common document c) Main document d) none of these.

9. The _____________ option in the styles task pane creates any style with the formatting of your choice.
a) New Style b) Create new style c) Create Style d) None of these

10. Which of the following option is not available in the Graphics mode of picture toolbar?
a) Grayscale b) Black/White c) Watermark d) Original
11. A_________ is a model that you use to create other documents.
a) Template b) Document c) Design d) Copy-Paste

12. In a document, __________ refers to the vertical or horizontal placement of a graphic

in relation to the chosen anchor point.

2
 a) Arrangement b) Anchoring c) Alignment d) Text Wrapping

SECTION: C
Answer any 10 questions out of the given 12 questions (1 x 10= 10 marks)
1. What is the name of master worksheet where MS Excel summarises all the data?
a) Insert b) Consolidation c) Data d) Reference

2. Where can we use the Subtotals feature to subtotal data?

a) In a sorted list b) In an unsorted list c) In a filtered list d)None of these
3. Which function cannot be performed through Subtotal in a Spreadsheet?
a) Sum b) Product c) Average d) Percentage

4. Scenarios are a tool to test questions.

a) Auto b) Goal Seek c) What-if d) Drop Down

5. Hema is a chartered accountant. She used to maintain the accounts in a spreadsheet on everyday basis.
There are number of steps which she needs to follow every time. Can you suggest her a feature of
spreadsheet through which she can perform these tasks quickly without repeating the steps every time?
a) Record Changes b) Track Changes c) Goal Seek d) Using Macros

6. Sunita is making a project in spreadsheets. Her friend has told her how to rename a spreadsheet
as it will help her identify the worksheet data easily. She was very excited and told the same to
her brother. Her brother told her that in spreadsheets(OpenOffice0, a worksheet can be renamed using
__________ ways.
a.)2 b) 3 c) 4 d) 1
7. The cell reference in a spreadsheet for cell range B2 to F15 is _____________.
a) B2.F15 b) B2;F15 c) B2:F15 d) B2-F15

8. _________ means combining data in a spreadsheet from different worksheets into master worksheet
a) Hyperlinks b) Consolidating c) Linking d) Filter

9. Which of the following is more elaborate form of Goal Seek?

a) Scenario b) Solver c) Consolidate d) Subtotals

[Link] 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) Row b) Column c) Autosum d) Cell Reference

11. ________, totals/adds data arranged in an array—that is, a group of cells with labels for
columns and/or rows Which step one must should follow before using the Subtotal option?
a) Consolidate b) Rename c) Filter Data d) SubTotal

12. A ______ hyperlink contains the full address of the destination file or web page.

3
4