C.B.S.E.

Sample Paper 1

CBSE SAMPLE QUESTION PAPER TERM-I —2021-22 (SOLVED)

INFORMATION TECHNOLOGY
(SUBJECT CODE 402)
CLASS X (SESSION 2021-2022)

Max. Time Allowed : 60 Minutes (1 Hrs.) Max. Marks : 25

PART A – EMPLOYABILITY SKILLS (05 MARKS) :

NO. OF QUESTIONS
UNIT NO. NAME OF THE UNIT
(1 MARK EACH)

1 Communication Skills-II 2

2 Self-Management Skills-II 2

3 Information and Communication Technology Skills-II 2

TOTAL QUESTIONS 6 Questions
NO. OF QUESTIONS TO BE ANSWERED Any 5 Questions

TOTAL MARKS 1 × 5 = 5 Marks

PART B – SUBJECT SPECIFIC SKILLS (20 MARKS) :

NO. OF QUESTIONS
UNIT NO. NAME OF THE UNIT
(1 MARK EACH)
1 Digital Documentation (Advanced) 11

2 Electronic Spreadsheet (Advanced) 13

3 Database Management System 3

TOTAL QUESTIONS 27 Questions

NO. OF QUESTIONS TO BE ANSWERED 20 Questions

TOTAL MARKS 1 × 20 = 20 MARKS

1
 2 VINESH Target Information Technology (Vocational) Code : 402 Class—X

CBSE SAMPLE QUESTION PAPER TERM-I — 2021-22 (SOLVED)

Max. Time Allowed : 60 Minutes (1 Hrs.) Max. Marks : 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 × 5 = 5 marks)
1. ................. 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. 1
(a) Descriptive (b) Specific
(c) General (d) Sign
Ans : (a) Descriptive
2. ..................... communication is the use of body language, gestures and facial expressions to convey
information to others. 1
(a) Verbal (b) Written
(c) Non-Verbal (d) Visual
Ans. (c) Non-Verbal
3. 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
.................... . 1
(a) Self-Awareness (b) Self-Motivation
(c) Self-Regulation (d) Discipline
Ans : (b) Self-Motivation
4. High expectations from self can leave one with chronic anxiety and stress, thus leading to ................
stress. 1
(a) Physical (b) Emotional
(c) Mental (d) Financial
Ans : (c) Mental
5. A ..................... operating system is a computing environment that reacts to input with in a specific
period of time. 1
(a) Single User (b) Multi-User
(c) RealTime (d) Distribute
Ans : (c) Real Time
6. Identify the measure to protect computer from threats and viruses : 1
(a) Sharing password with friends (b) Allow any one to use your device
(c) Use Antivirus (d) Leave computer without logging out
Ans : (c) Use Antivirus
C.B.S.E. Sample Paper 3

SECTION – B
Answer any 15 questions out of the given 20 questions (1 × 15 = 15 marks)

7. When you apply a ......................, you apply a group of formatting effects together in one single step.
1
(a) Effect (b) Style
(c) Template (d) Format
Ans : (b) Style
8. Which function can not be performed through Subtotal in a Spreadsheet ? 1
(a) Sum (b) Product
(c) Average (d) Percentage
Ans : (d) Percentage
9. In a document .................... refers to the vertical or horizontal placement of a graphic in relation to the
chosen anchor point. 1
(a) Arrangement (b) Anchoring
(c) Alignment (d) Text Wrapping
Ans : (c) Alignment
10. A .................... is a model that you use to create other documents. 1
(a) Template (b) Document
(c) Design (d) Copy Paste
Ans : (a) Template
11. ...................... styles in a text document affect selected text within a paragraph, such as the font and size
of text, or bold and italic formats. 1
(a) Cell (b) Paragraph
(c) Formatting (d) Character
Ans : (d) Character
12. To repeat the graphic across the entire background area, we need to select option in word processor. 1
(a) Tile (b) Position
(c) Stretch (d) Area
Ans : (a) Tile
13. Scenarios are a tool to test questions. 1
(a) Auto (b) Goal Seek
(c) What-if (d) Drop Down
(c) What-if
14. ........................ is particularly useful when creating a water mark or when wrapping the image in the
background in a document. 1
(a) Transparency (b) Fill
(c) Filters (d) Crop
Ans : (a) Transparency
15. It 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. 1
(a) Row (b) Column
(c) Autosum (d) Cell Reference
Ans : (d) Cell Reference
 4 VINESH Target Information Technology (Vocational) Code : 402 Class—X

16. ................... total/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 ? 1
(a) Consolidate (b) Rename Data
(c) Filter Data (d) Subtotal
Ans : (d) Subtotal
17. A ....................... hyperlink contains the full address of the destination file or web page. 1
(a) Relative (b) Absolute
(c) Mixed (d) Address
Ans : (b) Absolute
18. Which of the following is more elaborate form of Goal Seek ? 1
(a) Subtotal (b) Scenario
(c) Solver (d) Consolidate
Ans : (c) Solver
19. ........................ means combining data in a spreadsheet from different worksheets into master worksheet.
1
(a) Hyperlinks (b) Consolidating
(c) Linking (d) Filter
Ans : (b) Consolidating
20. An .................... link will stop working only if the target is moved while a .............................
link will stop working only if the start and target locations change relative to each other. 1
(a) absolute, fixed (b) Relative, Absolute
(c) absolute, relative (d) permanent, absolute
Ans : (c) absolute, relative
21. Database servers are referred to as ............................. . 1
(a) Front-ends (b) Back-ends
(c) Clients (d) Model
Ans : (b) Back-ends
22. A table is a set of data elements that is organised using a model of vertical .................... and horizontal
.......................... . 1
(a) Rows, Tables (b) Columns, Rows
(c) Rows, Columns (d) Forms, Reports
Ans : (b) Columns, Rows
23. ...................... include fonts, alignment, borders, background, number formats (for example, currency,
date, number), and cell protection in document. 1
(a) Cell Style (b) Numbering Style
(c) Paragraph Style (d) Character Style
Ans : (a) Cell Style
24. By default, sheets tab are present at the ........................ of the spread sheet. 1
(a) Top (b) Bottom
(c) Center (d) Right
Ans : (b) Bottom
25. 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
Ans : (c) B2 : F15
C.B.S.E. Sample Paper 5

