Home / Programming Questions / Microsoft Excel MCQs / Page 3

Microsoft Excel MCQs with answers Page - 3

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. When a range is selected, how can you activate the previous cell?

(A) Press the Alt key
(B) Press Tab
(C) Press Enter
(D) None of above

M

Mr. Dubey • 51.43K Points
Coach

Q. You can use the formula palette to

(A) Format cells containing numbers
(B) Create and edit formula containing functions
(C) Enter assumptions data
(D) Copy a range of cells

M

Mr. Dubey • 51.43K Points
Coach

Q. VBA in MS-Excel was used from which version

(A) Excel 4
(B) Excel 5
(C) Excel 6
(D) Excel 7

M

Mr. Dubey • 51.43K Points
Coach

Q. What is the default extension of Microsoft Excel 2003 saved file

(A) .xls
(B) .xsl
(C) .xlsx
(D) .xlxs

M

Mr. Dubey • 51.43K Points
Coach

Q. Which of the following is invalid statement?

(A) Sheet tabs can be colored
(B) Some picture can be applied as a background of a sheet
(C) You can set the column width automatically fit the amount of text
(D) The width of a row and be specified manually or fit automatically

M

Mr. Dubey • 51.43K Points
Coach

Q. What is the maximum number of columns supported in a Excel 2007 worksheet

(A) 12,357
(B) 16,384
(C) 21,783
(D) 26,263

M

Mr. Dubey • 51.43K Points
Coach

Q. What is the maximum number of rows supported in a Excel 2007 worksheet

(A) 65,357
(B) 78,487
(C) 1,028,176
(D) 1,048,576

M

Mr. Dubey • 51.43K Points
Coach

Q. The intersection of rows and columns are called

(A) Sheet
(B) Cell
(C) Workbook
(D) None of the above

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.