MCQ SET 8:- MS-EXCEL - A SET OF OBJECTIVE QUESTIONS OR
MS-Excel is a popular spreadsheet calculation application
developed by Microsoft Inc.
141. To drag a selected range of data to another
worksheet in the same workbook, use the a.
Tab key
b.
Alt key
c.
Shift key
d.
Ctrl key
Correct Answer: d
142. When creating a vertical page break a. The active cell must be A1
b.
The active cell can be anywhere in the worksheet
c.
The active cell must be in row 1
d.
The active cell must be in column A
Correct Answer: c
143. to activate the previous cell in a
pre-selected range, press a. the Alt
key
b.
the Tab key
c.
the Enter key
d.
none of above
Correct Answer: d
144. When the formula bar is activated, you can
see a. The Edit Formula button
b.
The Cancel button
c.
The Enter button
d.
All of above
Correct Answer: d
145. In a worksheet you can select a. The entire worksheet
b.
Rows
c.
Columns
d.
a, b, and c
Correct Answer: d
146. when you print preview a worksheet a. the entire worksheet is displayed
b.
the selected range is displayed
c.
the active portion of the worksheet is displayed
d.
a, b and c
click the
a.
Unfreeze panes command on the window menu
b.
Freeze panes command on the window menu
c.
Hold titles command on the edit menu
d.
Split command on the window menu
Correct Answer: b
152. Which of these
is a quick way to copy formatting from a selected cell to two other cells on
the same worksheet?
a.
Use Ctrl to select all three cells, then click the
paste button on the standard toolbar
b.
Copy the selected cell, then select the other two
cells, click style on the Format menu, then click
Modify
c.
Click format painter on the Formatting toolbar twice
then click in each cell you want to copy the formatting to
d.
All of above
Correct Answer: c
153. To edit data in an embedded Excel worksheet
object in a Word document a. Use the
Excel menu bar and toolbars inside the word application
b.
Edit the hyperlink
c.
Edit the data in a Excel source application
d.
Use the Word menu bar and toolbars
Correct Answer: a. Use the Excel menu bar and toolbars
inside the word application
154. Status indicators are located on the
a. Vertical scroll bar
b.
Horizontal scroll bar
c.
Formula bar
d.
Formatting toolbar
Correct Answer: c
155. You can open the scenario Manager dialog
box by choosing scenarios from the ….. menu. a. View
b.
Insert
c.
Format
d.
Tools
Correct Answer: d
156. You can open the Sort dialog box by
choosing Sort from the ….. menu a. View
b.
Format
c.
Tools
d.
Data
Correct Answer: d
157. when working in the page break preview, you
can a. view exactly where each page
break occurs
b.
add or remove page breaks
c.
change the print area
d.
all of above
Correct Answer: d
158. A data map is
helpful
a.
When you have too much data to chart
b.
To show a geographic distribution of data
c.
To compare data points
d.
To show changes in data over time
Correct Answer: b
159. Rounding
errors can occur
a.
When you use multiplication, division or exponentiation
in a formula
b.
When you use addition and subtraction in a formula
c.
Because Excel uses hidden decimal places in computation
d.
When you show the results of formulas with different
decimal places than the calculated results Correct Answer: a
160. You can copy
data or formulas
a.
With the copy, paste and cut commands on the edit menu
b.
With commands on a shortcut menu
c.
With buttons on the standard toolbar
d.
All of the above Correct Answer: d
MCQ
Set 9:- MS-Excel - A set of Objective Questions or Multiple Choice Questions
(MCQs) suitable for Computer Jobs Exam such as computer operator conducted by
Public Service Commission (PSC) - Lok Sewa Ayog.
MS-Excel is a popular spreadsheet calculation application
developed by Microsoft Inc.
161. You can zoom a
worksheet
a.
With the mouse pointer in Print Preview
b.
With the zoom button on the Print Preview toolbar
c.
With the Zoom command on the view menu
d.
All of the above
Correct Answer: d
162. You can not link Excel worksheet data to a
Word document a. With the right drag
method
b.
With a hyperlink
c.
With the copy and paste special commands
d.
With the copy and paste buttons on the standard toolbar
Correct Answer: d. With the copy and paste buttons on the
standard toolbar
163. This type of software is similar to an
accountant’s worksheet a. Word processing
b.
Database
c.
Spreadsheets
d.
Graphics Correct Answer: c
164. which function will calculate the number of
workdays between 6/9/2004 and 8/12/2004? a.
Workday
b.
Date
c.
Networkdays
d.
All of the above
Correct Answer: d
165. Data marker on a chart are linked to data
points in a worksheet, therefore, a.
You can automatically apply formatting to a data series
b.
You can change the position of a data marker and
automatically change the data point value in the worksheet
c.
You
can change a data print value and automatically are draw the chart d. a and b
Correct Answer: b
166. When you group
worksheets
a.
You can enter variable data on multiple worksheets at
one time
b.
You can print more than one worksheet at a time
c.
You can enter common data, formats, and formulas on
multiple worksheets at one time d. b,
and c
Correct Answer: d
167. You can use the format painter multiple
times before you turn it off by a. You
can use the format painter button only one time when you click it
b.
Double clicking the format painter button
c.
Pressing the Ctrl key and clicking the format painter
button
d.
Pressing Alt key and clicking the format painter button
Correct Answer: b
168. The default header for a worksheet is
a. Your name
b.
The date and time
c.
None
d.
The sheet tab name
Correct Answer: c
No comments:
Post a Comment