# MS Excel Questions and Answers Objective

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?

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

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

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
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?

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

2. Excel
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