26. .................... control show graphics are stacked upon each other or relative to the text. 1
(a) Arrangement (b) Alignment
(c) Anchoring (d) Wrapping
Ans : (a) Arrangement
SECTION – C
(COMPETENCY BASED QUESTIONS)
Answer any 5 questions out of the given 7 questions (1 × 5 = 5 marks)
27. Millennium University is organizing a reunion meet for their alumnae students. For this purpose, university
wants to send the invite to all these students with their different addresses. Which feature of the Word
Processor University should use to accomplish the task ? 1
(a) Mail Merge (b) E-Mail
(c) Templates (d) Data Source
Ans : (a) Mail Merge
28. Prisha is a book editor. She wants to change the indentation of all paragraphs, and change the font of all
titles in the book. Which feature she should use to make the task easy ? 1
(a) Styles (b) Templates
(c) Table of content (d) Consolidating
Ans : (a) Styles
29. Gaurav has inserted an image in a document. He wants to remove the unwanted area of the image. Which
option of the word processor he will use to complete the task ? 1
(a) Clip art (b) Cut
(c) Crop (d) Contrast
Ans : (c) Crop
30. 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 everytime ? 1
(a) Record Changes (b) Track Changes
(c) Goal Seek (d) Using Macros
Ans : (d) Using Macros
31. Raj has created a worksheet where he has added all the information of his employees. He wants every
employee to go through the worksheet and update their address and phone number, if required. He also
would like to know the changes done by his employees. Which feature of spreadsheet he should enable to
see the changes made by his employees ? 1
(a) Macro (b) Link Workbook
(c) Change Worksheet (d) Track Changes
Ans : (d) Track Changes
32. Akshat wants to store a huge amount information about his firm in a database. Which type of table
organization would be most suitable for this purpose ? 1
(a) Relational (b) Flat File
(c) Either Relational or Flat file (d) Hierarchical
Ans : (c) Either Relational or Flat File
33. 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 (OpenOffice), a worksheet can be renamed using ...................
ways. 1
(a) 2 (b) 3
(c) 4 (d) 1
Ans : (b) 3
 6 VINESH Target Information Technology (Vocational) Code : 402 Class—X

Target Sample Question Paper–1

Information Technology – X (For Term 1)
(Solved)
Max. Time Allowed : 60 Minutes (1Hrs.) Max. Marks : 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 × 5 = 5 marks)
1. Good ............... are important workplace skills that help you communicate or talk will all types of people,
including managers, coworkers and customers.
(i) Technical Skills (ii) Communication Skills
(iii) Time Management Skills (iv) Organizational Skills
2. Our dress code is an example of ............... communication.
(i) Verbal (ii) Non-verbal
(iii) Written (iv) Spoken
3. Stress management is about learning
(i) How to avoid the pressures of life
(ii) Developing skills to enhance body’s adjustment when subjected to pressures of life
(iii) Both (i) and (ii) are correct
(iv) None of the above
4. Which of these might cause stress ?
(i) Sleeping (ii) Enjoying Vacation
(iii) Driving during rush hour (iv) All of the above
5. Operating systems
(i) Enables the programmer to draw a flow chart (ii) Provides a layer, user friendly interface
(iii) Links a program with subroutine it references (iv) All of these
6. Which is the first program run on a computer when the computer boots up ?
(i) Open office (ii) Operating system
(iii) System operations (iv) None of the above
SECTION – B
Answer any 15 questions out of the given 20 questions (1 × 15 = 15 marks)
7. Which of the following is the default extension of the writer file ?
(i) .obt (ii) .doc
(iii) .odt (iv) .docx
6
Target Sample Question Papers 7

8. The best way to safeguard your document is to save it ............... .

(i) Only after you have proofread it (ii) Only when you name it
(iii) Every few minutes (iv) After it is completed
9. A ............... is a set of formats that you can apply to selected pages, text, frames.
(i) Style (ii) Template
(iii) Image (iv) Graphics
10. Style sheets in Writer are used for ............... .
(i) Changing font size (ii) Alignment
(iii) Page Setup (iv) Printing
11. Area where cut and copied images are stored is ............... .
(i) Clipboard (ii) RAM
(iii) ROM (iv) Image board
12. To open insert picture dialog box, click on ............... menu.
(i) Format (ii) Insert
(iii) View (iv) Tools
13. A template can have :
(i) Text (ii) Graphic
(iii) Particular Style (iv) All of the above
14. Shortcut key to manage template in Writer is ............... .
(i) Ctrl+V (ii) Ctrl+Shift+N
(iii) Ctrl+Shift+O (iv) None of the above
15. Calc is the ............... component of the OpenOffice/Libre Office.
(i) Text (ii) Presentation
(iii) Spreadsheet (iv) Database
16. Calc is a spreadsheet application that can be used to ............... .
(i) calculate (ii) analyze
(iii) manage your data (iv) All of the above
17. In spreadsheet, letters are used to represent ............... .
(i) Rows (ii) Columns
(iii) Cells (iv) Block
18. ............... allows you to gather data from different worksheets into a master worksheet.
(i) Data Consolidation (ii) Goal Seek
(iii) Solver (iv) Total data
19. Data can be consolidated from two sheets only.
(i) True (ii) False
(iii) Both of above (iv) None of above
20. Which of the following option allows to select the source of data for the consolidation ?
(i) Function (ii) Consolidation Ranges
(iii) Source Data range (iv) Copy results to
21. Which of the following option of consolidate dialog box allow to select destination cells ?
(i) Function (ii) Consolidation Ranges
(iii) Source Data range (iv) Copy results to
22. By default sheets tab are present at the ............... of the spreadsheet.
(i) Top (ii) Bottom
(iii) Both of the above (iv) None of the above
23. We can insert the new sheet in Calc by clicking on ............... menu.
(i) Format (ii) Edit
(iii) Insert (iv) Tool
 8 VINESH Target Information Technology (Vocational) Code : 402 Class—X

