MS-excel mcq questions and answers pdf

MS-excel MCQ questions and answers pdf contains the 100 multiple choice questions about MCQ of excel with the answer key.

The Spreadsheets (MS-excel) chapter is most important for the PSC computer exam. The public service commission (Lok Sewa Aayog) is asking up to 10 questions from the electronics spreadsheet- MCQ of excel in the computer operator exam.

What is electronics spreadsheet?

An electronic spreadsheet is an electronic version of the accountant's traditional paper spreadsheet, which stores numeric data in two-dimensional tables. There are so many electronic spreadsheets available on the internet, Microsoft excel is one of the best which comes in an office package.

In the ms excel MCQ questions and answers pdf chapter, we have to read the basic functions of Microsoft excel, command, operation, simple calculation, shortcut keys, different charts and graphs, pivot table, result sheet preparation, etc. MCQ of excel gives the concept about, excel program, shortcut keys, formula, function, etc.

How to read ms excel MCQ questions and answers pdf?

For preparing an MS-excel MCQ, you also need to have theoretical knowledge about it. Before reading this MCQ of excel, you should have read related theories in the book you have.

Print these Microsoft excel MCQs as possible and make a hard copy note. Read the whole note once. And when you read it for the second time, take the highlighter and highlight the questions that are difficult to remember. Highlight the full questions that are difficult to remember even after reading MCQ of excel for the third time.

201) Which of the following format you can decide to apply or not in AutoFormat dialog box?

a) Number format

b) Border format

c) Font format

d) All of above

202) How can you remove borders applied in cells?

a) Choose None on Border tab of Format cells

b) Open the list on Border tool in Formatting toolbar then choose the first tool (no border)

c) Both of above

d) None of above

203) Where can you set the shedding color for a range of cells in Excel?

a) Choose required color form Patterns tab of Format Cells dialog box

b) Choose required color on Fill Color tool in the Formatting toolbar

c) Choose required color on Fill Color tool in Drawing toolbar

d) All of above

204) You can set Page Border in Excel from

a) From Border tab in Format Cells dialog box

b) From the Border tool in the Formatting toolbar

c) From the Line Style tool in the Drawing toolbar

d) You cannot set page border in Excel

205) 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 numbers between 0 and 100 then click Red color on the Text Color tool

d) All of above

Please download ms excel MCQ questions and answers pdf from here. We have published various MCQ online computer quizzes and mcq of excel question papers with answer pdf. Hope you all like it. If there is a mistake in any of the questions, please let us know by commenting on this post. Thanks!