Excel multiple question and answer
____ appear at the bottom of the Excel window.
(A) Title bar
(B) Formula bar
(C) Work sheet tabs
(D) Name box
Ans: C
What are the basic rectangular building blocks of a spreadsheet?
(A) Cells
(B) Zoom slider
(C) Help button
(D) All of these
Ans: A
Which of the following is not a term pertaining to spreadsheets?
(A) Cell
(B) Character
(C) Browser
(D) Formula
Ans: C
Another name for a pre-programmed formula in Excel is
(A) Cell
(B) Graph
(C) Function
(D) Range
Ans: C
Excel is a program that is used to prepare a
(A) Slide presentation
(B) Spreadsheet
(C) Text document
(D) Database
Ans: B
In which tab wrap text feature is present in MS Excel 2007?
(A) Formulas
(B) View
(C) Insert
(D) Home
Ans: D
Which of the
following identifies a cell in Excel?
(A) Address
(B) Formula
(C) Name
(D) Label
Ans: A
Address
Which term
is used to join the selected cells in to one cell?
(A) Filter
(B) Wrap
(C) Pivot
(D) Merge
Ans: D
Merge
Which of the
following Excel charts represents only one value for each variable?
(A) Bar
(B) Pie
(C) Line
(D) Function
Ans: B
Pie
A formula in
Excel always begins with an ____
(A) Equal
sign
(B) Colon
(C) Comma
(D) Space
Ans: A
Equal sign
When the CPU
detects an interrupt, then it saves its
(A) Previous
state
(B) Next
state
(C) Current
state
(D) All of
the above
Ans: C
Current
state
A (n) ____
is a series of two or more adjacent cells in a column or row or rectangular
group of cells.
(A) List
(B) Section
(C) Range
(D) Area
Ans: C
Range
What is the
extension of saved file in MS Excel?
(A) .xls
(B) .xks
(C) .xos
(D) .xbs
Ans: A
.xls
Which
command is used to close the window of Excel?
(A) Alt+ F4
(B) Ctrl + W
(C) Ctrl +R
(D) Ctrl+ C
Ans: A
Alt+ F4
What is the
total region surrounding the chart?
(A) Chart
area
(B) legend
(C) Clipart
area
(D) Plot
area
Ans: A
Chart area
____ returns
the least common multiple.
(A) LCCM()
(B) LCM()
(C) TLCM()
(D) RTLCM()
Ans: B
LCM()
This is not
a function category in Excel.
(A) Logical
(B) Text
(C)
Financial
(D) Data
series
Ans: D
Data series
How many
columns are there in old version of MS Excel?
(A) 250
(B) 256
(C) 265
(D) 269
Ans: B
256
Which bar
show the used formula of selected active cell?
(A) Formula
bar
(B) Ribbon
(C) Menu bar
(D) Scroll
bar
Ans: A
Formula bar
Typed text
showed in active cell and also in ___
(A) Formula
bar
(B) Ribbon
(C) Title
bar
(D) Scroll
bar
Ans: A
Formula bar
What is the
default row height of MS Excel?
(A) 10
(B) 12
(C) 13
(D) 15
Ans: D
15
Excel
documents are stored as files called
(A)
Workgroups
(B)
Worktables
(C)
Worksheets
(D)
Workforce
Ans: C
Worksheets
What refers
to the horizontal cells which can contain information?
(A) Ribbon
(B) Rows
(C) Columns
(D)
Horizontal scrollbar
Ans: B
Rows
Today
motherboard typically use
(A) 70 pin
modules
(B) 72 pin
modules
(C) 74 pin
modules
(D) 76 pin
modules
Ans: B
72 pin
modules
To minimize
the currently selected window, press
(A) Ctrl+
F11
(B) Ctrl+
F12
(C) Ctrl+ F9
(D) Ctrl+
F10
Ans: C
Ctrl+ F9
To maximize
the currently selected window, press
(A) Ctrl+ F9
(B) Ctrl+
F10
(C) Ctrl+
F11
(D) Ctrl+
F12
Ans: B
Ctrl+ F10
Which of the
following is the default numbers of worksheet in MS Excel?
(A) 2
(B) 3
(C) 4
(D) 5
Ans: B
3
Formulas in
Excel are made up of ___
(A)
Arithmetical operators and functions
(B) Only
arithmetic operators
(C) Only
symbols
(D) Only
functions
Ans: A
Arithmetical
operators and functions
The result
is a ___ value either TRUE or FALSE.
(A) Logical
(B)
Arithmetic
(C)
Algorithm
(D)
Logarithm
Ans: A
Logical
Which of the
following is the comparison operator?
(A) *
(B) ^
(C) =
(D) +
Ans: C
=
On an Excel
sheet, the active cell is indicated by
(A) A dark
wide border
(B) A dotted
border
(C) A
blinking border
(D) None of
the above
Ans: A
A dark wide
border
The letter
and number of the intersecting column and row is the
(A) Cell
location
(B) Cell
position
(C) Cell
address
(D) Cell
coordinates
Ans: C
Cell address
The ____
helps to identify various plotted data series.
(A) X-axis
(B) Y-axis
(C)
Gridlines
(D) Legend
Ans: D
Legend
Which sign
indicate to multiplication?
(A) Asterisk
(B) Caret
(C) Percent
sign
(D) Forward
slash
Ans: A
Asterisk
In a
spreadsheet, a ____ is a number you will use in a calculation.
(A) Value
(B) Cell
(C) Field
(D) Label
Ans: A
Value
____ is a
powerful tool used to create and format spreadsheets.
(A) Adobe
Photoshop CS
(B) Mozilla
Firefox
(C)
Microsoft Office PowerPoint
(D)
Microsoft Office Excel
Ans: D
Microsoft
Office Excel
Workbook is
a collection of
(A)
Worksheets
(B) Page
set-up
(C) Buttons
(D) Diagrams
Ans: A
Worksheets
The
worksheet names appear on tabs at the ____ of the workbook window.
(A) Bottom
right
(B) Bottom
left
(C) Top left
(D) Top
right
Ans: B
Bottom left
The result
of a formula in a cell is the
(A)
Displayed value
(B) Range
(C) Value
(D) Label
Ans: C
Value
____ is the
intersection of a row with a column.
(A) Cell
(B) Row
(C) Column
(D) All of
these
Ans: A
Cell
To display
the save as dialog box, press
(A) F2
(B) F3
(C) F5
(D) F12
Ans: D
F12
The default
file extension of MS-Excel is
(A) xlr
(B) xls
(C) exe
(D) exl
Ans: B
xls
Which
command is used to close the window of Excel?
(A) Alt + F4
(B) Ctrl + W
(C) Ctrl + R
(D) Ctrl + C
Ans: A
Alt + F4
What is the
default column width of MS Excel?
(A) 5.5
(B) 2.98
(C) 6.49
(D) 8.43
Ans: D
8.43
Press ____
to make the text bold in MS Excel.
(A) Ctrl + 1
(B) Ctrl + 2
(C) Ctrl + 3
(D) Ctrl + 4
Ans: B
Ctrl + 2
A
____ is rectangular grid of rows and columns used to enter data.
(A)
Cell
(B)
Spreadsheet
(C)
Worksheet
(D)
Workspace
Ans:
B
Spreadsheet
How
many rows are there in old version of MS Excel?
(A)
65536
(B)
65535
(C)
65534
(D)
65533
Ans:
A
65536
____
was the first spreadsheet on a microcomputer.
(A)
VisiCalc
(B)
Excel
(C)
Lotus 1-2-3
(D)
StarCalc
Ans:
A
VisiCalc
Press
____ to close the window of MS Excel.
(A)
Esc
(B)
Ctrl + Alt + C
(C)
Alt + F4
(D)
Ctrl + W
Ans:
C
Alt
+ F4
Which
Excel feature enables predefined layouts to selected tables in the worksheet?
(A)
Autograph
(B)
Autoformat
(C)
Header and Footer
(D)
Spelling and Grammar
Ans:
B
Autoformat
The
fill series dialog box in Excel has ____ sections.
(A)
1
(B)
2
(C)
3
(D)
4
Ans:
D
4
Which
of the following is an active cell in excel?
(A)
Cell address
(B)
Range
(C)
Formula
(D)
Current cell
Ans:
D
Current
cell
What
is the pictorial representation of worksheet data?
(A)
Chart
(B)
Clipart
(C)
WordArt
(D)
All of these
Ans:
A
Chart
Which
function displays row data in a column or column data in a row?
(A)
Rows
(B)
Transpose
(C)
Hyperlink
(D)
Index
Ans:
B
Transpose
___
operator, combines multiple references into one reference.
(A)
Ampersand
(B)
Space
(C)
Comma
(D)
Colon
Ans:
C
Comma
DOS
based spreadsheet package is
(A)
Smartsheet
(B)
Excel
(C)
Spread PRO
(D)
Lotus 1-2-3
Ans:
D
Lotus
1-2-3
When
we can create a chart on a separate sheet in the same workbook, it is called a
(A)
Chart sheet
(B)
Embedded chart
(C)
View sheet
(D)
View chart
Ans:
A
Chart
sheet
____
sign is used to create an absolute cell reference.
(A)
$
(B)
@
(C)
&
(D)
%
Ans:
A
$
#
VALUE! Refers to ___
(A)
Font value
(B)
Error in value
(C)
Subscript of the number value
(D)
Addition of value
Ans:
B
Error
in value
You
can undo and redo up to ____ action in Microsoft Office Excel, even after a
worksheet is saved.
(A)
50
(B)
99
(C)
100
(D)
500
Ans:
A
50
Press
___ to close an open menu or submenu, dialog box, or message window.
(A)
Tab+ctrl+6
(B)
Esc
(C)
Alt+ 5
(D)
Ctrl+ 1
Ans:
B
Esc
To
insert nonadjacent columns, hold down ____ while you select nonadjacent
columns.
(A)
Space
(B)
Ctrl
(C)
Tab
(D)
Alt
Ans;
B
Ctrl
In
a spreadsheet program, the ___ contains related worksheets and documents.
(A)
Cell
(B)
Formula
(C)
Column
(D)
Workbook
Ans:
D
Workbook
Forms
that are used to organise business data into rows and columns are called
(A)
Spreadsheets
(B)
Business forms
(C)
Registers
(D)
Transaction sheet
Ans:
A
Spreadsheets
Which
of the following characteristics is used to compute dynamically the results
from Excel data?
(A)
Chart
(B)
Formula and Function
(C)
Table
(D)
Diagram
Ans:
B
Formula
and Function
0 Comments