24. Which of the following elements are present in “Insert Sheet” dialog box ?
(i) After Current Sheet (ii) Before Current Sheet
(iii) No. of Sheets (iv) All of the above
25. A row in a table is also known as
(i) Record (ii) Field
(iii) Data type (iv) Data
26. Duplication of data is called ............... .
(i) Inconsistency (ii) Consistency
(iii) Redundancy (iv) Foreign Key
SECTION – C
(Competency Based Questions)
Answer any 5 questions out of the given 7 questions (1 × 5 = 5 marks)
27. A student wants to create a ‘Digital Story Collection’ on the famous storyline ‘Rabbit & the Tortoise’. He has
downloaded some images of Rabbit, Tortoise and forest. He wants to add watermarks, stylish text and images but
it is not interested in any animation. Which one of the office tool he should use
(i) Word Processing Software (ii) Presentation Software
(iii) Spreadsheet Software (iv) Database Management Software
28. Consider the following Character effects listed from A-F in a document segment created by applying different
font effects on the given expression:
A. Underlining B. Overlining
C. Italics D. Strikethrough
E. Outline F. Bold

Which of the following provide(s) the correct matching of font effects applied on the above sentence ?
(i) I-E, II-A, III-A, IV-F (ii) I-C, II-E, III-A, IV-D & B
(iii) I-F, II-B, III-E, IV-E (iv) I-D & F, II-A, III-A, IV-A
29. Ojas was writing a story about Akbar and Birbal in Hindi. He created three different documents with different
alignments. These documents are shown below :
•∑§’⁄U-’Ë⁄U’‹ •∑§’⁄U-’Ë⁄U’‹ •∑§’⁄U-’Ë⁄U’‹
∞∑§ ÁŒŸ ’ÊŒ‡ÊÊ„U •∑§’⁄U Ÿ ∞∑§ ÁŒŸ ’ÊŒ‡ÊÊ„U •∑§’⁄U ∞∑§ ÁŒŸ ’ÊŒ‡ÊÊ„U •∑§’⁄U
∑§ÊªïÊ ¬⁄U ¬Áã‚‹ ‚ ∞∑§ Ÿ ∑§Êª¡ ¬⁄U ¬Áã‚‹ ‚ Ÿ ∑§ÊªïÊ ¬⁄U ¬Áã‚‹ ‚
‹ê’Ë ‹∑§Ë⁄U πË¥øË •ı⁄U ∞∑§ ‹ê’Ë ‹∑§Ë⁄U πË¥øË ∞∑§ ‹ê’Ë ‹∑§Ë⁄U πË¥øË
’Ë⁄U’‹ ∑§Ù ’È‹Ê ∑§⁄U ∑§„UÊ- •ı⁄U ’Ë⁄U’‹ ∑§Ù ’È‹Ê ∑§⁄U •ı⁄U ’Ë⁄U’‹ ∑§Ù ’È‹Ê ∑§⁄U
’Ë⁄U’‹ Ÿ ÃÙ ÿ„U ‹∑§Ë⁄U ∑§„UÊ- ’Ë⁄U’‹ Ÿ ÃÙ ÿ„U ∑§„UÊ- ’Ë⁄U’‹ Ÿ ÃÙ ÿ„U
ÉÊ≈UÊ߸ ¡Ê∞ •ı⁄U Ÿ „UË Á◊≈UÊ߸ ‹∑§Ë⁄U ÉÊ≈UÊ߸ ¡Ê∞ •ı⁄U Ÿ „UË ‹∑§Ë⁄U ÉÊ≈UÊ߸ ¡Ê∞ •ı⁄U Ÿ
¡Ê∞ ‹Á∑§Ÿ ¿UÙ≈UË „UÙ ¡Ê∞? Á◊≈UÊ߸ ¡Ê∞ ‹Á∑§Ÿ ¿UÙ≈UË „Ë Á◊≈UÊ߸ ¡Ê∞ ‹Á∑§Ÿ
„UÙ ¡Ê∞? ¿UÙ≈UË „UÙ ¡Ê∞?U
Identify all the three alignments.
(i) Center, Left, Justify (ii) Left, Center, Justify
(iii) Justify, Left, Center (iv) All of above
Target Sample Question Papers 9

30. A worksheet of faculty members of a university contains these columns in this sequence: Designation, Last
Name, First Name, Department and Salary. What is the first step to subtotal departmental salaries ?
(i) Sort by Last Name (ii) Sort by Salary
(iii) Sort by Rank (iv) Sort by Department
31. ............... can be used in a spreadsheet software to jump to a different location from within a spreadsheet and
can lead to other parts of the current file, to different files or even to websites.
(i) Illustrations (ii) Hyperlinks
(iii) Links (iv) Filter
32. Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they
have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they
should use to access the same Spreadsheet to speed up their work.
(i) Consolidate Worksheet (ii) Shared Worksheet
(iii) Link Worksheet (iv) Lock Worksheet
33. Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property
for this purpose.
(i) Length (ii) Default
(iii) Entry Required (iv) Format

