MS Excel Questions and Answers Objective

MS Excel Questions and Answers Objective contains 40 most important questions and answer in MCQ objective form. MS Excel is much needed skill in private and Government jobs. MS Excel is basic computer knowledge that everyone should have.

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

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

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

  1. OSOFT EXCEL
  2. MICROSOFT E
  3. MICROSOFT
  4. SOFT EXCEL

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

  1. 20
  2. 20.95
  3. 20.94
  4. 20.90

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

  1. Worksheet, Workbook, Range, Cell
  2. Workbook, Worksheet, Range, Cell
  3. Workbook, Range, Cell, Worksheet
  4. Worksheet, Range, Cell, Worksheet

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

  1. AND
  2. OR
  3. NOT
  4. IF

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

  1. 11
  2. 6
  3. 0
  4. 13

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

  1. 10
  2. 11
  3. 12
  4. 13

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

  1. MICROSOFT
  2. microsoft
  3. MICRO SOFT
  4. MicroSoft

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

  1. AND
  2. OR
  3. NOT
  4. IF

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

  1. #, !
  2. , !
  3. *, ?
  4. @, %

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

  1. A12, E22
  2. A12 : E22
  3. A12 – E22
  4. A12; E22

Q12. How many sheets should a workbook contain?

  1. 1
  2. 2
  3. 3
  4. 4

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

  1. =10+15
  2. =B4+D4
  3. 10*20
  4. =F5+G5

Q14. In a worksheet you can select?

  1. Cell
  2. Row
  3. Column
  4. Worksheet

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

  1. $
  2. =
  3. *
  4. @

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

  1. +90
  2. +45
  3. 45
  4. -20

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

  1. Pressing an arrow key
  2. Pressing the Tab key
  3. Pressing the Esc key
  4. Clicking on the formula bar

Q18. An excel workbook is a collection of?

  1. Workbooks
  2. Worksheets
  3. Charts
  4. Worksheets and charts

Q19. Keyboard shortcut to select the entire worksheet is?

  1. Ctrl + A
  2. Ctrl + W
  3. Ctrl + U
  4. Ctrl + S

Q20. Excel files have a default extension of?

  1. Xls
  2. Xlw
  3. Wkx
  4. Xcl

Q21. Which of the following can be a hyperlink?

  1. Text
  2. Drawing objects
  3. Character
  4. All of the above

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

  1. Save workbook
  2. Modifiy the worksheet
  3. Enter text and data
  4. Copy the worksheet

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

  1. Formula Bar
  2. Title Bar
  3. Status Bar
  4. Menu Bar

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

  1. SUM
  2. COUNT
  3. NUM
  4. CHKNUM

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

  1. MS Word
  2. MS Power Point
  3. MS Excel
  4. MS Outlook

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

  1. SUM
  2. AVG
  3. MIN
  4. MAX

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

  1. 28
  2. 31
  3. 30
  4. 61

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

  1. PROPER
  2. TRIM
  3. TEXTADD
  4. CONCATENATE

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

  1. Error
  2. True
  3. False
  4. Fourty

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

  1. MID
  2. RIGHT
  3. COMBIN
  4. LEFT

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

  1. COUNTIF
  2. COUNTBLANK
  3. COUNTA
  4. COUNT

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

  1. F1
  2. F2
  3. F3
  4. F4

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

  1. 2    
  2. 2.1
  3. 2.2
  4. 3

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

  1. Format menu
  2. Data menu
  3. Tool menu
  4. Insert menu

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

  1. Adobe Photoshop
  2. Excel
  3. Notepad
  4. Power Point

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

  1. Cell
  2. Table
  3. Box
  4. Column

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

  1. 1
  2. 2
  3. 3
  4. 4

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

  1. B1 – E5
  2. B1:E5
  3. B1 to E5
  4. B1$E5

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

  1. Column Chart
  2. Line Chart
  3. Pie Chart
  4. Dot Chart

Q40. What do you use to create a chart?

  1. Pie Wizard
  2. Excel Wizard
  3. Data Wizard
  4. Chart Wizard

Answer Sheet – MS Excel Questions and Answers Objective

Q1.Ans 4Q11.Ans 2Q21.Ans 4Q31.Ans 3
Q2.Ans 3Q12.Ans 1Q22.Ans 4Q32.Ans 2
Q3.Ans 2Q13.Ans 3Q23.Ans 1Q33.Ans 3
Q4.Ans 2Q14.Ans 2Q24.Ans 2Q34.Ans 1
Q5.Ans 3Q15.Ans 2Q25.Ans 3Q35.Ans 2
Q6.Ans 2Q16.Ans 3Q26.Ans 2Q36.Ans 1
Q7.Ans 3Q17.Ans 4Q27.Ans 3Q37.Ans 3
Q8.Ans 1Q18.Ans 4Q28.Ans 4Q38.Ans 2
Q9.Ans 2Q19.Ans 1Q29.Ans 2Q39.Ans 3
Q10.Ans 3Q20.Ans 1Q30.Ans 3Q40.Ans 4

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