INDRAPRASTHA PUBLIC SCHOOL

KATHA (BAGHPAT)

PRE-BOARD-I EXAMINATION 2023-24 (SET-B)

Class 10 - Information Technology (402)
Time Allowed: 2 hours Maximum Marks: 50

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):

1. This section has 05 questions.

2. Marks allotted are mentioned against each question/part.

3. There is no negative marking.

4. Do as per the instructions given.

7. SECTION B - SUBJECTIVE TYPE QUESTIONS (26 MARKS):

1. This section has 16 questions.

2. A candidate has to do 10 questions.

3. Do as per the instructions given.

4. Marks allotted are mentioned against each question/part.

SECTION A: OBJECTIVE TYPE QUESTIONS

1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks) [4]
(i) Pawan kumar works hard to get the Best Anchor award at the annual day function. What type of [1]
motivation is this?

a) External b) Both internal and external

c) None of these d) Internal

(ii) Bar present at the bottom of the desktop is called: [1]

a) Taskbar b) None of these

c) Status bar d) Scroll bar

(iii) Which of the following is not a phase of entrepreneurship process? [1]

a) Support phase b) Sustenance phase

1/5
 c) Stimulatory phase d) Elimination phase
(iv) What is avoiding the use of complex words, sentences, and confusing language in communication [1]
called?

a) Fluency b) Accuracy

c) Punctuation d) Clarity
(v) Which organization has made the Sustainable Development Goals? [1]

a) United Nations b) UNICEF

c) League of Nations d) World Health Organisation

2. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(i) While saving a document as template, what option needs to be selected in the save as type list box? [1]

a) Template b) Save template

c) None of these d) Word template

(ii) We can create template in ________. [1]

a) All of these b) Impress

c) Spreadsheet d) Writer
(iii) Which of the following is a set of formats consisting of such things as fonts, colors, etc? [1]

a) Margin b) Indent

c) Leading d) Style
(iv) Which of the following option is not available in Graphics mode of picture toolbar? [1]

a) Original b) Watermark

c) Grayscale d) Black/White
(v) The default tab space is ________. [1]

a) 0.5 b) 1.25

c) 1.50 d) 1.15
(vi) Which of the following groups on the Insert tab contains the Clip Art option? [1]

a) Illustrations b) Header and Footer

c) Tables d) Text
3. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(i) Which of the following is not a basic step in creating a worksheet? [1]

a) Save workbook b) Enter text and data

c) Modify the worksheet d) Copy the worksheet

(ii) Acceptor Reject Changes dialog box (for shared worksheet) can be opened by clicking on [1]

a) None of these b) Edit > Changes > Accept or Reject

c) View > Changes > Accept or Reject d) File > Changes > Accept or Reject
(iii) On an excel sheet the active cell in indicated by: [1]

2/5
 a) A Dotted Border b) By Italic Text

c) A Dark Wide Border d) A Blinking Border

(iv) Which option is used to name a range of cells? [1]

a) Select Range b) Define Range

c) Range name d) Cell Range

(v) The auto calculate feature: [1]
i. can only add values in a range of cells
ii. provides a quick way to view the result of an arithmetic operation on a range of cells
iii. automatically creates formulas and adds them to a worksheet
iv. Both can only add values in a range of cells and automatically creates formulas and adds them to a
worksheet

a) iii b) ii

c) i d) iv
(vi) You can enter which types of data into worksheet cells? [1]

a) Formulas only b) Labels, values and formulas

c) Values and formulas but not Labels d) Labels and values but not formulas
4. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(i) Which of the following is suitable to act as a primary key in table student? [1]

a) Roll no b) Name

c) Class d) Section
(ii) Which command is used to create table? [1]

a) Create b) Select

c) Open d) New
(iii) What would be the output of the following query? [1]
SELECT * FROM CLIENT;

a) Returns data of the first field from the b) Returns single record from the CLIENT
CLIENT table table

c) Returns no data d) Returns data of all the fields from the

CLIENT table
(iv) By default the length of Varchar data type is [1]

a) 20 b) 40

c) 50 d) 30
(v) In Base data can be linked between two or more tables with the help of ________. [1]

a) foreign key b) primary and foreign key

c) primary key d) None of these

(vi) Which of the following act as an interface to view, enter and change data in database? [1]

3/5
 a) Query b) Form

c) Report d) Table
5. Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) [5]
(i) Examples of online funds transfer. [1]

a) NEFT b) Both RTGS and NEFT

c) NET d) RTGS
(ii) OLTP stands for ________. [1]

a) Online Transaction Procedure b) Offlane Transport Process

c) Offline Transaction Process d) Online Transaction Process

(iii) In URL, http://www.arihant.com/index.htm, which component identifies the website? [1]

a) /index.htm b) All of these

c) http d) www.arihant.com
(iv) ________ provides Internet access by transmitting digital data over wires of a local telephone [1]
network.

a) DSL b) Modem

c) P2P d) HSDPA
(v) Which combination is required to create a strong password? [1]

a) Combination of Alphanumeric b) All of these

c) Combination of special characters d) Combination of Numbers

(vi) Which technology is commonly used to provide free internet access to customers in places like hotels [1]
and malls?

a) WiMAX b) WiFi

c) Dial-up d) Cable Internet Access

SECTION B (Employability Skills)
Attempt any 3 questions
6. What do you understand by effective communication and barriers? [2]
7. Explain Common Responses to Stress. [2]
8. What are the type of an operating system? [2]
9. What is the main feature of a business to be successful in the market? [2]
10. What is the main purpose of Sustainable Development Goals (SDGs)? [2]
SECTION B (Subject Specific Skills) Short Answers
Attempt any 4 questions
11. How to insert column break in Word document? [2]
12. Neha Mittal wants to store data of her monthly expenditure for a period of two year and also wants to perform [2]
some calculations and analyses. Which Microsoft application, will you suggest Neha should use for this purpose
and why?
13. For what purpose pie charts are useful? [2]
14. State the relationship and difference between a primary and foreign key. [2]

4/5
15. Write any two key features of an Instant Messaging (IM). [2]
16. What is a blog? Explain its use. [2]
SECTION B (Subject Specific Skills) Long Answers
Attempt any 3 questions
17. Following are some descriptors describing some terms. Identify the terms/features these refer to. [4]
i. It is a pre-designed document that you can use to create new documents with the same formatting.
ii. It is a tool that you can use to produce professional looking documents.
iii. It is a new feature of 2007 Office suite that allows you to see changes in your document before you actually
select an item.
18. Describe, how the owner of the restaurant could use the spreadsheet for financial modeling? [4]
19. Insert some information into a table COLLEGE, whose structure is given below: [4]

Roll_no Name Class Branch

20. Describe the use of forms, list the various views used in MS Access in which the form can be displayed. [4]
21. Why is Internet called Network of Networks? [4]

5/5