•   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. You can set page border in excel from: __________?
A.
From Border tab in Format Cells dialog box
B.
From Border tool in Formatting toolbar
C.
From Line Style tool in Drawing toolbar
D.
You can not set page border in Excel


Show Answer
Q. Excel displays the current cells address in the __________?
A.
Formula bar
B.
Status bar
C.
Name box
D.
Title bar


Show Answer
Q. In MS Excel, Conditional Formatting is in ______ tab?
A.
Home
B.
View
C.
Page Layout
D.
Insert


Show Answer
Q. You can edit existing Excel data by pressing the:________ key?
A.
F1 Key
B.
F2 Key
C.
F3 Key
D.
F4 Key


Show Answer
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
Advertisment