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 Answer
Hide Answer
122. Which of the following is an absolute cell address ?
(a) Al
(b) #a+1
(c) $A$1
(d) !A!1
Show Answer
Hide Answer
123. Workbook is a collection of……………in MS-Excel.
(a) Books
(b) Workbooks
(C) Tabs
(d) Sheets
Show Answer
Hide Answer
124. A…………..is a visual representation of data in MS-Excel.
(a) Chart
(b) Picture
(c) Graphic
(d) Table
Show Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
133. Which of the following is a presentation graphics software ?
(a) MS-Windows
(b) MS-PowerPoint
(c) MS-Excel
(d) MS-Word
Show Answer
Hide Answer
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 Answer
Hide Answer
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 Answer
Hide Answer
136. To decrease the font size, the shortcut used is………….in presentation.
(a) Ctrl + Shift +>
(b) Ctrl + Shift +<
(C) Ctrl +>
(d) Ctrl +<
Show Answer
Hide Answer
137. To personalize your AutoCorrect, use
(a) Tools » AutoCorrect
(b) Insert > AutoCorrect
(c) Format → AutoCorrect
(d) None of the above
Show Answer
Hide Answer
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 Answer
Hide Answer
139. To add a chart to the slide use
(a) Insert > Chart
(b) Tools » Chart
(c) File → Chart
(d) None of the above
Show Answer
Hide Answer
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 Answer
Hide Answer
Leave a Reply