1. What is extension of files created in MS-Excel 97-2003
(a) .xlx
(b) .msx
(c) .Dot
(d) .xls
2. What is extension of files
created in MS-Excel 2007-2015
(a) Txt
(b) XLS
(c) XLSX
(d) RTF
3. MS-Office is -
(a) Application Software
(b) System Software
(c) Operating System
(d) All of above
4. Which menu option in MS Excel has
the option to "Sort the Data"
(a) Review
(b) Data
(c) Formula
(d) Insert
5. Which is the correct formula for
SUM Function in MS Excel.
(a) /SUM(A1+A5)
(b) =SUM(A1-A5)
(c) =SUM(A1:A5)
(d) +SUM(A1:A5)
6. What is the use of VLOOKUP
function in MS Excel -
(a) to get the max value
(b) to copy a row
(c) to find things in a table
(d) None of these
7. Which button in MSExcel to
calculate the sum of number
(a) AutoSum
(b) Fill
(c) Insert
(d) Merge
8. What is the Shortcut key for
"Current Date" in Excel
(a) Ctrl + C
(b) Ctrl + D
(c) Alt + ;
(d) Ctrl + ;
9. What is the Shortcut key for
"Current Time" in Excel
(a) Ctrl + Shift + :
(b) Ctrl + T
(c) Ctrl + D
(d) Ctrl + ;
10. What is the shortcut to insert
comment in MS Excel
(a) Ctrl + F6
(b) Alt + F8
(c) Shift + F9
(d) Shift + F2
11. Which function in MS Excel
counts the number of characters in a Cell
(a) Len ( )
(b) Length ( )
(c) Count ( )
(d) LNG ( )
Answer – (d) Len ( )
12. What of these is a shortcut to
add a border to the selected cell in MS Excel
(a) Ctrl + T
(b) Ctrl + B
(c) Shift + B
(d) Ctrl + Shift + &
13. What is the shortcut key of
Hyperlink in Excel
(a) Ctrl + H
(b) Ctrl + K
(c) Alt + S
(d) Alt + K
14. What is the Shortcut key for
select Complete Row
(a) Shift + Space
(b) Ctrl + Space
(c) Alt + Space
(d) None of these
15. What is the Shortcut key for
select Complete Column
(a) Shift + Space
(b) Ctrl + Space
(c) Alt + Space
(d) None of these
16. What is the intersection
of a column and row on worksheet called ?
(a) Row
(b) Column
(c) Cell
(d) Address
17. MS Excel is a -
(a) Word Processing Software
(b) Spreadsheet Program
(c) Presentation Program
(d) None of these
18. The Software which contains rows
and column is called -
(a) Word Processing
(b) Database
(c) Spreadsheet
(d) None of these
19. Formulas in Excel Start with -
(a) +
(b) #
(c) %
(d) =
20. To return the remainder after a
no. is divided by a divisor in Excel
(a) Round ( )
(b) Mod ( )
(c) Fact ( )
(d) None of these
21. Hyperlinks can be
(a) Text
(b) Drawing
(c) Picture
(d) All of the above
22. NOT, AND, OR and XOR are -
(a) Relational Operator
(b) Logical Operators
(c) Arithmetic Operators
(d) None of these
23. The shortcut key to hide entire
column
(a) Ctrl + H
(b) Ctrl + 0
(c) Ctrl + -
(d) None of these
24. Which of the following is
correct -
(a) = power (2^3)
(b) = power (2*3)
(c) = power (2,3)
(d) None of these
25. What is the shortcut key to
insert a new comment in a cell ?
(a) ALT + F2
(b) Ctrl + F2
(c) Shift + F2
(d) None of these
26. What is the shortcut key to
insert new sheet in current workbook ?
(a) Shift + F11
(b) Ctrl + F11
(c) Atl + F11
(d) None of these
27. How many sheets are there, by
default, when we create a new excel file ?
(a) 1
(b) 2
(c) 3
(d) 4
28. Which sign display when formula
error in MS Excel
(a) $
(b) *
(c) #
(d) \
29. What is the Shortcut Key of
"AutoSum"
(a) Ctrl + =
(b) Alt + =
(c) Ctrl + A
(d) Shift + =
30. What is the Shortcut Key for
Insert (Row, Column)
(a) Ctrl + +
(b) Ctrl + C
(c) Ctrl + R
(d) Ctrl + A
31. What is the Shortcut Key for
Delete (Row, Column)
(a) Ctrl + D
(b) Ctrl + R
(c) Ctrl + C
(d) Ctrl + -
32. The Shortcut Key for Hide Rows
(a) Ctrl + 9
(b) Ctrl + S
(c) Ctrl + H
(d) Ctrl + R
33. The Shortcut Key for Hide Columns
(a) Ctrl + H
(b) Ctrl + C
(c) Ctrl + 9
(d) Ctrl + 0
34. The Shortcut Key for Unhide Rows
(a) Ctrl + Shift + (
(b) Ctrl + U
(c) Ctrl + H
(d) Ctrl + R
35. The Shortcut Key for Unhide
Columns
(a) Ctrl + H
(b) Ctrl + K
(c) Ctrl + Shift + )
(d) Ctrl + Z
No comments:
Post a Comment