Jan
09
Which function is used to enter current time in a worksheet cell?
A. =today()
B. =now()
C. =time()
D. =currentTime()
Category: Ms Excel Mcqs
Ms Excel Mcqs
Apr
13
You need to jump to next column breaking current column right at the cursor position, How can you break column ?
A. Pressing Ctrl + Enter
B. Pressing Alt + Shift + Enter
C. Break command from insert menu
D. Both B & C
Mar
31
In Excel which key is used to open the excel formula window ?
A. Shift+F6
B. Shift+F3
C. Alt+Shift+F3
D. Alt+Shift+F6
Mar
31
In Excel, Shortcut key used for format number in currency format ?
A. Ctrl+Shift+1
B. Ctrl+Shift+4
C. Ctrl+1
D. Shift+1
Mar
31
In Excel, shortcut key used for format number in comma format ?
A. Ctrl+Shift+1
B. Ctrl+Shift+4
C. Ctrl+1
D. Shift+1
Mar
31
In Excel, Shortcut key used for format number in time format ?
A. Ctrl+Shift+6
B. Ctrl+Shift+3
C. Ctrl+Shift+5
D. Ctrl+Shift+2
Mar
31
In Excel, Shortcut key used for format number in scientific format ?
A. Ctrl+Shift+6
B. Ctrl+Shift+3
C. Ctrl+Shift+5
D. Ctrl+Shift+4
Mar
31
In MS Excel, shortcut key used for format number in percentage format ?
A. Ctrl + Shift + 6
B. Ctrl + Shift + 3
C. Ctrl + Shift + 5
D. Ctrl + 1