PAPER-II
Part-II: BASIC COMPUTER SKILL
SECTION-A: 80 Marks
Instructions: Each question under this section carries two marks. Please read each question carefully and answer them by selecting the right one out of the multiple answers given below each as A, B, C, and D.
61. “Save As” dialog can be used-
A) for saving the file for the first time
B) to save file by some alternative name
C) to save file in format other than Word
D) Any of the above
62. Match the keyboard shortcuts with command and find the correct combination.
a) Ctrl + C i) Save
b) Ctrl+B ii) Cut
c) Ctrl + X iii) Bold
d) Ctrl+S iv) Copy
A) a-ii, b-iii, c-iv, d-i
B) a-iv, b-iii, c-i, d-ii
C) a-ii, b-iii, c-i, d-iv
D) a-iv,b-iii,c-ii,d-i
63. WYSIWYG stands for –
A) What you see is what you get
B) What you smell is what you get
C) Where you suspect is where you go
D) None of these
64. Match “Column A” with ‘Column B”.
Column A Column B
a) Software 1. A set of computer programmers that enables hardware to
perform different tasks.
b) Processing 2. Transforming data into information
c) Operating system 3. The presentation of a fact or idea
(unprocessed information)
d) Data 4. Any part of the computer that you can physically touch.
e) Hardware 5. The most common type of system software that controls the
way in which the computer system functions
A) a-1,b-2,c-5,d-3,e-4
B) a-4, b-2, c-3, d-2, е-1
C) a-3,b-5,C-1,d-2,e-4
D) a-2, b -4, c-5, d-1, e-3
65. You can create a new presentation by all of the following except –
A) Clicking the New Slide button and then selecting the required slide on the standard toolbar
B) Clicking New from the File menu
C) Clicking Open from the File menu
D) Pressing ctrl+N
66. An output device translates –
A)The processed information from computer into a form that human can understand.
B) the data and programs that human can provide into a form that the computer can process.
C) It never translates.
D) None of these
67. Drop Cap is used in a document of MS Word?
A) To drop all the capital letters
B) To automatically begin each paragraph with capital letter
C) To begin a paragraph with a large dropped initial capital letter
D) None of above
68. Which of the following describes how to select all the cells in a single column?
A) Right click on column and select Pick from list
B) Use data– text to columns menu item
C) Left click on the gray column title button
D) Pressing Ctrl + A on the keyboard
69. Selecting the Columns G and H and choosing Insert->Column will lead to
A) 2 Columns will be inserted after Column-F
B) 2 Columns will be inserted after Column-G
C) 2 Columns will be inserted after Column-H
D) 2 Columns will be inserted after Column -1
70. Match the keyboard shortcut with the command
(a) Ctrl + A (i) Print
(b) Ctrl + P (ii) Paste
(c) Ctrl + V (iii) Select All
(d) Ctrl + Z (iv) Undo
A) a-i, b – ii, c-iii, d-iv
B) a-iii .b – 1. c-ii, d-iv
c) a-iv, b-iii, c-I, d- ii
D) a -i, b- iii, c-iv. d-ii
71. You can use the horizontal and vertical scroll bars to
A) split a worksheet into two panes
B) view different rows and columns to edit the contents of a cell.
C) edit the contents of a Cell.
D) view different Worksheets.
72. which of the following statements about the difference between a virus and a worm is false?
A) A virus corrupts and changes the location of files: but a worm usually does not.
B) A virus enters into and infects a file or executable program as they run; but a worm does not usually infect files or programs, rather replicates itself and consumes space in the computer
C) A virus spreads only when the user transmits the infected files to other users; but a worm spreads to other systems without even user intervention.
D) A virus spreads in the computer systems faster than a worm.
73. A worksheet is made of columns and rows, wherein
A) columns run horizontally and rows run vertically
B) columns run vertically and rows run horizontally
C) the run is dependent on the application being used
D) Both B and C
74. Read the following statements and answer which of these is/are correct using the codes given below.
i) The ‘Save As’ dialog box is used to open a saved Excel file.
ii) The ‘Save As’ dialog box is used for saving the file for the first time.
iii) The ‘Save As’ dialog box is used for saving the file by some alternative name.
A) only i correct
B) i& ii are correct
C) ii & iii are correct
D) None of these
75. “Ctrl + Right Arrow” is used to
A) move the cursor one word to the right
B) move the cursor to the end of the line.
C) move the cursor to the end of the document.
D) move the cursor one Paragraph down.
76. Which of the following syntax is correct regarding use of SUM function in Excel?
A) =SUM(A1, B1)
B) =SUM(A1:B9)
C)=SUM(A1:A9, B1:B9)
D) All of these
77. Which of the following functions is not performed by the ‘Operating System?
A) Co-ordinates and controls memory, processor, storage and peripheral devices.
B) Works as interface between the user and the computer system.
C) Loads and runs the application programs.
D) The Operating System complies “C” programs.
78. Which type of charts can ‘EXCEL’ produce?
A) Line graph and pie charts only
B) Only line graphs
C) Bar charts, line graphs, and pie charts
D) Bar charts and Line graphs only
79. To edit a chart, we can-
A) double click the chart object.
B) click and drag the chart object.
C) triple-click the chart object.
D) click the chart object.
80. Which option will be used to join some cells and place the content at the middle of the joined
cell in MS Office Word 2007 and onwards?
A) From Format Cells dialog box click on the Merge Cells checkbox.
B) From Format Cells dialog box select the Center Alignment.
C) From Format Cells dialog box choose Merge and Center checkbox.
D) None of these
81. in Data Base Management System (DBMS), each table is made up of columns and rows
called and respectively.
A) Fields and Records
B) Records and Fields
C) Query and Forms
D) None of these
82. What do you mean by trigger in the context of animations?
A) An action button that advances to the next slide
B) An item on the slide that performs an action when clicked
C) The name of a motion path
D) All of above
83. What is gutter margin?
A) Margin that is added to the left margin when printing
B) Margin that is added to right margin when printing
C) Margin that is added to the binding side of page when printing
D) Margin that is added to the outside of the page when printing
84. Match the keyboard shortcuts with the command and find the correct combination
a) End i) End of document
b) Alt + End ii) End of line
c) Ctrl + End iii) End of window
d) Alt + Ctrl + Page Down iv) End of the row in the table
A)a-i, b-iii, c-ii, d-iv
B) a-ii, b-iv, c-iii, d-i
C) a-ii, b-iv, c-i, d-iii
D) a-iv, b-iii, c-ii, d-i
85. How do you change column width to fit the contents?
A) Single-click the boundary to the left to the column heading
B)Double click the boundary to the right of the column heading
C) Press Alt and single click anywhere in the column
D) All of above
86. What do you mean by “what-if” analysis?
A) The process of observing the effect of changing one or more cells.
B) The process of adding more cells.
C) Excel does not have such function
D) The process of comparing two cells.
87. What is the term used when you press and hold the left mouse key and move the mouse around the slide?
A) Moving
B) Monitoring
C) Dragging
D) Highlighting
88. One kilobyte _____ bits.
A) 1250
B) 2088
(C) 8192
D) 1000
89. How can you select the text without using the Mouse?
A) It is not possible
B) Use the F7 key
C) Use the arrow keys while holding down a Ctrl key
D) Use the arrow keys while holding down a Shift key
90. What happens when you press Ctrl + X after selecting some cells in Excel?
A) The cell content of selected cells disappears from the cell and get stored in the clipboard.
B) The cells selected are marked for cutting.
C) The selected cells are deleted and the cells are shifted left.
D) The selected cells are deleted and cells are shifted up.
91. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of
events that he will do for this?
A) Go to File-Save As, Type-Excel worksheet
B) Right click on the Spreadsheet tab and select Delete
C) Right click on the Spreadsheet and select Insert-Entire Column
D) None of the above
92. What is/are the function/s of a backup?
A) To restore the backed up information.
B) To retrieve the system files.
C) To restore the system in the event of a system crash or failure
D) All of the above
93. Match the appropriate application software with their respective functions and
find out the correct combination.
a) MS-Word i) Database Management
b) MS-Access ii) Word Processing
c) Power Point iii) Spreadsheet
d) Excel iv) Presentation of slides
A) a-iv, b-iii, c-ii, d-i
B) a-ii, b-iii, c-iv, d-i
C) a-ii, b-iv, c-i, d-lii
D) a-ii, b-i, c-iv, d-iii
94. Match the following.
1.Scanner A. Input Device
2.OCR B. Output Device
3.Light pen
4.Printer
A) IA, 2B, 3A, 4A
B) IA. 2A, 3A, 4B
C)IA. 2A, 3B, 4B
D) 1A, 2B. 3A, 4B
95. The purpose of Undo button is to
A) restore a deleted file from the disk.
B) remove both the existing text and the previous one permanently.
C) remove the existing text and restore the pre-edited text.
D) all of the above
96. What happens when you delete a text box object from a slide in PPT?
A) The object is deleted but text box and the text inside is left on the slide.
B) The text box is deleted and the text is pasted on the slide.
C) Both the text box and text are deleted.
D) None of the above
97. The size of the Organization chart object in MS PowerPoint
A) is determined by the presentation design and cannot be changed
B) is determined by the presentation design but can be changed in PowerPoint
C) is dependent on the amount of text within the Organization chart
D) Both B and C
98. A clipboard is
A) used to save data on disk in the event of a powerful failure
B) able to retain the contents even when computer is switched off
C) available only in Microsoft Word
D) a storage in the computer memory for temporarily storing the cut or copied data.
99. Which of the following commands is not applicable in MS-Word?
A) Ctrl + I to italicize the selected text
B) Ctrl + B to bold the selected text
C) Ctrl + U to underline the selected text
D)None of the above
100. A red wavy line under a word indicates that the word
A) is too long for the line of text
B) is not in the dictionary file and therefore might be misspelled.
C) is not appropriate for that particular sentence
D) is a verb
BASIC COMPUTER SKILL
SECTION-B:20 Marks
Instructions: Each question under this section carries one mark. Please read each question carefully and answer them by selecting the right one out of the multiple answers given below each as A, B, C and D.
101. Which of the following is an instruction to calculate or process data in MS Excel?
A) Worksheet
B) Formula
C) Range
D) Text entries
102. Formatting option is available in which menu in MS-Excel?
A) Format
B) Edit
C) Windows
D) File
103. Which file format can be added to a PowerPoint show?
A).gif
B).jpg
C).wav
D) All the above
104. VIRUS stands for
A) Virtual Important Resource Under Search
B) Vital Information Resource Under seize
C) Verity Interchange Result Until Source
D) Very Important Record User Searches
105. Where was India’s first Computer installed and when?
A) Indian Institute of Technology, Delhi, in 1977
B) Indian Institute of Science, Bangalore, in 1971
C) Indian Iron & Steel Co. Ltd., in 1968
D) Indian Statistical Institute, Calcutta, in 1955
106. If you need to edit “Header” or “Footer” of a document which menu/tab should you access in MS Office word 2007 and onwards?
A) Insert
B ) Edit
C) View
D) Tools
107. Personal digital Assistants and Smartphones are the most widely used…..
A) Handheld Computer
B) Minicomputer
C) Supercomputer
D) None of these
108. What is the default format for saving a word document in MS-Word 2007 and above?
A) .doc
B).docx
C).txt
D).demt
109. Find and Replace utility is available in
A) MS-Word
B) MS- Excel
C) MS-Power Point
D) All of the above
110. What is the formula to be used to add two cells (Al and A2) in MS-EXCEL?
A) =A1+A2
B) =Add (Al+A2)
C) =Together (A1:A2)
D) Al plus A2
111. Which command will you choose to convert a column of data into row in MS Excel?
A) Cut and Paste
B) Edit>> Paste Special >> Transpose
C) Both of the above
D) None of the above
112. To select one hyperlink after another during a slide presentation, what do you press?
A) TAB
B) Ctrl + K
C) Ctrl +H
D) All of these
113. Which short cut key inserts a new slide in the current presentation?
A) Ctrl+N
B) Ctrl+M
C) Ctrl+S
D) All of the above
114. Which of the following can be used to animate how the presentation moves from one slide to the text
A) Transmission
B) Transitions
C) Translation
D) Transformation
115. What process should be used to recall a document saved previously?
А) Copy
B) Save
C) Open
D) Enter
116. What is the shortcut key you can press to create a copyright symbol?
A) Alt+ Ctrl+ C
B ) Alt +C
C) Ctrl +C
D) Ctrl+Shift +C
117. Which of the following one is in correct order?
A) Megabyte> Kilobyte> Byte > Bit
B) Kilobyte > Megabyte > Byte > Bit
C) Byte > bit > Megabyte >Kilobyte
D) None of these
118. Portrait and Landscape are:
A) Page Orientation
B) Paper Size
C) Page Layout
D) All of the above
119. The term QWERTY keyboard means the keyboard layout of the___ alphabetic characters found on the top row of keys displaying letters.
A) First Six
B) Last Six
C) First Three
D) Last Three
120. In Microsoft PowerPoint two kinds of sound effect files that can be added to the presentation are
A) WAV files and MID files
B) WAV files and GIF files
C) WAV files and JPG files
D) JPG files and GIF files