Informatics Assistant Capsules -16
71. How
do you
display current date and time
in MS
Excel?
(A) date
() (B)
Today () (C)
now () (D) time ()
72. How
do you
display current date only in
MS Excel?
(A) date
() (B)
Today () (C)
now () (D) time ()
73. How
do you
wrap the
text in
a cell?
(A) Format,
cells, font (B)
Format, cells, protection
(C) format,
cells, number (D)
Format, cells, alignment
74. What
does COUNTA
() function
do?
(A) counts
cells having alphabets (B) counts empty
cells
(C) counts
cells having number (D)
counts non‐empty cells
75. What
is the
short cut key to highlight
the entire
column?
(A) Ctrl+C (B)
Ctrl+Enter (C)
Ctrl+Page Up (D) Ctrl+Space Bar
76. In
the formula,
which symbol specifies the fixed
columns or rows?
(A) $ (B)
* (C)
% (D)
&
77. Excel
displays the current cell address
in the
……….
(A) Formula
bar (B) Status
Bar (C) Name
Box (D)
Title Bar
78. What
is the
correct way to refer the
cell A10
on sheet3
from sheet1?
(A) sheet3!A10 (B) sheet1!A10
(C) Sheet3.A10 (D)
A10
79. Which
language is used to create
macros in Excel?
(A) Visual
Basic (B)
C (C)
Visual C++ (D)
Java
80.
Which of the following is
not a
term of
MS‐Excel?
(A) Cells (B)
Rows (C) Columns (D) Document
81.
How many
worksheets can a workbook have?
(A) 3 (B)
8 (C) 255 (D) none
of above
82.
Which would you choose to
create a bar diagram?
(A)
Edit, Chart (B)
Insert, Chart (C) Tools, Chart (D) Format, Chart
83.
Which setting you must modify
to print
a worksheet
using letterhead?
(A) Paper (B)
Margin (C)
Layout (D)
Orientation
84. What
do you
call the
chart that shows the proportions
of how
one or
more data
elements relate to another data element?
(A)
XY Chart (B)
Line Chart
(C) Pie Chart (D) Column
Chart
85. The
spelling dialog box can be
involved by choosing spelling from
menu.
(A) insert (B)
file (C)
tools (D)
view
86.
Which key do you press
to check
spelling?
(A) F3 (B)
F5 (C)
F7 (D)
F9
87.
To record
a sequence
of keystrokes
and mouse
actions to play back later
we use:
(A)
Media player (B)
Sound Recorder
(C)
Calculator (D)
Macro Recorder
88. We
can save
and protect
the workbook
by
(A) Write
Reservation Password (B) Protection Password (C) Read‐only Recommended
(D) Any of
the above
89.
The first
cell in
EXCEL worksheet is labeled as
(A)
AA (B) A1 (C) Aa (D)
A0
90.
What happens
when dollar
signs ($) are entered in
a cell
address? (e$B$2:$B$10)
(A)
An absolute
cell address
is created.
(B)
Cell address
will change
when it
is copied
to another
cell.
(C)
The sheet
tab is
changed.
(D) The
status bar does not display
the cell
address.
91.
What are
the tabs
that appear
at the
bottom of each workbook called?
(A) Reference
tabs (B)
Position tabs (C) Location
tabs (D) Sheet
tabs
92. What
is represented
by the
small, black square in the
lower‐right corner of an active
cell or
range?
(A) Copy
handle (B)
Fill handle (C)
Insert handle (D)
Border
93.
In Excel,
a Data
Series is defined as what?
(A) A
type of
chart. (B)
A cell
reference.
(C) A collection of
related data (D) A
division of results
94.
In Excel,
the Fill
Color button on the Formatting
toolbar is used for what?
(A) To
insert a background. (B)
To add
borders.
(C) To
select a distribution of figures. (D)
To add
shading or color to a
cell range.
95.
In help
menu of
Excel, which of the following
tabs are
found?
(A)
Contents tab (B)
Answer Wizard tab (C) Index tab (D)
all of
the above.
96. A
is a grid
with labeled
columns and rows.
(A) Dialog
box (B)
Worksheet (C)
Clipboard (D)
Toolbar
97.
The active
cell:
(A) is
defined by a bold border
around the cell. (B) Receives the
data the
user enters.
(C) It
is the
formula bar. (D)
Only A
and B.
98. Which
function is used to calculate
depreciation, rates of return, future
values and loan payment amounts?
(A)
Logical (B)
Math &
Trigonometry (C)
Statistical (D)
Financial
99.
B7:B9 indicates:
(A) Cells
B7 and
cell B9
only. (B)
Cells B7 through B9. (C)
Cell
B8 only. (D) None of
the above.
100.
The Cancel
and Enter
buttons appear in the:
(A)
Title bar (B)
Formula bar (C) Menu bard (D)
Sheet tabs
No comments:
Post a Comment