Target Sample Question Paper–2

Information Technology – X (For Term 1)
(Solved)
Max. Time Allowed : 60 Minutes (1Hrs.) Max. Marks : 25
General Instructions : Same as Target Sample Question Paper–1

SECTION – A

Answer any 5 questions out of the given 6 questions on Employability Skills (1 × 5 = 5 marks)
1. ............... is a type of verbal communication
(i) Oral communication (ii) Written communication
(iii) Body language (iv) Both (i) and (ii)
2. Which of these is not an element of non-verbal communication ?
(i) Personal appearance (ii) Posture
(iii) Eye contact (iv) Name of the speaker
3. Students may feel............... stress if they are unable to submit their assignment.
(i) Physical (ii) Financial
(iii) Mental (iv) None of the above
4. Importance of stress management is/are
(i) Improves mood (ii) Boosts immune system
(iii) Increases efficiency (iv) All of the above
5. Which operating system allows only one user to do a task on the computer and one thing at a time ?
(i) Windows (ii) Linux
(iii) DOS (iv) None of the above
6. The main workspace of a Windows computer is called the............... .
(i) Folder (ii) Taskbar
(iii) Shortcut (iv) Desktop
10 VINESH Target Information Technology (Vocational) Code : 402 Class—X

SECTION – B
Answer any 15 questions out of the given 20 questions (1 × 15 = 15 marks)
7. Styles and formatting option in Writer provide the facilities to apply
(i) Paragraph Styles (ii) Character Styles
(iii) Frame Styles (iv) All of the above
8. An example of a block-move operation is
(i) Cut and paste (ii) Deleting a character
(iii) Inserting a character (iv) Both (ii) and (iii)
9. The best way to safeguard your document is to save it............... .
(i) Only after you have proofread it (ii) Only when you name it
(iii) Every few minutes (iv) After it is completed
10. Which key takes away characters to the right of the insertion point?
(i) Delete (ii) Autocorrect
(iii) Back up (iv) Overtype
11. Portrait and Landscape are
(i) Page Orientation (ii) Paper Size
(iii) Page Layout (iv) All of the above
12. Which of the following is not valid field in Word Processing ?
(i) Page Number (ii) Author
(iii) Date (iv) Green
13. ............... feature of Writer help us to build an automated index from heading.
(i) Table of Contents (ii) Style
(iii) Template (iv) None of the above
14. Indexes and Tables option available in ............... menu.
(i) File (ii) Edit
(iii) View (iv) Insert
15. In spreadsheet, tool used to construct formulas is called ................ .
(i) Filter (ii) Formula Bar
(iii) Formatting Toolbar (iv) Cell
16. A worksheet is better than calculations by hand because :
(i) The worksheet finds the answers faster
(ii) The worksheet is more accurate
(iii) The worksheet recalculates the results whenever you change a number in the cell
(iv) All of the above
17. How many sheets are there in a workbook by default ?
(i) One (ii) Two
(iii) Three (iv) Four
18. The ............... feature provides the contents of one cell from more than one sheet that can be combined in one
place.
(i) Goal Seek (ii) Solver
(iii) Total data (iv) Data Consolidation
19. Consolidate option is available under ............... menu.
(i) View (ii) Tool
(iii) Insert (iv) Data
Target Sample Question Papers 11

20. We can consolidate data by ............... .

(i) Row Label (ii) Column Label
(iii) Both of the above (iv) None of the above
21. Which of the following functions are available in consolidate window ?
(i) Max (ii) Min
(iii) Count (iv) All of the above
22. We can rename a new sheet in Calc.
(i) After inserting a new sheet (ii) While inserting a new sheet
(iii) Both of the above (iv) None of the above
23. Formula to refer a cell A3 in sheet named S1 is
(i) =S1A3 (ii) =S1.A3
(iii) =’S1¢ .A3 (iv) None of the above
24. In a Spreadsheet, the following reference changes rows and columns automatically when it is copied to a new
cell :
(i) Relative Reference (ii) Absolute Reference
(iii) Mixed Reference (iv) All of the above
25. ___________ is dedicated computers that hold the actual databases and run only DBMS and related Software.
(i) Main Server (ii) Web Server
(iii) Database Server (iv) Non Database Server
26. Which of the following is not the advantage of database ?
(i) Sharing of Data (ii) Reduce Data Redundancy
(iii) Increased Data Inconsistency (iv) Data Security
SECTION – C
(Competency Based Questions)
Answer any 5 questions out of the given 7 questions (1 × 5 = 5 marks)
27. Aman is an executive in a bank. He was typing the daily transaction report and wanted to copy the selected text.
He suddenly realised that the mouse was not working. Suggest how he could select the text without using the
mouse
(i) It is impossible to perform the operation without the mouse
(ii) Use the F5 key
(iii) Use the arrow key while holding down a Ctrl key
(iv) Use the arrow keys while holding down a Shift key
28. We have inserted an image in a document. The size of the image is not as per our requirement. We want to resize
the image. How many resizing handles appear when we select any image?
(i) 12 (ii) 6
(iii) 4 (iv) 8
29. Suresh have inserted in image in a document. Now he has started entering the text in the document. The option
that refers to the relation of image to the surrounding text is?
(i) Anchoring (ii) Text Wrapping
(iii) Graphic Wrapping (iv) All of the above
30. If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new
location, a relative hyperlink will ............... .
(i) not work (ii) work
(iii) may work (iv) None of the above
12 VINESH Target Information Technology (Vocational) Code : 402 Class—X

31. Study the screenshot below. What is the appropriate action to take when a workbook displays this message?

(i) Close it immediately and delete the file.

