Home / Programming Questions / Microsoft Excel MCQs / Page 2

Microsoft Excel MCQs with answers Page - 2

Dear candidates you will find MCQ questions of Microsoft Excel here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

M

Mr. Dubey • 51.43K Points
Coach

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

M

Mr. Dubey • 51.43K Points
Coach

Q. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

(A) Use =if() function to format the required numbers red
(B) Apply Conditional Formatting command on Format menu
(C) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
(D) All of above

M

Mr. Dubey • 51.43K Points
Coach

Q. Which command need to execute from "run window" to open a new excel file

(A) ms excel
(B) win excel
(C) office excel
(D) excel

M

Mr. Dubey • 51.43K Points
Coach

Q. If "A1" is displayed in Name Box, then is indicates which one

(A) First column (by A) and first row (by 1)
(B) First column (by 1) and first row (by A)
(C) First sheet
(D) None of the above

M

Mr. Dubey • 51.43K Points
Coach

Q. All formulas in MS Excel is start with _______ sign

(A) $
(B) =
(C) ()
(D) !

M

Mr. Dubey • 51.43K Points
Coach

Q. Which function key generates a bar graph from the values entered in excel

(A) F9
(B) F10
(C) F11
(D) F12

M

Mr. Dubey • 51.43K Points
Coach

Q. Total number of characters that a cell can contain

(A) 24,221
(B) 27,685
(C) 32,767
(D) 39,802

M

Mr. Dubey • 51.43K Points
Coach

Q. You can check the conditions against __________ when applying conditional formatting

(A) Cell value
(B) Formula
(C) Both of above
(D) None of above

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.