Q11. Which bar lies top of the window in Excel screen?
a) Status Bar
b) Ruler
c) Title Bar
d) Scroll Bar
Answer – [C]
Q12. Formula in Excel start with …….
a) #
b) %
c) =
d) +
Answer – [C]
Q13. Excel displays the current cell address in the ……..
a) Status Bar
b) Name Box
c) Formula Bar
d) None of the above
Answer – [B]
Q14. What is the shortcut key to insert current Date in a cell?
a) Ctrl + ;
b) Ctrl + T
c) Ctrl + D
d) Ctrl + ‘
Answer – [A]
Q15. To remove the content of selected cells you must issue ……. command.
a) Delete
b) Clear Contents
c) Clear All
d) Clear Delete
Answer – [B]
Q16. MS-Excel provides the default value for step in Fill Series dialog box
a) 0
b) 1
c) 5
d) 10
Answer – [B]
Q17. Which language is used to create macros in Excel?
a) Visual Basic
b) C
c) Visual C++
d) Java
Answer – [A]
Q18. A typical worksheet has ………. number of columns.
a) 128
b) 256
c) 1024
d) 16384
Answer – [D]
Q19. How many characters can be typed in a single cell in Excel?
a) 256
b) 1024
c) 32767
d) 65535
Answer – [D]
Q20. A worksheet can have a maximum of ………… number of rows.
a) 256
b) 1024
c) 65535
d) 1048576
Answer – [D]