(ii) Check where the file originates from, and if it is a trusted source or your own workbook, click Enable
Content.
(iii) Close the file then right-click and rename it before opening it again.
(iv) None of the options listed above are correct.
32. Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to
achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so.
(i) Macro (ii) Solver
(iii) GoalSeek (iv) SubTotal
33. Aadya wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
(i) Table (ii) Form
(iii) Relationships (iv) Sorting

Target Sample Question Paper–3

Information Technology – X (For Term 1)
(Solved)
Max. Time Allowed : 60 Minutes (1Hrs.) Max. Marks : 25
General Instructions : Same as Target Sample Question Paper–1
SECTION – A
Answer any 5 questions out of the given 6 questions on Employability Skills (1 × 5 = 5 marks)
1. Which of the following methods are used to receive information from the sender through a letter?
(i) Listening (ii) Speaking
(iii) Reading (iv) Writing
2. Which of the following is positive body language to use when speaking ?
(i) Fold your arms or cross your legs
(ii) Stand behind a lecture stand and keep your body hidden
(iii) Keep arms open and use open gestures
(iv) Don’t make eye contact
3. ............... refers to human efforts for maintaining healthy body and mind..
(i) Stress Management (ii) Self-Motivation
(iii) Self-Regulation (iv) None of the above
4. Stress management prevents ............... .
(i) Psychological disorders (ii) Behavioural problems
(iii) Both of the above (iv) None of the above
Target Sample Question Papers 13

5. A ............... is a location where a group of files can be stored.

(i) Folder (ii) Main file
(iii) Super file (iv) None of the above
6. Small pictures on the desktop are called ............... .
(i) Desktop (ii) Symbols
(iii) Icons (iv) Pictures
SECTION – B
Answer any 15 questions out of the given 20 questions (1 × 15 = 15 marks)
7. Changing the existing document is known as ............... .
(i) Entering (ii) Re-Typing
(iii) Selecting (iv) Editing
8. What application would best be used for keying in an essay ?
(i) Word Processing (ii) Google
(iii) Internet (iv) Spreadsheet Software
9. Which of the following styles is not offered by Writer ?
(i) Page Style (ii) Frame Style
(iii) Fill Format Style (iv) Video Style
10. Which of the style include header and footers, border, margins ?
(i) Character Style (ii) Page Style
(iii) Frame style (iv) Presentation Style
11. Which of the following is not a valid Text Wrapping option in Word Processors ?
(i) Page Wrap (ii) Wrap Through
(iii) No Wrap (iv) Wrap Around
12. Which of the following is correct to open Drawing Object Properties ?
(i) View Insert Drawing Object (ii) View Toolbars Drawing Object Properties
(iii) Insert Toolbars Drawing Object Properties (iv) Insert Toolbars Drawing Object
13. Table of Contents in Writer will automatically update when we add or remove any heading
(i) Yes (ii) No
(iii) Cannot say (iv) None of above
14. We cannot change the table of content directly in the document if :
(i) Protected against manual changes option is selected
(ii) number of level is 3
(iii) Title is entered in the Title field
(iv) None of the above
15. Where is the address of the active cell displayed ?
(i) Row heading (ii) Status bar
(iii) Formula bar (iv) Name Box
16. Spreadsheet cell that is highlighted with heavy border is ............... .
(i) Main Cell (ii) Active Cell
(iii) Cell (iv) Locked Cell
17. Spreadsheet, sometimes is called as
(i) Cells (ii) Worksheet
(iii) Menus (iv) Notebook pages
14 VINESH Target Information Technology (Vocational) Code : 402 Class—X

18. In which option we have to specify the target range (Where we want the result to be displayed)
(i) Source data range (ii) Copy results to
(iii) Need result at (iv) target range
19. If you select ............... then any values modified in the source range are automatically updated in the target
range.
(i) Link to source data (ii) Link to sheet data
(iii) Link to original data (iv) Link to source range
20. Which option is used to name a range of cells ?
(i) Range name (ii) Cell Range
(iii) Define Range (iv) Select Range
21. Define range option is available under ............... menu.
(i) Insert (ii) View
(iii) Developer (iv) Data
22. How is a relative reference different from an absolute reference ?
(i) It includes column and row references. (ii) It adjusts to its location on the worksheet.
(iii) It refers to an existing cell on the worksheet. (iv) It resets to its original value.
23. Hyperlink in Calc can be used
(i) To jump from one sheet to another sheet
(ii) To jump from one sheet to website
(iii) To jump from one section to another section of same sheet
(iv) All of the above
24. If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new
location, a relative hyperlink will ............... .
(i) not work (ii) work
(iii) may work (iv) None of the above
25. Which key is used to make relations between two tables ?
(i) Foreign (ii) Primary
(iii) Candidate (iv) Composite
26. What part of a database holds all of the information about one item or subject ?
(i) Record (ii) File
(iii) Query (iv) Chart
SECTION – C
(Competency Based Questions)
Answer any 5 questions out of the given 7 questions (1 × 5 = 5 marks)
27. Consider the following properties
I. Transparency II. Flip
III. Scale
Which of the above property/properties can be adjusted on an image in a Writer document?
(i) (III) (ii) (I) and (II)
(iii) (II) and (III) (iv) (I) and (III)
28. Ojas wants to create report for his business. He is using word processing software to create the report. Which
option he should use to create report with some pre designed reports.
(i) Style (ii) Format
(iii) Template (iv) Tools
Target Sample Question Papers 15

29. Aman wants that her company’s logo should automatically appear on the top of the Writer document whenever
she opens a new document. Which feature of Writer will help her to do so ?
(i) Style (ii) Automatic
(iii) Template (iv) All of the above
30. Marks scored by students in a class are entered in a spreadsheet along with their names as follows:
1234 556
738234 59

143 56
1283 5

 55

