36. Which
of the
following series type is not
valid for Fill Series dialog
box?
(A) Linear (B) Growth (C) Auto fill (D) Time
37. Which
of the
following you can paste selectively
using Paste Special command?
(A) Validation (B) Formats (C) Formulas (D) All of above
38. Paste
Special allows some operation while
you paste
to new
cell. Which of the following
operation is valid?
(A) Square (B) Percentage (C) Goal
Seek (D) Divide
39. Edit
>> Delete command
(A) Deletes the
content of a cell (B) Deletes
Formats of cell
(C) Deletes the
comment of cell (D) Deletes
selected cells
40. To
remove the content of selected
cells you must issue command
(A) Edit >>
Delete (B) Edit
>> Clear >> Contents (C) Edit >>
Clear >> All (D) Data
>> Delete
41.
The Delete
key of
keyboard is assigned to which
command in Excel?
(A) Edit >>
Clear >> Contents (B) Edit
>> Clear >> All (C) Edit
>> Delete (D) All of above
42. If
you need
to remove
only the
formatting done in a range
(numbers and formula typed there
should not be removed),
you must
(A) From Edit
menu choose
Clear and then Formats (B) From
Edit menu
choose Delete
(C) Click
on Remove
Formatting tool on Standard Toolbar (D) Double
click the Format Painter and
then press
Esc key
in keyboard
43. By
default Excel provides 3 worksheets.
You need
only two
of them,
how will
you delete
the third
one?
(A) Right click
on Sheet
Tab of
third sheet and choose Delete
from the
context menu
(B) Click on
Sheet 3 and from Edit
menu choose
Delete
(C) Both of
above (d) None
of above
44.
Which of the following action
removes a sheet from workbook?
(A) Select
the sheet,
then choose
Edit >>
Delete Sheet (B) Select
the sheet
then choose
Format >> Sheet >> Hide
(C) Both
of above (D) None
of above
45.
While Finding and Replacing some
data in
Excel, which of the following
statement is valid?
(A) You can
Find and
Replace within the sheet or
workbook (C) Excel
does not
have option
to match
case for
find
(C) Both are
valid (D) None
are valid
46. Which
of the
following is not true about
Find and
Replace in Excel
(A) You can
search for bold and replace
with italics (B) You can
decide whether to look for
the whole
word or
not
(C) You can search
in formula
too (D) You can search
by rows
or columns
or sheets
47.
You can
move a
sheet from one workbook into
new book
by
(A) From
Edit menu
choose Move or Copy sheet,
mark the
Create a ccopy and Click
OK
(B)
From Edit
menu choose
Move of
Copy then
choose (Move to end) and
click OK
(C)
From Edit
menu choose
Move or
Copy then
select (new book) from To
Book list
and click
OK
(D) None
of above
48.
What is
the short
cut key
to replace
a data
with another
in sheet?
(A) Ctrl
+ R (B) Ctrl
+ Shift
+ R (C) Ctrl
+ H (D) Ctrl
+ F
49. Comments
put in
cells are called …..
(A) Smart
Tip (B) Cell Tip (C) Web
Tip (D)
Soft Tip
50. Comments
can be
added to cells using …..
(A) Edit
‐> Comments (B) Insert
‐> Comment (C) File
‐> Comments (D) View –>
Comments
51.
Which menu option can be
used to
split windows into two?
(A)
Format ‐> Window (B) View ‐>
Window‐> Split (C) Window ‐>
Split (D)
View –>
Split
52. Getting
data from
a cell
located in a different sheet
is called….
(A) Accessing (B) Referencing (C)
Updating (D)
Functioning
53.
Which of the following is
not a
valid data type in Excel?
(A)
Number (B)
Character (C)
Label (D)
Date/Time
54.
Which elements of a worksheet
can be
protected from accidental modification?
(A) Contents
(B)
Objects (C) Scenarios (D) All
of the
above
55. A
numeric value can be treated
as label
value if …… precedes it.
(A) Apostrophe
(‘) (B) Exclamation
(!) (C) Hash
(#) (D) Tilde (~)
56. Concatenation
of text
can be
done using
(A) Apostrophe (‘) (B) Exclamation (!) (C)
Hash (#) (D) Ampersand (&)
57. Which
area in
an Excel
window allows entering values and
formulas?
(A) Title
Bar (B)
Menu Bar (C)
Formula Bar (D) Standard Tool
Bar
58. Multiple
calculations can be made in
a single
formula using…..
(A) Standard
Formulas (B) Array
Formula (C) Complex
Formulas (D)
Smart Formula
59. An
Excel Workbook is a collection
of …….
(A) Workbooks (B) Worksheets (C) Charts (D) Worksheets and
Charts
60. What
do you
mean by
a Workspace?
(A) Group
of Columns (B) Group of
Worksheets (C)
Group of Rows (D) Group
of Workbooks
61. MS‐EXCEL
is based
on ……….?
(A) WINDOWS (B) DOS (C)
UNIX (D)
OS/2
62. In
EXCEL, you can sum a
large range of data by
simply selecting a tool button
called …..?
(A) AutoFill (B)
Auto correct (C)
Auto sum (D) Auto format
63. To
select an entire column in
MS‐EXCEL, press?
(A) CTRL
+ C (B)
CTRL +
Arrow key (C)
CTRL +
S
(D) None of the
above
64. To
return the remainder after a
number is divided by a
divisor in EXCEL we use
the function?
(A) ROUND
( ) (B) FACT (
) (C)
MOD (
) (D)
DIV (
)
65. Which
function is not available in
the Consolidate
dialog box?
(A) Pmt (B)
Average (C)
Max (D)
Sum
66. Which
is not
the function
of “Edit,
Clear” command?
(A) Delete
contents (B)
Delete notes (C)
Delete cells (D) Delete formats
67. Microsoft
Excel is a powerful………..
(A) Word
processing package (B)
Spreadsheet package
(C) Communication
S/W Package
(D)
DBMS package
68. How
do you
rearrange the data in ascending
or descending
order?
(A) Data,
Sort (B)
Data, Form (C).
Data, Table (D)
Data Subtotals
69. Which
Chart can be created in
Excel?
(A) Area (B)
Line (C)
Pie (D)
All of
the above
70. What
will be
the output
if you
format the cell containing 5436.8
as ‘#,##0.00′?
(A) 5430 (B)
5436.8 (C)
5436.8 (D)
6.8
No comments:
Post a Comment