1. Which
of the
following format you can decide
to apply
or not
in AutoFormat
dialog box?
(A) Number
format (B)
Border format (C) Font format
(D) All of
above
2. How
can you
remove borders applied in cells?
(A) Choose
None on
Border tab of Format cells
(B) Open the list on
Border tool in Formatting toolbar
then choose
first tool(no
border)
(C) Both
of above
(D)
None of above
03. Where
can you
set the
shedding color for a range
of cells
in Excel?
(A) Choose
required color form Patterns tab
of Format
Csells dialog box
(B) Choose
required color on Fill Color
tool in
Formatting toolbar
(C) Choose required
color on Fill Color tool
in Drawing
toolbar
(D) All
of above
4. You
can set
Page Border
in Excel
from
(A) From
Border tab in Format Cells
dialog box
(B)
From Border
tool in
Formatting toolbar
(C) From Line
Style tool in Drawing toolbar (D) You can
not set
page border
in Excel
5. When
all the
numbers between 0 and 100
in a
range should be displayed in
Red Color,
apply
(A) Use
=if() function to format
the required
numbers red
(B) Apply Conditional
Formatting command on Format menu
(C) Select
the cells
that contain
number between 0 and 100
then click
Red color
on Text
Color tool
(D) All of above
6. You
can check
the conditions
against when applying conditional
formatting
(A) Cell
value (B) Formula (C) Both
of above (D) None
of above
07. Which
of the
following is not true regarding
Conditional Formatting?
(A) You
can add
more than
one condition
to check
(B) You
can set
condition to look for Bold
and apply
Italics on them.
(C) You
can apply
Font, border and pattern formats
that meets
the specified
conditions
(D) You
can delete
any condition
from Conditional
Formatting dialog box if it
is not
required.
08. Which
of the
following is invalid statement?
(A) Sheet
tabs can
be colored
(B) Some
picture can be applied as
a background
of a
sheet
(C) You can set the column width
automatically fit the amount of
text d. The width of a
row and be specified manually
or fit
automatically
09. You
can use
the formula
palette to
(A) format cells
containing numbers (B) create
and edit
formula containing functions
(C) enter
assumptions data (D)
copy a
range of cells
10.
When a
range is selected, how can
you activate
the previous
cell?
(A) Press the
Alt key
(B) Press
Tab (C) Press
Enter
(D)
None of above
11.
Which tool you will use
to join
some cells
and place
the content
at the
middle of joined cell?
(A) From Format
Cells dialog box click on
Merge Cells check box
(B) From Format
Cells dialog box select the
Centered alignment
(C) From
Format Cells dialog box choose
Merge and Center check box
(D) Click
on Merge
and Center
tool on
formatting
toolbar.
12. Tab
scroll buttons are place on
Excel screen
(A) towards the
bottom right corner (B) towards
the bottom
left corner
(C) towards the
top right
corner (D) towards
the top
left corner
13.
The Name
box on
to the
left of
formula bar
(A) shows the
name of
workbook currently working on
(B) shows the name of worksheet currently
working on
(C) shows the
name of
cell or
range currently working on
(D) None of
above
14. Each
excel file is a workbook
that contains
different sheets. Which of the
following cannot be a sheet in
workbook?
(A) work
sheet (B) chart
sheet (C) module
sheet (D) data
sheet
15.
Which of the following is
not the
correct method of editing the
cell content?
(A) Press the
Alt key
(B) Press
the F2
key (C) Click
the formula
bar (D) Double
click the cell
16. You
can merge
the main
document with data source in
Excel. In mail merge operation,
Word is
usually
(A) server (B) source (C)
client (D) none
17.
How can
you update
the values
of formula
cells if Auto Calculate mode
of Excel
is disabled?
(A) F8 (B) F9 (C) F10 (D) F11
18.
You want
to set
such that
when you
type Baishakh
and drag
the fill
handle, Excel should produce Jestha, ashadh
and so on. What
will you
set to
effect that?
(A) Custom
List (B) Auto
Fill Options (C) Fill
Across Worksheet (D) Fill Series
19.
Where can you change automatic
or manual
calculation mode in Excel?
(A) Double
CAL indicator
on status
bar
(B) Go to
Tools >> Options >> Calculation
and mark
the corresponding
radio button
(C) Both of
above (D) None
of above
20.
How can
you show
or hide
the gridlines
in Excel
Worksheet?
(A) Go to
Tools >> Options >> View
tab and
mark or
remove the check box named
Gridline
(B) Click Gridline
tool on
Forms toolbar C) Both
of above (D) None
of above
21.
Which of the following Excel
screen components can NOT be
turned on or off?
(A) Formula Bar
(B) Status
Bar (C)
Tool
Bar (D) None
of above
22.
What happens
when you
press Ctrl + X after
selecting some cells in Excel?
(A) The cell
content of selected cells disappear
from cell
and stored
in 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
23.
Which of the following option
is not
available in Paste Special dialog
box?
(A) Add (B) Subtract (C) Divide (D) SQRT
24.
Which command will you choose
to convert
a column
of data
into row?
(A) Cut and Paste (B) Edit
>> Paste Special >> Transpose
(C) Both
of above (D) None of
above
25. It
is acceptable
to let
long text
flow into
adjacent cells on a worksheet
when
(A) data will
be entered
in the
adjacent cells (B) no data will
be entered
in the
adjacent cells
(C) there is
no suitable
abbreviation for the text (D) there
is not
time to
format the text
26.
Which of the cell pointer
indicates you that you can
make selection?
(A) Doctor’s
symbol (Big Plus) (B) small
thin plus
icon
(C) Mouse
Pointer with anchor at the
tip (D) None
of above
27.
Which of the cell pointer
indicates that you can fill
series?
(A) Doctor’s
symbol (Big Plus) (B) small
thin plus
icon
(C)
Mouse Pointer with anchor at
the tip
(D) None
of above
28.
Which of the cell pointer
indicate that you can move
the content
to other
cell?
(A) Doctor’s
symbol (Big Plus) (B) small
thin plus
icon
(C) Mouse Pointer
with anchor
at the
tip (D)
None of
Above
29.
You can
auto fit
the width
of column
by
(A) double clicking
on the
column name on column header
(B) Double click on the
cell pointer
in worksheet
(C) Double
clicking on column right border
on column
header (D) Double
clicking on the column left
border of column
header
30. Long
text can
be broken
down into
many lines
within a cell. You can
do this
through
(A) Wrap Text
in Format
>> Cells (B) Justify
in Edit
>> Cells
(C) Text Wrapping
in Format
>> Cells, Layout tab (D)
All of
above
31. MS
Excel provides the default value
for step
in Fill
Series dialog box
(A) 0 (B) 1 (C) 5 (D) 10
32.
When a
row of
data is
to be
converted into columns
(A) Copy
the cells
in row,
select the same number of
cells in row and paste
(B) Copy
the cells
in column
then choose
Edit >>
Paste Special, then click Transpose
and OK
(C) Copy
the cells
then go
to Format
>> Cells then on Alignment
tab click
Transpose check box and click OK
(D)
Select the cells then place
the cell
pointer on new cell and
choose Edit >> Paste Special,
mark
Transpose check
box and
click OK.
33.
Ctrl +
D shortcut
key in
Excel will
(A) Open
the font
dialog box (B) Apply
double underline for the active
cell
(C) Fill down
in the
selection (D) None
of above
34. The
short cut key Ctrl +
R is
used in
Excel to
(A) Right align
the content
of cell (B) Remove
the cell
contents of selected cells
(C) Fill the
selection with active cells to
the right
(D) None
of above
35. The
command Edit >> Fill Across
Worksheet is active only when
(A) One
sheet is selected (B) When
many sheets
are selected
(C) When no
sheet is selected (D) None
of above
No comments:
Post a Comment