25 Top Microsoft Excel Interview Questions and Answers with PDF Set-2 - Microsoft Excel
Microsoft Excel Questions and Answers
SET-II
PDF Download Click Here
1. MS Excel
20l0 in By
default how Sheet is ?
(A) 1
(B) 3
(C) 4
(D) None of these
Q. 2. Which of the following is
called a sheet made in Excel ?
(A) Document sheet
(B) Spread Sheet
(C) File Sheet
(D) Folder Sheet
Q.3 . Which formula is used to find
the average of any 5 student records in MS Excel ?
(A) Max
(B) Min
(C) Average
(D) Sum
Q.4 . We can
add hyperlink to our worksheet by
pressing which of the
following shortcut key ?
(A) Alt + K
(B) Ctrl+K
(C) Ctrl+H
(D) Ctrl+M
Q.5. By which of
these functions can current data insert be inserted ?
(A) Data
(B) Today
(C) Now
(D) Team
Q.6 . Is the default view of sheets
in Excel?
(A) Work
(B) Auto
(C) Normal
(D) Roman
Q.7. … …………… are predefine formulas that
perform the function of automatic calculation?
(A) Function
(B) Word-wrap
(D) Logical
Q.8. The key
to MS excel which is less of modification is
-
(A) F1
(B) F2
(C) F3
(D) F4
Q.9. Which of the following
is not a term for Excel ?
(A) Cell
(B) Rows
(C) Column
(D) Document
Q.10. To go to the previous work sheet, we
use ………….
(A) Alt+ Page Up
(B) Ctrl+ Page Up
(C) Ctrl+ Page Down
(D) Shift+ Tab
Q.11. In the formula, the adjustable
range is specified by the cell address from the beginning to the end and
separating it by …….
(A) Semicolon
(B) Coma
(C) Fullstop
(D) colon
Q.12. Data on the information available
Reprejent the visual posture and draw ways to understand |
(A) chart
(B) Table
(C) Semicolon
(D) colon
Q.13 . If you do not want to do
direct editing in your worksheet, then you can also use ..... to edit and enter
data.
(A) Formula Bar
(B) Titlebar
(C) Menubar
(D) Spacebar
Q.14. This tab contains proofing
tools like -
(A) review
(B) data
(C) view
(D) Insert
Q.15 . If you want to print in wide
format, how will you use page orientation?
(A) Landscape
(B) Portrait
(C) Horizontal
(D) Lonely
Q.16 . ......... are pre-written
formulas which do the work of automatic calculation.
(A) function
(B) equation
(C)
Templates
(D) reaction
Q.17. MS Excel 2010 is used in
a variety of ways ... from simple to complex tasks.
(A) Count
(B) Manipulation
(C) Presentation
(D) expression
Q.18. The text in the upper margin of the
page is called ........
(A) Footer
(B) Column
(C) header
(D) Paragraph
Q.19. For easy reading, information
using ........ is organized into horizontal rows and vertical
columns.
(A) Cell
(B) Sheet
(C) box
(D) Table
Q.20. The "Excel"
formula represents the cell's address $ A $ 4 -
(A) Relative cell reference
(B) Mixed cell reference
(C) absolute cell reference
(D. ALL OF THE ABOVE
Q.21. .......... is a rule that helps in
predicting value.
(A) Find
(B) Replace
(C) Round Seek
(D) Go to
Q.22. Which of these characters is not
used while designating a folder / file -
(A) <>
(B) :
(C) \
(D. ALL OF THE ABOVE
Q.23. Which is the feature of MS Excel
that makes it easy to replicate and extend the series logically-
(A) Auto Fill
(B) Auto Correct
(C) A and B
(D. ALL OF THE ABOVE
Q.24. To select all the contents of
a document we use:
(A) Ctrl+A
(B) Ctrl+B
(C) Ctrl+C
(D) Ctrl+X
Q.25. In MS Excel 2010, the extension of
the template file is ……….
(A) .docx
(B) .yltx
(C) .xlsx
(D) .zltx
PDF Download Click Here
ANSWER SHEET
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
|
B
|
B
|
C
|
C
|
B
|
C
|
A
|
B
|
D
|
B
|
D
|
A
|
A
|
A
|
A
|
|
16
|
17
|
18
|
19
|
20
|
21
|
22
|
23
|
24
|
25
|
|
|
|
|
|
|
A
|
A
|
C
|
D
|
C
|
C
|
D
|
B
|
A
|
A
|
|
|
|
|
|
