MS Excel
MS Excel
Questions Answers
·
1. With which of the following
all formulas in excel starts?
A.
/
B.
*
C.
$
D.
=
Answer: Option D
2. On an excel sheet the active
cell in indicated by ?
A.
A dotted border
B.
A dark wide border
C.
A blinking border
D.
By italic text
Answer: Option B
3. What term describes
explanatory text attached to a cell ?
A.
Context
B.
Callout
C.
Comment
D.
Dialog
Answer: Option C
4. How we can view a cell comment ?
A.
position the mouse pointer over
the cell
B.
click the comment command on
the view menu
C.
click the edit comment commands
on the Insert menu
D.
click the Display comment
command on the window menu
Answer: Option A
5. Which of these will not select all the cells in
a document ?
A.
Using the Edit – Select All
menu
B.
Pressing Ctrl + A on the
keyboard
C.
Clicking three times with the
right mouse button in the spreadsheet
Answer: Option C
6. The default style for new data keyed in a new
workbook is ?
A.
Comma
B.
Normal
C.
Currency
D.
Percent
Answer: Option B
7. If you press ___, the cell accepts your typing
as its contents ?
a. Tab
b. Ctrl+Enter
c. Enter
d. Alt+Enter
Answer: Option C
·
8. Which of the following keyboard shortcut can be
used for creating a chart from the selected cells ?
A.
F11
B.
F10
C.
F4
D.
F2
Answer: Option A
9. Formula palette is used to ?
A.
format cells containing numbers
B.
create and edit formulas
containing functions
C.
entered assumptions data
D.
copy all cells
Answer: Option B
10. A value used in a formula that does not change
is called a ?
A. Constant
B. Cell address
C. Varaible
D. Static
Answer: Option A
11. A Spreadsheet contains ?
A.
columns
B.
rows
C.
rows and columns
D.
None of above
Answer: Option C
12. To open an existing workbook, click the Open
button on the ___ toolbar?
A.
Form
B.
Standard
C.
Drawing
D.
Formatting
Answer: Option B
13. Which among following is not associated with
spelling dialogue box ?
A.
Edit
B.
Ignore
C.
Ignore All
D.
Change
Answer: Option A
14. what term describes a background that appears
as a grainy, non smooth surface ?
A.
Pattern
B.
Gradient
C.
Texture
D.
Velvet
Answer: Option B
·
15. Which among following is associated with excel
?
A.
Graphic program
B.
Word Processor
C.
Presentation
D.
Spreadsheet
Answer: Option D
16. The cell reference for a range of cells that
starts in cell C1 and goes over to column H and down to row 10 is ?
A.
C1:10H
B.
C1:H10
C.
C1:H-10
D.
C1:H:10
Answer: Option B
17. You can convert existing Excel worksheet data
and charts to HTML document by using the ?
A.
Internet Assistant Wizard
B.
Intranet Wizard
C.
Import Wizard
D.
Export Wizard
Answer: Option A
18. To create an interactive Pivot Table for the
web, you use a Microsoft Office Web component called ?
A.
HTML
B.
Pivot Table Field List
C.
Pivot Table Report
D.
Pivot Table List
Answer: Option C
19. What function displays row data in a column or
column data in a row ?
A. Transpose
B. Index
C. Rows
D. Hyperlinks
Answer: Option A
20. Except which of the following function, a
formula with a logical function shows the word "TRUE" or
"FALSE" as a result ?
A.
NOT
B.
OR
C.
IF
D.
AND
Answer: Option C
21. Macros can be executed from the which of the
following menu ?
A.
Format
B.
Home
C.
Insert
D.
Tools
Answer: Option D
Explanation:
·
22. Protection and the Protect Sheet options can be
selected from ?
A.
Data
B.
Tools
C.
Edit
D.
Format
Answer: Option B
23. Which of the following is not a valid Zoom
percentage in Excel ?
A.
10
B.
100
C.
300
D.
400
Answer: Option D
24. You can check the conditions against ____ when
applying conditional formatting ?
A.
Cell Value
B.
Formula
C.
Both of above
D.
None of above
Answer: Option C
25. How can we set Page Border in Excel ?
A.
From Edit menu
B.
From Home
C.
You can not set page border in
Excel
D.
From Tools menu
Answer: Option C
26. Which function calculates your monthly mortage
payment ?
A.
PV
B.
NPER
C.
PMT
D.
All of above
Answer: Option C
27. Which types of charts can excel produce ?
A.
Line graphs and pie charts only
B.
Bar charts, line graphs and pie
charts
C.
Bar charts and line graphs only
D.
Only line graphs
Answer: Option B
28. How is data organized in a spreadsheet ?
A.
Rows and columns
B.
Layers and planes
C.
Lines and spaces
D.
Height and width
Answer: Option A
Explanation:
·
29. VLOOKUP function used to ?
A.
Finds related records
B.
Looks up text that contain
"v"
C.
Check if two cells are
identical
D.
None of above
Answer: Option A
30. Gridlines may be turned off for display but
turned on for printing.
A.
True
B.
False
Answer: Option A
31. How do you change column width to fit the
contents ?
A.
Single-click the boundary to
the left to the column heading
B.
Double click the boundary to
the right of the column heading
C.
Press Alt and single click
anywhere in the column
D.
All of above
Answer: Option B
32. To insert three columns between columns A and B
you would
A.
Select column A
B.
Select A and B
C.
Select B
D.
All of above
Answer: Option C
33. To drag a selected range of data to another
worksheet in the same workbook, use the ?
A.
Ctrl key
B.
Shift key
C.
Alt key
D.
Tab key
Answer: Option A
34. You can activate a cell by ?
A.
Pressing the Tab key
B.
Clicking the cell
C.
Pressing an arrow key
D.
All of above
Answer: Option D
35. A function inside another function is known as
?
A.
Round function
B.
Sandwich function
C.
Switch function
D.
Nested function
Answer: Option D
Explanation:
·
36. What excel feature can you use if you want to
work with one record at a time ?
A.
Auto Complete
B.
Data Form
C.
Set Form
D.
Auto Text
Answer: Option B
37. Which function is used for creating a data
table ?
A.
Sum
B.
Table
C.
Add
D.
Count
Answer: Option B
38. The accounting style shows negative numbers in
?
A.
Bold
B.
Italics
C.
Parentheses
D.
Quotes
Answer: Option C
39. 3-D reference in a formula ?
A.
Spans worksheets
B.
Can not be modified
C.
Only appears on summary
worksheets
D.
Limits the formatting options
Answer: Option A
40. Auto calculate feature provides a quick way to
view the results of an arithmetic operation on a range of cells.
A.
True
B.
False
Answer: Option A
41. Which among following wildcard characters are
recognized by excel ?
A.
+ and -
B.
! and ^
C.
and ?
D.
< and >
Answer: Option C
42. Which among following is divide symbol in excel
?
A.
/
B.
D
C.
Div
D.
\
Answer: Option A
Explanation:
·
43. Which function in excel counts the numbers of
characters in a cell ?
A.
LENGHT
B.
LGT
C.
LT
D.
LEN
Answer: Option D
44. Which function converts miles to kilometers ?
A.
Change
B.
Covnert
C.
Shift
D.
Conv
Answer: Option B
45. What is shortcut to enter current date in cell
in excel ?
A.
Ctrl + ;
B.
Alt + ;
C.
Shift + &
D.
Ctrl + $
Answer: Option A
46. Shortcut to edit the selected cell ?
A.
F3
B.
F8
C.
F4
D.
F2
Answer: Option D
47. Each excel can contain many sheets including
worksheets and chart sheets.
A.
True
B.
False
Answer: Option A
48. Which shortcut can be used to Switch between
open workbooks ?
A.
Ctrl + F2
B.
Ctrl + F6
C.
Ctrl + F8
D.
Ctrl + F10
Answer: Option B
49. Shortcut to delete the selected column ?
A.
Ctrl + -
B.
Alt + -
C.
Shift + -
D.
Insert + -
Answer: Option A
·
50. Shortcut to enter current date ?
A.
Home + ;
B.
Shift + ;
C.
Alt + ;
D.
Ctrl + ;
Answer: Option D
51. When the formula bar is activated, you can see
A.
The Edit Formula button
B.
The Cancel button
C.
The Enter button
D.
All of above
Answer: Option D
52. Style sheet formats can be applied from ?
A.
Table >> Autoformat
B.
Format >> Autoformat
C.
Table >> Cells
D.
Fromat >> Cells
Answer: Option B
53. Which function will you use to enter current
time in a woksheet cell ?
A.
=time()
B.
=nowtime()
C.
=now()
D.
=currentTime()
Answer: Option C
54. Merge cells option can be applied from ?
A.
Formatting toolbar
B.
Format Cells dialog box
Alignment Tab
C.
Both of above
D.
None of above
Answer: Option B
55. How many recent files you can display on File
menu at maximum ?
A.
3
B.
7
C.
9
D.
15
Answer: Option C
56. The name box appears at the ?
A.
left of the formula bar
B.
right of the formula bar
C.
below the status bar
D.
below the menu bar
Answer: Option A
·
57. Entire worksheet can not be selected in one
time.
A.
True
B.
False
Answer: Option B
58. Where are the status indicators located ?
A.
Horizontal Scroll
B.
Vertical Scroll
C.
Formula bar
D.
Address bar
Answer: Option C
59. Insert picture option is in which of the
following toolbars ?
A.
Standard
B.
Formatting
C.
Drawing
D.
Picture
Answer: Option D
60. What term refers to a specific set of values
saved with the workbook ?
A.
Range
B.
File set
C.
Data set
D.
Scenario
Answer: Option D
61. We can cancel marquee by pressing ?
A.
Ctrl + Esc
B.
Alt + Esc
C.
Shift + Esc
D.
Esc
Answer: Option D
62. Which of the following methods cannot be used
to edit the content of cell ?
A.
Pressing F2
B.
Clicking the formula bar
C.
Pressing the Alt key
D.
Double clicking the cell
Answer: Option C
63. When you use multiplication, division or
exponentiation in a formula then there is chance of occurring rounding errors.
A.
True
B.
False
Answer: Option A
Explanation:
·
64. Which among following can't be considered as
worksheet criterion ?
A.
Efficiency
B.
Auditability
C.
Clarity
D.
Description
Answer: Option D
65. When creating a vertical page break ?
A.
The active cell must be in row
1
B.
The active cell must be A1
C.
The active cell must be in row
10
D.
The active cell must be in
column A
Answer: Option A
66. The intersection of row and column is called a
?
A.
dataset
B.
cell
C.
data
D.
set
Answer: Option B
67. You will use which feature in excel, if you
want to work with one record at a time ?
A.
Auto Complete
B.
Auto Filter
C.
Sub Totals
D.
Data Form
Answer: Option D
68. Which dialogue box we can use to name a constant
?
A.
Create Name
B.
Define Name
C.
Get Name
D.
Create Constant
Answer: Option B
69. One cell format can be copied to another cell
by using ?
A.
Format Painter
B.
Format Setting
C.
Format Showing
D.
Format Checking
Answer: Option A
70. Which among following is types of excel data
types ?
A.
Numbers, Formulas, Labels
B.
Data, Words, Numbers
C.
Words, Number, Labels
D.
Equations, Data, Numbers
Answer: Option A
<script type="text/javascript"> var infolinks_pid = 2754482; var infolinks_wsid = 0; </script> <script type="text/javascript" src="//resources.infolinks.com/js/infolinks_main.js"></script>
<script type="text/javascript"> var infolinks_pid = 2754482; var infolinks_wsid = 0; </script> <script type="text/javascript" src="//resources.infolinks.com/js/infolinks_main.js"></script>