323 5
If we want to have a Merit List of these students [i.e. student’s marks appearing in descending order with
corresponding names], which one of the following options will accomplish this task in one go:
(i) Copy & Paste (ii) Reverse
(iii) Search (iv) Sort
31. Identify the correct sequence
(i) First open subtotals window and then select the data where we need to apply subtotals.
(ii) First Select data and then open subtotals window.
(iii) Both of the above are correct
(iv) None of the above
32. Which of the following statements about scenarios in an Open office/LibreOffice Calc workbook is not true ?
(i) A scenario is a set of values saved with the workbook.
(ii) A workbook can have one scenario per sheet.
(iii) Scenarios provide a way to see different solutions for worksheet formulas.
(iv) Scenarios help you in what-if analysis.
33. Which of the following statement(s) is/are true for UPDATE in SQL ?
I. You can update only a single table using UPDATE command
II. You can update multiple tables using UPDATE command
III. In UPDATE command, you must list what columns to update with their new values
IV. To update multiple targeted records, you need to specify UPDATE command using the WHERE clause.
Select the correct option:
(i) I, III and IV (ii) II, III and IV
(iii) III and IV (iv) I only

Target Sample Question Paper–4

Information Technology – X (For Term 1)
(Solved)
Max. Time Allowed : 60 Minutes (1Hrs.) Max. Marks : 25
General Instructions : Same as Target Sample Question Paper–1
SECTION – A
Answer any 5 questions out of the given 6 questions on Employability Skills (1 × 5 = 5 marks)
1. Non-verbal communication include
(i) Tone of voice (ii) Body language
(iii) Posture (iv) All of the above
16 VINESH Target Information Technology (Vocational) Code : 402 Class—X

2. Which of these is not an appropriate non-verbal communication at work ?

(i) Putting arm around a coworker’s shoulder
(ii) Shaking hands firmly
(iii) Looking at the speaker with a smile
(iv) Standing with an upright posture
3. Deep breathing, yoga and exercise would all be ............. stress management techniques.
(i) Religious (ii) Cognitive
(iii) Physical (iv) Social
4. What makes you complete work or studies without others cheering you ?
(i) Self-confidence (ii) Communication
(iii) Self-motivation (iv) Self-esteem
5. ............. is used to protect our computer from virus.
(i) Worm (ii) Anti-Spyware
(iii) Anti-virus (iv) None of the above
6. The operating system is the most common type of ............. Software
(i) Communication (ii) Application
(iii) System (iv) Word processing software
SECTION – B
Answer any 15 questions out of the given 20 questions (1 × 15 = 15 marks)
7. Saving an existing document with some other name using Save As option :
(i) Replaces the current document (ii) Leaves the current document intact.
(iii) Is not possible (iv) Closes the document.
8. When starting Writer, default document window name is ............. .
(i) .odt (ii) Word1
(iii) .doc (iv) Untitled1
9. Which style affects the selected text such as font size, bold and italics format ?
(i) Cell Styles (ii) Numbering Styles
(iii) Character Styles (iv) Frame Styles
10. What is the shortcut for opening styles and formatting window ?
(i) F12 (ii) F8
(iii) F11 (iv) F10
11. Rotate option available on ............. toolbar.
(i) Picture (ii) Art
(iii) Drawing (iv) None of the above
12. To select two drawing objects in Writer, Select one object and hold ............. key and select other object.
(i) Ctrl (ii) Alt
(iii) Spacebar (iv) Shift
13. In Word Processor, we can create a table of contents based on which of the following ?
(i) Heading Styles and Formats (ii) Figure Styles and Formats
(iii) Marked Index Entries (iv) All of the Above
14. Mail Merge involves merging of
(i) Two documents (ii) Two mails
(iii) Both of the above (iv) None of the above
Target Sample Question Papers 17

15. Which of the following data can be typed into a Spreadsheet cell ?
(i) Formulae (ii) Text
(iii) Numbers (iv) All of these
16. What is the maximum number of characters in one cell in calc spreadsheet ?
(i) 6000 (ii) 32767
(iii) 255 (iv) 1021
17. A formula in calc may begin with
(i) = (ii) +
(iii) – (iv) All the above
18. The ............. feature allows us to make a total of given data into a group with row labels and column headers.
(i) Data Consolidation (ii) Goal Seek
(iii) Solver (iv) SubTotal
19. Which function is not a Subtotal function ?
(i) MAX (ii) SUM
(iii) AGGREGATE (iv) AVERAGE
20. SUBTOTALS ............. data arranged in a group of cells.
(i) Add (ii) Average
(iii) Find (iv) Clear
21. In Subtotals we can select up to ............. groups of arrays.
(i) 3 (ii) 2
(iii) 4 (iv) Infinite
22. Hyperlink option is available in ............. menu.
(i) File (ii) Edit
(iii) Format (iv) Insert
23. When you group worksheets
(i) You can enter variable data on multiple worksheets at one time
(ii) You can print more than one worksheet at a time
(iii) You can enter common data, formats, and formulas on multiple worksheets at one time
(iv) Both (i) and (ii)
24. If a cell addresses changes after copying the formula then the address is known as
(i) Absolute Address (ii) Relative Address
(iii) Mixed Address (iv) Dynamic Address
25. A key which is referring to the primary key of another table is called ............. .
(i) Alternate Key (ii) Primary Key
(iii) First Primary Key (iv) Foreign Key
26. A ............. is an object you can use to customize the display of data in a table or query.
(i) Table (ii) Form
(iii) View (iv) Relation
SECTION – C
(Competency Based Questions)
Answer any 5 questions out of the given 7 questions (1 x 5 = 5 marks)
27. Amrita is celebrating her 14th birthday. She wants to invite her friends and family members to the party. Which
feature will she use to send the same invite to many people with different addresses without typing it again and
again ?
18 VINESH Target Information Technology (Vocational) Code : 402 Class—X

