Microsoft Excel (MS Excel) Multiple Choice Questions (MCQs)

We have compiled a list of 100+ questions with answers from Microsoft Excel (MS Excel) that help you to check your basic knowledge of MS Excel and prepare for competitive exams. These Microsoft excel multiple choice questions with answers are prepared by the subject experts from authentic resources. Attempt all the questions and check your MS Excel knowledge online.

This category includes the topics such as concept of electronic spreadsheets, types, organization of spreadsheet applications, cells, rows, columns, worksheets, workbooks and workspaces, creating opening and saving workbooks, screen elements, editing copying moving and delete cell contents, cell formatting, using formulas, relative absolute and mixed cell references, basic functions, generating series, default options, sorting filtering data, summarizing and sub totals, charts, header footer, speller, customizing menu and toolbar, import export data, pivot table, goal seek, scenario and audit, page setting, preview and printing.

Following are the important multiple choice questions with answers from the Microsoft Excel (MS Excel) section. You can choose the correct answer from option A, B, C and D.

MS Excel MCQs Practice MCQ Question and Answer

181
By default the cell pointer moves down when you press Enter. From where can you change this setting?


182
You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?


183
Which of the following is not What IF analysis tool in Excel?


184
To apply Goal Seek command your cell pointer must be in


185
Which of the following tool you will use in Excel to see what must be the value of a cell to get required result?


186
Excel is a good application for What IF analysis. Which of the following tool help you for this?


187
Which of the following options is not available to remove arrows of Formula Auditing?


188
The arrows created by Auditing can be removed by


189
Which of the following is invalid regarding the Protection in Excel?


190
It is acceptable to let long text flow into adjacent cells on a worksheet when


191
Which command will you choose to convert a column of data into row?


192
Which of the following option is not available in Paste Special dialog box?


193
What happens when you press Ctrl + X after selecting some cells in Excel?


194
Which of the following Excel screen components can NOT be turned on or off?


195
How can you show or hide the gridlines in Excel Worksheet?


196
Where can you change automatic or manual calculation mode in Excel?


197
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?


198
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?


199
You can merge the main document with data source in Excel. In mail merge operation, Word is usually


200
Which of the following is not the correct method of editing the cell content?


201
Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook?


202
The Name box on to the left of formula bar


203
Tab scroll buttons are place on Excel screen


204
Which tool you will use to join some cells and place the content at the middle of joined cell?


205
When a range is selected, how can you activate the previous cell?


206
You can use the formula palette to


207
You can use the format painter multiple times before you turn it off by


208
Excel files have a default extension of


209
An excel workbook is a collection of


210
Which of the following is a popular DOS based spreadsheet package?