Microsoft Excel MCQ - Multiple Choice Question and Answer

Microsoft Excel MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Question No : 8
Which of the following is invalid statement?

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

Question No : 9
You can use the formula pallette to

format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells

Question No : 10
When a range is selected, how can you activate the previous cell?

Press the Alt key
Press Tab
Press Enter
None of above

Question No : 11
Which tool you will use to join some cells and place the content at the middle of joined cell?

From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar

Question No : 12
Tab scroll buttons are place on Excel screen

towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner

Question No : 13
The Name box on to the left of formula bar

shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above

Question No : 14
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

work sheet
chart sheet
module sheet
data sheet