MS Excel Question Bank Page No. 1

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