MS Excel Questions and Answers Objective questions. This practice set contains 40 most important questions and answer in MCQ objective form. Microsoft Excel is much needed skill in private and Government office jobs. MS Excel is a spreadsheet program for computation. It is a part of basic computer course for basic computer knowledge and awareness.

## MS Excel Objective Questions and Answers

The answer sheet of Excel questions is provided at the end of this post.

**Q1. Which of the following is a popular DOS based spreadsheet package?**

- Word
- Smart cell
- Excel
- Lotus 1-2-3

**Q2. The value of the Excel expression =Left (“MICROSOFT EXCEL”,10) is?**

- OSOFT EXCEL
- MICROSOFT E
- MICROSOFT
- SOFT EXCEL

**Q3. What will be the value of Excel expression = ROUND (20.945,2)?**

- 20
- 20.95
- 20.94
- 20.90

**Q4. Which of the following is the correct arrangement in the descending order of their sizes?**

- Worksheet, Workbook, Range, Cell
- Workbook, Worksheet, Range, Cell
- Workbook, Range, Cell, Worksheet
- Worksheet, Range, Cell, Worksheet

**Q5. Which of the following Excel functions change TRUE to FALSE and vice-versa?**

- AND
- OR
- NOT
- IF

**Q6. What is the correct result of this expression = LEN (“123456”) ?**

- 11
- 6
- 0
- 13

**Q7. The value of the Excel expression = SUM (5, 5 , TRUE, FALSE, TRUE, FALSE) is?**

- 10
- 11
- 12
- 13

**Q8. What is the correct result of =UPPER (Microsoft)?**

- MICROSOFT
- microsoft
- MICRO SOFT
- MicroSoft

**Q9. Which of the following Excel functions return FALSE if all its arguments are FALSE and returns TRUE otherwise?**

- AND
- OR
- NOT
- IF

**Q10. Which of the following symbol are commonly known as wildcard in Excel?**

- #, !
- , !
- *, ?
- @, %

**Q11. The cell reference for the range from A12 to E22 is?**

- A12, E22
- A12 : E22
- A12 – E22
- A12; E22

**Q12. How many sheets should a workbook contain?**

- 1
- 2
- 3
- 4

**Q13. Which of the following formulas is not entered correctly?**

- =10+15
- =B4+D4
- 10*20
- =F5+G5

**Q14. In a worksheet you can select?**

- Cell
- Row
- Column
- Worksheet

**Q15. Which of the following is the latest version of Excel?**

- $
- =
- *
- @

**Q16. What is the correct result of =ABS (-45)?**

- +90
- +45
- 45
- -20

**Q17. Which of the following methods cannot be used to enter data in a cell?**

- Pressing an arrow key
- Pressing the Tab key
- Pressing the Esc key
- Clicking on the formula bar

**Q18. An excel workbook is a collection of?**

- Workbooks
- Worksheets
- Charts
- Worksheets and charts

**Q19. Keyboard shortcut to select the entire worksheet is?**

- Ctrl + A
- Ctrl + W
- Ctrl + U
- Ctrl + S

**Q20. Excel files have a default extension of?**

- Xls
- Xlw
- Wkx
- Xcl

**Q21. Which of the following can be a hyperlink?**

- Text
- Drawing objects
- Character
- All of the above

**Q22. Which of the following is not a basic step in creating a worksheet?**

- Save workbook
- Modifiy the worksheet
- Enter text and data
- Copy the worksheet

**Q23. Which area in an excel window allows entering values and formulas?**

- Formula Bar
- Title Bar
- Status Bar
- Menu Bar

**Q24. Which functionin Excel tells how many numeric entries are there?**

- SUM
- COUNT
- NUM
- CHKNUM

**Q25. In which can a balance sheet best be prepared?**

- MS Word
- MS Power Point
- MS Excel
- MS Outlook

**Q26. Which one is not a Function in MS Excel?**

- SUM
- AVG
- MIN
- MAX

**Q27. What is the correct result of this formula =14*2+10/5 ?**

- 28
- 31
- 30
- 61

**Q28. Which of the following is a formula that combines the text of different cells?**

- PROPER
- TRIM
- TEXTADD
- CONCATENATE

**Q29. What is the correct result of this formula =ISEVEN(40)?**

- Error
- True
- False
- Fourty

**Q30. Which of the following is not a text function of MS Excel?**

- MID
- RIGHT
- COMBIN
- LEFT

**Q31. Which of the following functions in MS Excel counts the cells in a range that are not empty?**

- COUNTIF
- COUNTBLANK
- COUNTA
- COUNT

**Q32. Which of the following function keys can be used to edit a cell in an MS-Excel worksheet?**

- F1
- F2
- F3
- F4

**Q33. =Round(2.15,1) will be the result if it is entered in a cell?**

- 2
- 2.1
- 2.2
- 3

**Q34. Which menu is used to change the format of a cell in Excel?**

- Format menu
- Data menu
- Tool menu
- Insert menu

**Q35. Statistical calculations and preparation of tables and graphs can be done using?**

- Adobe Photoshop
- Excel
- Notepad
- Power Point

**Q36. The basic unit of a worksheet into which you enter data in Excel is called?**

- Cell
- Table
- Box
- Column

**Q37. How many sheets are there, by default, when we create a new Excel file?**

- 1
- 2
- 3
- 4

**Q38. In Excel, which one denoted a range from B1 through E5**

- B1 – E5
- B1:E5
- B1 to E5
- B1$E5

**Q39. How will you graphically represent expenditure in different departments?**

- Column Chart
- Line Chart
- Pie Chart
- Dot Chart

**Q40. What do you use to create a chart?**

- Pie Wizard
- Excel Wizard
- Data Wizard
- Chart Wizard

**Answer Sheet** – MS Excel Questions and Answers Objective

Q1. | Ans 4 | Q11. | Ans 2 | Q21. | Ans 4 | Q31. | Ans 3 |

Q2. | Ans 3 | Q12. | Ans 1 | Q22. | Ans 4 | Q32. | Ans 2 |

Q3. | Ans 2 | Q13. | Ans 3 | Q23. | Ans 1 | Q33. | Ans 3 |

Q4. | Ans 2 | Q14. | Ans 2 | Q24. | Ans 2 | Q34. | Ans 1 |

Q5. | Ans 3 | Q15. | Ans 2 | Q25. | Ans 3 | Q35. | Ans 2 |

Q6. | Ans 2 | Q16. | Ans 3 | Q26. | Ans 2 | Q36. | Ans 1 |

Q7. | Ans 3 | Q17. | Ans 4 | Q27. | Ans 3 | Q37. | Ans 3 |

Q8. | Ans 1 | Q18. | Ans 4 | Q28. | Ans 4 | Q38. | Ans 2 |

Q9. | Ans 2 | Q19. | Ans 1 | Q29. | Ans 2 | Q39. | Ans 3 |

Q10. | Ans 3 | Q20. | Ans 1 | Q30. | Ans 3 | Q40. | Ans 4 |

Thanks for read MS Excel Objective Questions and Answers in English.