25 questions appeared in Computer Typing Exam ENG 40 Speed of MS-Excel
MS-Excel 25 question :-
1. In the formula Vlookup("Mar",A1:D5,3,0),
'3' is ____
A.
Row
Number
B.
Cell
code
C.
Column
Index Number
D.
Table
Array
C
2. Shortcut of the save excel file____
A.
Ctrl+A
B.
Ctrl+C
C.
Ctrl+S
D.
Ctrl+X
C
3. Column are label as _____________
A.
1,2,3,4,...
B.
I,II,III,...
C.
A,B,C,D,...
D.
a,b,c,d,...
C
4. VLOOKUP is a logical function
A.
TRUE
B.
FALSE
B
5. Which function in MS Excel 2010 converts the
text into small case?
A.
=upper()
B.
=lowercase()
C.
=caps()
D.
=lower()
D
6. In MS-Excel, chart can be inserted through ___
Tab
A.
View
B.
Format
C.
Data
D.
Insert
D
7. What function converts row data in a column
data or column data in a row?
A.
hyperlink
B.
impose
C.
compose
D.
transpose
D
8. To Open a New Sheet _________Command is used
A.
Close
B.
New
C.
Sheet
D.
Blank
B
9. Worksheet can be added in word document using
____
A.
Copy
and Paste
B.
Linking
C.
Insert
D.
All
of these
D
10. "NOT" is a ............... type of function.
A.
Math's
B.
Date
& Time
C.
Logical
D.
Text
C
11. In Lookup Function, parameter 0 stands as
True.
A.
TRUE
B.
FALSE
B
12. Which of the following is used to navigate to
a 100 Cell in MS Excel 2010?
A.
find
& replace -> sort - >a100
B.
goto
tab - > link cell
C.
find
& select -> go to
D.
data
tab -> visit cell
C
13. Press Shift+TAB key combine______
A.
Move
Cell Pointer Left
B.
Move
Cell Pointer Up
C.
Move
Cell Pointer Right
D.
Move
Cell Pointer Down
A
14. To insert a row in MS Excel 2010 worksheet
add tab row option is used
A.
TRUE
B.
FALSE
B
15. ______ function returns the position in a
cell range given to a value.
A.
VLookup
B.
Hlookup
C.
Lookup
D.
Match
D
16. 'Pivot table' is used to summarize data.
A.
TRUE
B.
FALSE
A
17. In MS-Excel, with _____ style warning message
is given.
A.
error
B.
Warning
C.
Alert
D.
Stop
B
18. Spreadsheet is also called as _______
A.
Datasheet
B.
Worksheet
C.
Booksheet
D.
Datasheet
B
19. Which option from file menu is used to close
excel window?
A.
close
B.
stop
C.
shut
down
D.
end
A
20. All the commands in Excel are given in the
form of a Ribbon.
A.
TRUE
B.
FALSE
B
21. After protecting workbook, we can add
worksheet in the workbook.
A.
TRUE
B.
FALSE
B
22. The category of the function DAY() is ____
A.
Logical
B.
Finance
C.
Math
& Trig
D.
Date
and Time
D
23. By default, Locked protection is given by
Excel to all _____
A.
Tables
B.
functions
C.
Cells
D.
Data
C
24. In MS-Excel, arranging data in specific order
is known as _____
A.
Merging
B.
Wrapping
C.
Sorting
D.
Filtering
C
25. Which Short- Cut key is used for insert
Worksheet?
A.
Shift+F3
B.
Shift+F12
C.
Shift+F11
D.
Shift+F5
C
