Tuesday, September 29, 2015
Computer Fundamental MCQ Questions on Excel (Spreadsheet): Module 4
Posted by Tech Talim in: Computer Fundamental MCQ
1.
Each Excel file is called a workbook
because
a. It can contain text and data
b. It can be modified
c.
It can contain many sheets
including worksheets and chart sheets
d. You have to work hard to create it
2.
In an MS Excel worksheet the active
cell is indicated by …
e.
A dark wide boarder
f. A dotted border
g. A blinking border
h. None of above
3.
All worksheet formula in MS Excel ?
a.
Manipulate
values
b.
Manipulate
labels
c. Return a formula result
d.
Use
the addition operator
4.
The advantage of using a spreadsheet
is : –
a.
Calculations
can be done automatically
b.
Changing
data automatically updates calculations
c.
More
flexibility
d. All of the above
5.
There are three types of data found
in a spreadsheet. These are –*
a.
Data,
words, numbers
b. Numbers, formulas, labels
c.
Equations,
data, numbers
d.
Words,
numbers, labels
6.
A worksheet can have a maximum
of__________ number of rows
a.
256
b.
1024
c. 1048576
d.
32000
7.
Which of the following symbol is used
before a number to make it a label?
a. “(Quote)
b. = (equal)
c.
_
(underscore)
d.
‘(Apostrophe)
8.
The default numeric data aligned
within a cell of MS Excel Worksheet is –
a.
Left
b. Right
c.
Centre
d.
Justify
9.
The default text data aligned within
a cell of MS Excel Worksheet is –
a. Left
b.
Right
c.
Centre
d.
Justify
10.
Which of the following symbols is
used to write a formula in MS Excel?
a. =
b.
+
c.
(
d.
@
11.
The cell reference for a range of
cells that starts in cell B1 and goes over to column G and down to row 10 is……
a.
B1-G10
b.
B1.G10
c. B1:G10
d.
B1;
G10
12.
The Paste Special command lets you
copy and paste:
a.
The
resulting values of a formula instead of the actual formula
b.
Cell
comments
c.
Formatting
options
d. All of the above
13.
Getting data from a cell located in a
different sheet is called …
a.
Accessing
b. Referencing
c.
Updating
d.
Functioning
14.
Which of the following is an absolute
cell reference?
a.
!A!1
b. $A$1
c.
#a#1
d.
A1
15.
The advantage of using a spreadsheet
is : –
a.
Calculations
can be done automatically
b.
Changing
data automatically updates calculations
c.
More
flexibility
d. All of the above
16.
Which of the following formula has
not been entered correctly?
a.
=10+50
b.
=B7*B1
c.
=B7+14
d. 10+50
17.
Which of the following will return
the Maximum value of the cells between C19 to C29 in MS Excel?
a.
=Maximum
(C19:C29)
b. =Max (C19:C29)
c.
=Max
(C19 to C29)
d.
MS
Excel can’t do this task.
18.
Which one of the following stores the
whole value entered but only displays the number up to two decimal places?
a.
General
Number
b. Fixed
c.
Standard
d.
Currency
19.
When you enter a formula in a cell
and the cell displays #REF!
? It means -
a.
Excel
does not recognize text contained in the Formula
b.
Invalid
Column
c. A cell reference is invalid
d.
Contents
cannot be displayed correctly as the column is narrow
20.
When you enter a formula in a cell
and the cell displays #NAME?
It means -
a. Excel does not recognize the text contained in the Formula
b.
Invalid
Column
c.
Contents
cannot be displayed correctly as the column is narrow
d.
A
cell reference is invalid
21.
When you put a formula in a cell and
the cell displays #######?
It means -
a.
Excel
does not recognize text contained in the Formula
b.
A
Cell reference is invalid
c. Contents cannot be displayed correctly as the column is
narrow
d.
Invalid
Column
22.
When a label is too long to fit
within a MS Excel Worksheet cell, you typically must
a.
Shorten
the label
b. Increase the column width
c.
Decrease
the column width
d.
Adjust
the row height
23.
What do you mean by this query
expression >=#1/1/1999 and <1/1/2000?
a.
The
entry must be a date from 1999 to 2000
b. The entry must be a date in 1999
c.
Both
a & b
d.
None
24.
Each time you start the MS Excel
program, by default, it displays a new blank workbook containing _________
blank worksheets.
a.
Two
b. Three
c.
Four
d.
Five
25.
To select a column the easiest method
is to……
a.
Double
click any cell in the column
b.
Drag
from the top cell in the column to the last cell in the column
c. Click the column heading
d.
Click
the column label
26.
If you press ___________, the cell
accepts whatever you have typed as its contents.
a. a) Enter
b.
b)
Ctrl+Enter
c.
c)
Tab
d.
d)
Insert
27.
MS Excel uniquely identifies cells
within a worksheet with a cell name that consists of
a.
Cell
names
b.
Column
numbers and row letters
c. Column letters and row numbers
d.
Cell
locator coordinates
28.
You can select a single range of
cells by—
a.
Clicking
the upper-left cell in a group of cells and then pressing the Shift key while
clicking the lower right cell in a group of cells.
b.
Pressing
the Shift key and an arrow key
c.
Dragging
over the desired cells
d. Using any of the above options
29.
Which one of the following stores the
whole value entered but only displays the number up to two decimal places?
a.
General Number
b. Fixed
c.
Standard
d.
Currency
30.
Without using the mouse or the arrow
keys, what is the fastest way of getting to cell A1 in a spreadsheet?
a. Pressing Ctrl +Home
b.
Pressing
Home
c.
Pressing
Shift + Home
d.
Pressing
Alt + Home
31.
To hold row and column titles in
place so that they do not scroll away from view when scrolling an Excel
worksheet, we make use of –
a.
Unfreeze
panes command
b. Freeze panes command
c.
Hold
titles command
d.
Split
command
About Admin of the Blog:
Enamur Rahman Talim TechTalim .He is a Tech Geek, SEO Expert, Web Designer and a Pro Blogger. Contact Him Here
0 comments:
Post a Comment