(i) Mail Merge (ii) Letter wizard

(iii) Document Type (iv) None of these
28. What is the name given to that part of a word processing package that is used to automatically insert names,
addresses, and other text into designated locations in a series of letters ?
(i) Mail merge (ii) Page layout
(iii) Block move (iv) Word wrap
29. Danish buys a new showroom and wants to invite his friends and relatives on inauguration ceremony. Which
feature of Writer will help him to create personalized invitation letter for every one ?
(i) Documentation (ii) Mail Merge
(iii) Style (iv) Template
30. Nilesh Aiyar is interested in storing his salary details and he also wants to perform some calculations and
analysis. Which Office application, will you suggest Nilesh should use for this purpose ?
(i) Word Processing Software (ii) Presentation Software
(iii) Spreadsheet Software (iv) Database Management System
31. Namya and her friends want to work together in a spreadsheet. They can do so by
(i) Sharing Workbook (ii) Linking Workbook
(iii) Both of the above (iv) None of the above
32. When you group worksheets
(i) You can enter variable data on multiple worksheets at one time
(ii) You can print more than one worksheet at a time
(iii) You can enter common data, formats, and formulas on multiple worksheets at one time
(iv) Both (i) and (ii)
33. A news agency keeps product data in this database table.
Product

1234567894 12345678
 1296
1223 456789
6  
122 684 13 2
122 68
  

After running a query, these data were extracted.

123456789

123456738
9
38597

Which query below will generate these results ?

(i) SELECT Product_Name FROM Product WHERE Price > 9;
(ii) SELECT Product_Name FROM Product WHERE Price < 9;
(iii) SELECT Product_Name, Price FROM Product WHERE Price < 9;
(iv) SELECT Product_Name, Price FROM Product WHERE Price > 9;
Target Sample Question Papers 19

Target Sample Question Paper–5

Information Technology – X (For Term 1)
(Solved)
Max. Time Allowed : 60 Minutes (1Hrs.) Max. Marks : 25
General Instructions : Same as Target Sample Question Paper–1
SECTION – A
Answer any 5 questions out of the given 6 questions on Employability Skills (1 × 5 = 5 marks)
1. In the communication process, the receiver and sender are classified as :
(i) Communication functions (ii) Communication parties
(iii) Communication tools (iv) Communication channels
2. Attitudes, actions and appearances in the context of classroom communication are considered as :
(i) Verbal (ii) Non-verbal
(iii) Impersonal (iv) Irrational
3. ............. is a practice where an individual is supposed to focus his/her minds.
(i) Yoga (ii) Physical Exercise
(iii) Meditation (iv) Nature Walk
4. Which of the following is not a self-management skill ?
(i) Problem solving (ii) Bargaining
(iii) Understanding self (iv) Confidence building
5. System Performance can be increased by
(i) Increasing RAM (ii) Disk defragmentation
(iii) Both of the above (iv) None of the above
6. A ............. is a temporary storage area where files or folders are stored before being copied to the new
location.
(i) Clipboard (ii) Folder bar
(iii) Disk (iv) Memory
SECTION – B
Answer any 15 questions out of the given 20 questions (1 × 15 = 15 marks)
7. Word Processing programs are used to create
(i) Reports (ii) Memos and Letters
(iii) Envelope and Labels (iv) All of the above
8. Word Processing includes the process of
(i) Entering Text (ii) Editing Text
(iii) Formatting Text (iv) All of the above
9. We can create style by :
(i) New Style from a selection (ii) Dragging and Dropping
(iii) Both of the above (iv) None of the above
10. When Fill Format mode is active, ............. click undo last Fill Format action.
(i) right and left (ii) left
(iii) right (iv) None of the above
20 VINESH Target Information Technology (Vocational) Code : 402 Class—X

11. Once we group two or more objects in Writer, we cannot ungroup them.
(i) True (ii) False
(iii) Cannot say (iv) None of the above
12. Which of the following setting is not used for positioning of graphic?
(i) Arrange (ii) Alignment
(iii) Wrap (iv) Caption
13. Which of the following mail merge terms lists the specific information to be inserted in a mail merge document ?
(i) Main document (ii) Data source
(iii) Mail merge (iv) Merge field
14. The four types of mail merge main documents are .............
(i) Form letters, directories, catalogues and envelope
(ii) Form letters, envelops and mailing labels, directories and lists
(iii) Basic letters, envelops, labels and list
(iv) Form letters, envelops, mailing labels and catalogue
15. What will be the result from the following formula (Assume A1=5, B2=2)? =A1^B2
(i) 7 (ii) 25
(iii) 10 (iv) 52
16. What does ##### mean?
(i) The column is not wide enough to display the content.
(ii) The cell reference is not valid.
(iii) You have misspelled a function name
(iv) None of above
17. What will happen if you type F5+F6 into a cell without a beginning equal sign ?
(i) The entry is the same as the formula =F5+F6.
(ii) The cell will display the information cell F5 plus F6.
(iii) The entry will be treated as a text entry and F5+F6 will show in the cell
(iv) None of the above
18. In Calc which is used to perform what if analysis ?
(i) Solver (ii) Goal seek
(iii) Scenario Manager (iv) All of the above
19. Which of the following is NOT one of Calc what if functions?
(i) Goal seek (ii) Solver
(iii) Scenario Manager (iv) Auto Outline
20. Scenario option is available in ___________________ menu.
(i) Data (ii) Tools
(iii) Insert (iv) Windows
21. Which option is suitable to calculate the effect of different interest rates on an investment ?
(i) Scenario (ii) Subtotal
(iii) Consolidate (iv) None of the above
22. How many types of cell references are there in Calc ?
(i) 1 (ii) 2
(iii) 3 (iv) 4
23. In Calc “Share Document” dialog box can open by clicking on ............. menu.
(i) File (ii) Edit
(iii) View (iv) Tools
Target Sample Question Papers 21

