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

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

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

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

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

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

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

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

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

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

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.