1.) "OR" is a type of __________
a) Financial function
b) Text function
c) Logical function
d) Date & Time function
Ans . c) Logical function
2.) Choose a TEXT Function from below options :
a) VLOOKUP
b) CONCATENATE
c) SUM
d) PMT
Ans . b) CONCATENATE
3.) Which shortcut key is use to save Excel workbook :
a) Ctrl + A
b) Ctrl + B
c) Ctrl + O
d) Ctrl + S
Ans. d) Ctrl + S
4.) Which shortcut key is use to go to Previous workbook :
a) Ctrl + Shift + Tab
b) Tab + Shift + Ctrl
c) Alt + Tab + Shift
d) Tab + Ctrl +Shift
Ans. a) Ctrl + Shift + Tab
5.) Which shortcut key is use to close current workbook :
a) Ctrl + F4
b) Alt + F1
c) Alt + F4
d) Ctrl + F1
Ans. a) Ctrl + F4
6.) Which shortcut key is use to close current workbook :
a) Ctrl + F4
b) Alt + F4
c) Shift + F4
d) Ctrl + F1
Ans. b) Alt + F4
7.) Which shortcut key is use to apply time format :
a) Ctrl + Shift + !
b) Ctrl + Shift + ~
c) Ctrl + Shift + ^
d) Ctrl + Shift + @
Ans. d) Ctrl + Shift + @
8.) The intersection of a column and a row in MS Excel worksheet in known as a ________
a) Cell
b) Row
c) Column
d) None of the above
Ans. a) Cell
9.) Every formula in MS Excel starts with the _______ sign
a) "-"
b) "@"
c) "+"
d) "="
Ans. d) "="
10.) "INFO " is a of __________
a) Financial function
b) Information function
c) Logical function
d) Statistical function
Ans. b) Information function
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
0 Comments