Uttarakhand Data Entry Operator Exam Paper (Group C) – 2014

121. When you move your mouse over a sizing handle the pointer becomes a
(a) Round arrow
(b) Two headed arrow
(c) Plus sign
(d) Four headed arrow
Show AnswerAnswer – B

122. Which of the following is an absolute cell address ?
(a) Al
(b) #a+1
(c) $A$1
(d) !A!1
Show AnswerAnswer – C

123. Workbook is a collection of……………in MS-Excel.
(a) Books
(b) Workbooks
(C) Tabs
(d) Sheets
Show AnswerAnswer – D

124. A…………..is a visual representation of data in MS-Excel.
(a) Chart
(b) Picture
(c) Graphic
(d) Table
Show AnswerAnswer – A

125. In MS-Excel…………… is a method / tool which aids you in forecasting values.
(a) Find
(b) Replace
(C) Goal seek
(d) Go To
Show AnswerAnswer – C

126. Which of the following functions of MS-Excel 2007 display the sum of the selected cells just after the selected cells ?
(a) SUM
(b) TOTAL
(c) ADD
(d) None of these
Show AnswerAnswer – A

127. Which of the following command of Excel convert a column of data into row ?
(a) Cut and Paste
(b) Paste special > Transpose
(c) Orientation
(d) None of the above
Show AnswerAnswer – B

128. Which of the following function in Excel 2007 count the number of characters in a cell ?
(a) Length
(b) LGT
(C) LT
(d) LEN
Show AnswerAnswer – D

129. The command Home » Edit » Fill Across worksheet of Excel 2007 is active only when
(a) one sheet is selected.
(b) when many sheets are selected.
(c) when no sheet is selected.
(d) None of the above
Show AnswerAnswer – B

130. In MS-Excel list of only those entries which meet certain criteria, can be obtained by using menu
(a) Data > Sort
(b) Data » Filter
(c) Format » Sheet
(d) None of the above
Show AnswerAnswer – B

131. How do you save a presentation under a new file name ?
(a) Select the file menu and choose save as
(b) When you choose PowerPoint the file will automatically be saved
(c) Select the file menu and choose save
(d) None of the above
Show AnswerAnswer – A

132. A character that is raised and smaller in size and placed above the baseline is known as
(a) Outlined
(b) Raised
(C) Superscript

(d) Subscript
Show AnswerAnswer – C

133. Which of the following is a presentation graphics software ?
(a) MS-Windows
(b) MS-PowerPoint
(c) MS-Excel
(d) MS-Word
Show AnswerAnswer – B

134. Which command brings you to the first slide in your presentation ?
(a) Page Up
(b) Shift + Home
(c) Alt + Home
(d) Ctrl + Home
Show AnswerAnswer – D

135. PowerPoint lets you add new slide to your presentation using
(a) Insert » Slide
(b) Insert » New Slide
(c) Format » New Slide
(d) None of the above
Show AnswerAnswer – B

136. To decrease the font size, the shortcut used is………….in presentation.
(a) Ctrl + Shift +>
(b) Ctrl + Shift +<
(C) Ctrl +>
(d) Ctrl +<
Show AnswerAnswer – B

137. To personalize your AutoCorrect, use
(a) Tools » AutoCorrect
(b) Insert > AutoCorrect
(c) Format → AutoCorrect
(d) None of the above
Show AnswerAnswer – A

138. Ctrl + H is used to
(a) Invoke find dialog box
(b) Invoke replace dialog box
(c) Both (a) and (b)
(d) None of the above
Show AnswerAnswer – B

139. To add a chart to the slide use
(a) Insert > Chart

(b) Tools » Chart
(c) File → Chart
(d) None of the above
Show AnswerAnswer – A

140. Which of the following allows you to select more than one slide in a presentation ?
(a) Alt + Click each slide
(b) Shift + drag each slide
(c) Shift + click each slide
(d) Ctrl + click each slide
Show AnswerAnswer – C

Pages: 1 2 3 4 5 6 7 8 9 10