Microsoft Excel
1. What is the extension of files created in MS-Excel 97-2003?
a. .xlx
b. .msx
c. .Dot
d. .xls ✅
2. What is the 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 MS Excel is used to calculate the sum of numbers?
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 ( )
12. What 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 to select complete row?
a. Shift + Space ✅
b. Ctrl + Space
c. Alt + Space
d. None of these
15. What is the shortcut key to 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 a 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 columns 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 number 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 a new sheet in the current workbook?
a. Shift + F11 ✅
b. Ctrl + F11
c. Alt + 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 is displayed when a formula error occurs 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 + – ✅
b. Ctrl + R
c. Ctrl + C
d. Ctrl + D
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
36. What is the extension file for Excel 2004?
A) .xls ✅
B) .excel
C) .xcel
D) .xcl
37. What is the extension file for Excel 2007 and above?
A) .xls
B) .excel
C) .xlsx ✅
D) .xcl
38. Worksheet is also called an array of _____.
A) Column
B) Cells ✅
C) Box
D) Formula
39. How are cells named in MS Excel?
A) Alphabetically
B) Numerically
C) Alphanumerically ✅
D) Special Character
40. What is the maximum limit of rows in MS Excel 2010?
A) 1084567
B) 1048567
C) 1048576 ✅
D) 1084576
41. What is the maximum limit of columns in MS Excel 2010?
A) 16384 ✅
B) 16438
C) 16843
D) 16348
42. Which bar lies at the top of the window in Excel?
A) Status Bar
B) Ruler
C) Title Bar ✅
D) Scroll Bar
43. How are rows numbered in MS Excel?
A) Alphabetically
B) Numerically ✅
C) Alphanumerically
D) Special characters
44. How are columns named in MS Excel?
A) Alphabetically ✅
B) Numerically
C) Alphanumerically
D) Special characters
45. Which tab is used to include pivot tables, charts, and hyperlinks in a spreadsheet?
A) Insert ✅
B) Page Layout
C) Data
D) Review
46. Which tab in Excel is used for importing, querying, outlining, and subtotaling data in a worksheet’s data list?
A) Formula
B) Data ✅
C) Review
D) Insert
47. Which tab in Excel is used for proofing, protecting, and marking up a spreadsheet?
A) Formula
B) Data
C) Review ✅
D) View
48. Which tool in MS Office is best for organizing data and making lists?
A) Access
B) Excel ✅
C) PowerPoint
D) Word
49. What is the file extension of Excel 2010?
A) .xls
B) .xlsb
C) .xlsm
D) .xlsx ✅
50. How is a single element in a worksheet known in Excel?
A) Cell ✅
B) Column
C) Range
D) Row
51. What do you mean by A3, B13:B20, C7 reference in Excel?
A) Range ✅
B) Union
C) Formula
D) General
52. Which type of key should be combined with the Ctrl key to create a macro key in Excel?
A) Numeric
B) Alphabetic ✅
C) Alphanumeric
D) Special characters
53. Which bar is used to display sheet information and the insertion point location in MS Excel?
A) Ruler
B) Scroll Bar
C) Status Bar ✅
D) Title Bar
54. Which tab is used to change the display of worksheet area and the data it contains?
A) Page Layout
B) Data
C) Review
D) View ✅
55. Which view in Excel displays the pages exactly as they appear when printed?
A) Custom View
B) Full screen View
C) Page Break View
D) Page Layout View ✅
56. Which tab is used for creating, formatting, and editing a spreadsheet?
A) Data
B) Home ✅
C) Insert
D) Review
57. Which function is used to count the number of cells that contain numbers, in a range?
A) Count() ✅
B) Countif()
C) Sum()
D) Sumif()
58. Which function is used to add the values in a range?
A) Count()
B) Sum() ✅
C) ABS()
D) Sumif()
59. Which symbol is used to execute formulas in MS Excel?
A) = ✅
B) ‘
C) #
D) “
60. Where does the result display when a formula is entered in Excel?
A) Current Cell ✅
B) Next Cell
C) Previous Cell
D) Formula Bar
61. Which function in Excel is used to find the biggest value in a range?
A) Ceiling
B) DMAX
C) LEN
D) MAX ✅
62. Which one of the following is a text function in MS Excel?
A) MID() ✅
B) NOW()
C) COUNT()
D) SIGN
63. Which one of the following is a ‘Date & Time’ function in Excel?
A) FIND()
B) MOD()
C) NOW() ✅
D) MID()
64. Which function is used to find the middle number in a range?
A) MEDIAN() ✅
B) MID()
C) TRIM()
D) MODE()
65. What is the purpose of the ‘Tab’ key in MS Excel?
A) Moves cell pointer to the previous column
B) Moves cell pointer to the next column ✅
C) Moves cell pointer to the previous row
D) Moves cell pointer to the next row
66. What is the purpose of the ‘Enter Key’ in MS Excel?
A) Moves cell pointer to the previous column
B) Moves cell pointer to the next column
C) Moves cell pointer to the previous row
D) Moves cell pointer to the next row ✅
67. Which function key is used to open the ‘Go To’ dialogue box in MS Excel?
A) F2
B) F5 ✅
C) F7
D) F11
68. Which option in MS Excel is used to display the rows that meet certain conditions?
A) Find
B) Filter ✅
C) Format
D) Sort
69. Which option in Excel is used to rearrange the rows based on the content of a particular column?
A) Find
B) Filter
C) Sort ✅
D) Format
70. Microsoft Excel is a powerful ____
A) Word processing package
B) Spreadsheet package ✅
C) Communication software package
D) DBMS Package
71. Which one of the following is a ‘no argument’ function?
A) Now() ✅
B) Lower()
C) Max()
D) IF()
72. Which key is used to move the insertion point to the beginning of the current sheet?
A) Page Up
B) Home
C) Ctrl + Page Up
D) Ctrl + Home ✅
73. The intersection of a row and column in MS Excel is called _______.
A) Spreadsheet
B) Workbook
C) Document
D) Cell ✅