24. After sharing the worksheet, the word ............. is then shown on the title bar after the worksheet’s title
(i) Sharing (ii) Shared
(iii) Sharing Sheet (iv) None of the above
25. ............. are the basic building blocks of a database.
(i) Tables (ii) Record
(iii) Fields (iv) All of the above
26. We can create table in ............. .
(i) In design view (ii) Using Wizard
(iii) Both of the above (iv) None of the above

SECTION – C
(Competency Based Questions)
Answer any 5 questions out of the given 7 questions (1 × 5 = 5 marks)
27. Krishna wants to make a flowchart for his programs in a Word document. Which option should he use to
accomplish this task efficiently ?
(i) Drawing/Shapes (ii) Symbols
(iii) Pictures (iv) All ofthese
28. 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 ?
(i) Cut (ii) Copy
(iii) Crop (iv) Layout
29. Mail merging facility in Writer can be used to produce
I. A letter to be sent to various parents, or guardians of students of a University.
II. A set of faxes or email messages.
III. A set of numbered coupons in which each contains a unique number.
Which of the above is / are correct ?
(i) (I) (ii) (I) and (II)
(iii) (II) and (III) (iv) (I) and (III)
30. Computer Teacher of ‘Shanti Education School’ wants to graphically analyse the performance of her students
over the last three Computer Tests. Which one of the following office tools she should use to get graphical report
in most effective manner with minimum effort :
(i) Word Processing Software (ii) Presentation Software
(iii) Spreadsheet Software (iv) Database Management System
31. Sugam and Namya created a list of their class in one of the sheet of Calc in School. Now they want to complete
the task from home. Which option they should use to access the same Spreadsheet from home.
(i) Consolidate Worksheet (ii) Link Worksheet
(iii) Merge Worksheet (iv) Lock Worksheet
32. Ojas scored 130 in Term 1 and 140 in Term 2 (out of 150 ). How much will he score in Term 3 so that the
aggregate becomes 80% ? Which option will help him to find ?
(i) Solver (ii) Macro
(iii) Scenario (iv) Goal Seek
33. Which table view shows the correct data type for each field ?

1223 45678 9
8 9 58
4  
22 VINESH Target Information Technology (Vocational) Code : 402 Class—X

(i) 1234567893
886 3 (ii) 1234567893
886 3
6243 3 6243 88
83 793 83 
23 793 23
32984

(iii) 1234567893
886 3 (iv) 1234567893
886 3
6243 4293528 6243 4293528
83 3 83 793
23 3 23 3

1234563
Target Sample Question Paper–1
1. (ii) 2. (ii) 3. (ii) 4. (iii) 5. (ii) 6. (ii) 7. (iii) 8. (iii) 9. (i) 10. (i)
11. (i) 12. (ii) 13. (iv) 14. (ii) 15. (iii) 16. (iv) 17. (ii) 18. (i) 19. (ii) 20. (iii)
21. (iv) 22. (ii) 23. (iii) 24. (iv) 25. (i) 26. (iii) 27. (i) 28. (iv) 29. (ii) 30. (iv)
31. (ii) 32. (ii) 33. (iii)
Target Sample Question Paper–2
1. (iv) 2. (iv) 3. (iii) 4. (iv) 5. (iii) 6. (iv) 7. (iv) 8. (i) 9. (iii) 10. (i)
11. (i) 12. (iv) 13. (i) 14. (iv) 15. (ii) 16. (iv) 17. (iii) 18. (iv) 19. (iv) 20. (iii)
21. (iv) 22. (iii) 23. (iii) 24. (i) 25. (iii) 26. (iii) 27. (iv) 28. (iv) 29. (ii) 30. (ii)
31. (ii) 32. (iii) 33. (iii)
Target Sample Question Paper–3
1. (iii) 2. (iii) 3. (i) 4. (iii) 5. (i) 6. (iii) 7. (iv) 8. (i) 9. (iv) 10. (ii)
11. (iv) 12. (ii) 13. (ii) 14. (i) 15. (iv) 16. (ii) 17. (ii) 18. (iii) 19. (i) 20. (iii)
21. (iv) 22. (ii) 23. (iv) 24. (ii) 25. (i) 26. (i) 27. (iii) 28. (iii) 29. (iii) 30. (iv)
31. (ii) 32. (ii) 33. (i)
Target Sample Question Paper–4
1. (iv) 2. (i) 3. (iii) 4. (iii) 5. (iii) 6. (iii) 7. (ii) 8. (iv) 9. (iii) 10. (iii)
11. (iii) 12. (iv) 13. (iv) 14. (i) 15. (iv) 16. (ii) 17. (i) 18. (iv) 19. (iii) 20. (i)
21. (i) 22. (iv) 23. (iv) 24. (ii) 25. (iv) 26. (ii) 27. (i) 28. (i) 29. (ii) 30. (iii)
31. (i) 32. (iv) 33. (ii)
Target Sample Question Paper–5
1. (ii) 2. (ii) 3. (iii) 4. (ii) 5. (iii) 6. (i) 7. (iv) 8. (iv) 9. (iii) 10. (iii)
11. (ii) 12. (iv) 13. (ii) 14. (iv) 15. (ii) 16. (i) 17. (iii) 18. (iii) 19. (iv) 20. (ii)
21. (i) 22. (ii) 23. (iv) 24. (ii) 25. (i) 26. (iii) 27. (i) 28. (iii) 29. (i) 30. (iii)
31. (iii) 32. (iv) 33. (ii)