mcqs bucket

  • Excel Mcqs Questions | MCQs Bucket Largest Mcqs Website

    mcqsbucket

      Best guide for exams of all nature, Competitive exams and Interviews
Here is the MCQs guide for the topic of Excel. you will find various types of questions along with there answers in this
Q. In Excel worksheet contains columns
A.
255
B.
256
C.
257
D.
258


Show Answer
Q. A Worksheet is made of
A.
Rows ans Columns
B.
Rows Only
C.
Columns only
D.
none


Show Answer
Q. In Excel which key is used for format number in time format?
A.
Ctrl+Shift+6
B.
Ctrl+Shift+3
C.
Ctrl+Shift+5
D.
Ctrl+Shift+2


Show Answer
Q. In Excel which key is used for format number in scientific format?
A.
Ctrl+Shift+6
B.
Ctrl+Shift+3
C.
Ctrl+Shift+5
D.
Ctrl+Shift+4


Show Answer
Q. In Excel which key is used for format number in percentage format?
A.
Ctrl+Shift+6
B.
Ctrl+Shift+3
C.
Ctrl+Shift+5
D.
Ctrl+1


Show Answer
Q. In Excel which key is used for format number in date format?
A.
Ctrl+Shift+6
B.
Ctrl+Shift+4
C.
Ctrl+Shift+3
D.
Shift+1


Show Answer
Q. In Excel which key is used for format number in currency format?
A.
Ctrl+Shift+1
B.
Ctrl+Shift+4
C.
Ctrl+1
D.
Shift+1


Show Answer
Q. In Excel which key is used for format number in comma format?
A.
Ctrl+Shift+1
B.
Ctrl+Shift+4
C.
Ctrl+1
D.
Shift+1


Show Answer
Q. In Excel which key is used for create a formula to sum all of the above cells?
A.
Ctrl+=
B.
Alt+-
C.
Alt+=
D.
Ctrl+-


Show Answer
Q. 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


Show Answer