New Bal Vaishali Public School

IT WORKSHEET - CLASS 9 (CH 1-4)

Class 09 - Information Technology (402)

1. Which of the following is a form of examination of hair sample, blood sample, etc. by the use of computer [1]
technology to identify people associated with a criminal case?

a) DNA Test b) Tracking

c) Immigration Records d) Digital Criminal Record

2. The full form of BPM is ________ [1]

a) Business Protocol Management b) Business Process Manager

c) Business Protocol Manager d) Business Process Management

3. ________ services mean performing business operations through an outside service provider. [1]

a) BPO b) MNC

c) ISP d) BPM
4. Companies having head quarters in one country and offices in multiple locations across the globe are ________. [1]

a) ISP b) GIC

c) CRM d) MNCs
5. Which of the following is not an IT application in Scientific Research and Engineering? [1]

a) CAE b) CRM

c) CAM d) CAD
6. Write the difference between IT and ITeS. [2]
7. What do you mean by BPO services? [2]
8. What is BPO? [2]
9. What is KPO? [2]
10. Mention about any two IT driven health diagnostic devices that you have seen at home. [2]
11. Name some areas where the application of IT and its tools have made a useful impact. [4]
12. Explain about the structure of IT-BPM industry in India. [4]
13. Which of the following is a part of student's statistics? [1]

a) Both Student Account and Statistics Panel b) Student Account

c) Statistics Panel d) Lesson Control

14. Which key is used to enable and disable the numeric keypad? [1]

a) Windows key b) Num Lock key

c) Shift key d) Ctrl key

1/4
15. Which of the following buttons shows the elapsed time and remaining time when a user is working with a [1]
lesson?

a) Time lesson button b) Remaining time button

c) Pause the lesson button d) Current lesson time button

16. ________ colour indication stands for right inputs exceeding the acceptable time frame in Rapid Typing Tutor. [1]

a) Red b) Orange

c) Green d) Yellow
17. Which of the following mouse pointer can be seen when you are about to type text? [1]

a) b)

c) d) Both and

18. How will you type the capital letters? [1]

19. What is the use of keyboard? [1]
20. When do these two symbols appear on screen? [2]

i.

ii.

21. List the parameters in which result is calculated in Rapid Typing. [2]
22. How can you remove a lesson in the RapidTyping software? [2]
23. Which keys represent the base position in the QWERTY keyboard? [2]
24. What are the base positions of your fingers on keyboard? [2]
25. Explain the Detailed statistics in brief. [4]
26. Give any 4 Keyboarding tips. [4]
27. Explain the allocation of keys to fingers on the upper row. [4]
28. Which of these can be created for multiple records using mail merge? [1]

a) Letters b) All of these

c) Labels d) Envelopes
29. Negative indent takes the text [1]

a) Inside the left margin b) Inside the text area

c) Inside the center margin d) Inside the right margin

30. Which toolbar is used to cut, copy, paste, undo, redo etc? [1]

a) Task toolbar b) Sidebar

c) Standard toolbar d) Formatting toolbar

31. Which of the following mail merge terms combines a document with a list of names and addresses to produce [1]
individualized documents?

a) Mail Merge b) Main document

c) Merge Field d) Data source

32. Which of the following is a way of selecting a word in a word processor using mouse? [1]

2/4
 a) Double Click b) Triple Click

c) Single Click d) Scrolling

33. What are the most common character formatting options? [1]
34. What do you understand by the term clipboard? [1]
35. Define Indentation. [1]
36. What is the use of general options of OpenOffice Writer? [1]
37. Neha is working as an assistant manager at Mycbseguide. She wants to send diwali greetings to every customer. [1]
Which technique can help her in printing address on the envelope of greeting card?
38. What is the actual use of mail merge feature available in word processors? [2]
39. Write a short note on Insertion Point. [2]
40. How are tables of Writer useful? [2]
41. Mohan has to send invitation to his relatives for attending the marriage of his elder brother. As the time is less, it [2]
is difficult to write the content of the letter again and again. Which feature of word processor can Mohan use to
do his task quickly?
42. How are tables useful? [2]
43. How will you protect the document from being opened and edited by others in Writer? [4]
44. What is Margin? Write about the different types of margins. [4]
45. Define the term Mail Merge. [4]
46. Do you think, use of bulleted lists or numbered lists is more appropriate in a Writer document? [4]
47. What is a mall merge facility? [4]
48. Which of the following is an extension of a worksheet created in Calc? [1]

a) .xls b) .obj

c) odd d) ods
49. Which of the following chart selects only one range of the data series? [1]

a) Line chart b) Bar chart

c) Pie chart d) Scatter Chart

50. For selecting a non-continuous range of cells, you need to do what? [1]

a) Press Ctrl key b) Press Alt key

c) Press Shift key d) Press Esc key

51. For selecting the entire worksheet in Calc, you need to press [1]

a) Alt + Shift + Spacebar b) Shift + Spacebar

c) Ctrl + Shift + Spacebar d) Ctrl + Spacebar

52. Under which tab of Format dialog, can you format dates? [1]

a) Font b) Background

c) Cell protection d) Number

53. Which of these would show 2 digit day in a date value? [1]

a) Day b) 2D

c) D d) DD

3/4
54. Which menu provides option for opening/viewing gallery? [1]

a) Insert b) Tools

c) Format d) Edit
55. What will be the column names of the below statement? [1]
i. 26th column
ii. 28th column
56. In a spreadsheet software, the formula =A1 + A2 was entered in cell A3 and then copied into cell B3. What is [1]
the formula copied into B3?
57. What do you mean by relative referencing? [1]
58. Give steps to insert a column in worksheet. [2]
59. Write about Walls and floors. [2]
60. If a1 contains 10 and cell b1 contains 50, the formula is given in c1 as a1+b1. [2]
i. The cell c1 does not show 60 as answer instead displays a1+b1. What could be the reason?
ii. Can we give the formula in any other way?
61. What is a cell and how is it referred? [2]
62. Kavita wants to present the information in the form of chart. She has a data of single series and the graph must [2]
show relative circular size of each value. Which chart type must she use?
63. Explain any four types of charts. [4]
64. What do you mean by cell referencing and what are different types of cell referencing? [4]
65. What are the advantages, disadvantages and purposes of using charts and graphs. [4]
66. What is a Spreadsheet Package? What are its features? [4]
67. Write short notes on: [4]
i. Alignment
ii. Formatting Cells
iii. Charts
iv. Axis Titles
68. Fill in the blanks: [3]
(a) ________ is also called web-enabled services. [1]
(b) Students can also contact a teacher or a trainer via Internet to use ________. [1]
(c) BPO stands for Business Process ________. [1]
69. State whether the given statement is True or False: [4]
(a) The letter to be typed is highlighted in a box. [1]
(b) Only course diagrams and statistics are available in the Statistics panel. [1]
(c) KPM stands for keystrokes per second. [1]
(d) In the home row, all the eight fingers of both the hands rest on home keys during the keyboard [1]
operation.

4/4