1000+ Microsoft Excel Multiple Choice Question Answer [Solved]

1. Where can you set the shading 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 Formatting toolbar
C. Choose required color on Fill Color tool in Drawing toolbar
D. All of above
Answer : D

2. Which tool you will use to join some cells and place the content at the middle of joined cell?
A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
Answer : D

3. A __________ is a grid with labeled columns and rows.
A. Dialog box
B. Worksheet
C. Clipboard
D. Toolbar
Answer : B

4. Which of the cell pointer indicate that you can move the content to other cell?
A. Doctors symbol (Big Plus)
B. small thin plus icon
C. Mouse Pointer with anchor at the tip
D. None of above
Answer : C

5. Which of the following is the oldest spreadsheet package?
A. VisiCalc
B. Lotus 1-2-3
C. Excel
D. StarCalc
Answer : C

6. Which menu option can be sued to split windows into two
A. Format > window
B. View > window > split
C. Window > split
D. View > split
Answer : C

7. What is represented by the small, black square in the lower-right corner of an active cell or range?
A. Copy handle
B. Fill handle
C. Insert handle
D. Border
Answer : B

8. Multiple calculations can be made in a single formula using .......
A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula
Answer : B

9. Right clicking something in Excel:
A. Deletes the object
B. Nothing the right mouse button is there for left handed people
C. Opens a shortcut menu listing everything you can do to the object
D. Selects the object
Answer : C

10. Which of the following methods cannot be used to enter data in a cell
A. Pressing an arrow key
B. Pressing the Tab key
C. Pressing the Esc key
D. Clicking on the formula bar
Answer : C

11. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
Answer : A

12. Which elements of worksheet can be protected from accidental modification
A. Contents
B. Objects
C. Scenarios
D. All of above
Answer : D

13. 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?
A. Custom List
B. Auto Fill Options
C. Fill Across Worksheet
D. Fill Series
Answer : A

14. How do you wrap the text in a cell?
A. Format, cells, font
B. Format, cells, protection
C. Format, cells, number
D. Format, cells, alignment
Answer : D

15. When you copy a formula
A. Excel erases the original copy of the formula
B. Excel edits cell references in the newly copied formula
C. Excel adjusts absolute cell references
D. Excel doesnt adjust relative cell references
Answer : B

16. Which of the following formulas is not entered correctly?
A. =10+50
B. 10+50
C. =10+50
D. =B7+14
Answer : B

17. A numeric value can be treated as a label value if it precedes with
A. Apostrophe (&lsquo
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&
Answer : A

18. Which of the following is not a worksheet design criterion?
A. Efficiency
B. Aditibility
C. Description
D. Clarity
Answer : C

19. Getting data from a cell located in a different sheet is called ......
A. Accessing
B. Referencing
C. Updating
D. Functioning
Answer : B

20. Which of the following methods can not be used to edit the contents of a cell?
A. Press the Alt key
B. Clicking the formula bar
C. Pressing the F2 key
D. Double clicking the cell
Answer : A

21. To save a workbook, you:
A. Click the save button on the standard toolbar from the menu
B. Press Ctrl+F5
C. Click Save on the Windows Start button
D. Select Edit>Save
Answer : A

22. Which of the following is not an example of a value?
A. 350
B. May 10, 2001
C. 0.57
D. Serial Number 50771
Answer : D

23. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time
Answer : B

24. What does COUNTA () function do?
A. counts cells having alphabets
B. counts empty cells
C. counts cells having number
D. counts non-empty cells
Answer : D

25. Which of the following is not true about Find and Replace in Excel
A. You can search for bold and replace with italics
B. You can decide whether to look for the whole word or not
C. You can search in formula too
D. You can search by rows or columns or sheets
Answer : D

26. Which button do you click to add up a series of numbers?
A. The autosum button
B. The Formula button
C. The quicktotal button
D. The total button
Answer : A

27. How can you show or hide the gridlines in Excel Worksheet?
A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above
Answer : C

28. Which is not the function of Edit, Clear command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats
Answer : C

29. How can you print three copies of a workbook?
A. Select File > Properties form the menu and type 3 in the Copies to print text box
B. Select File > Print from the menu and type 3 in the Number of copies text box
C. Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
D. Press Ctrl+P+3
Answer : B

30. The chart wizard term data series refers to
A. A chart legend
B. A collection of chart data markers
C. A set of values you plot in a chart
D. A data label
Answer : B

31. When a range is selected, how can you activate the previous cell?
A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
Answer : D

32. Tab scrolling button
A. Allow you to view a different worksheet
B. Allow you to view additional worksheet rows down
C. Allow you to view additional worksheet columns to the right
D. Allow you to view additional sheets tabs
Answer : D

33. 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 number between 0 and 100 then click Red color on Text Color tool
D. All of above
Answer : B

34. Which is used to perform what if analysis?
A. Solver
B. Goal seek
C. Scenario Manager
D. All of above
Answer : D

35. Which of the following options is not located in the Page Setup dialog box?
A. Page Break Preview
B. Page Orientation
C. Margins
D. Headers and Footers
Answer : A

36. Which of the following is not information you can specify using the solver?
A. Input cells
B. Constraints
C. Target cell
D. Changing cells
Answer : A

37. 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
Answer : D

38. Which of the following is not a way to complete a cell entry?
A. Pressing enter
B. Pressing any arrow key on the keyboard
C. Clicking the Enter button on the Formula bar
D. Pressing spacebar
Answer : D

39. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A. Right click on Sheet Tab of third sheet and choose Delete from the context menu
B. Click on Sheet 3 and from Edit menu choose Delete
C. Both of above
D. None of above
Answer : A

40. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
A. Square
B. Percentage
C. Goal Seek
D. Divide
Answer : D

41. MS Excel provides the default value for step in Fill Series dialog box
A. 0
B. 1
C. 5
D. 10
Answer : B

42. Which symbol must all formula begin with?
A. =
B. +
C. (
D. @
Answer : A

43. What is the correct way to refer the cell A10 on sheet3 from sheet1?
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10
Answer : A

44. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format
Answer : C

45. Which of following is Not one of Excels what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
nswer : D

46. Excel files have a default extension of
A. Xls
B. Xlw
C. Wk1
D. 123
Answer : A

47. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart
Answer : C

48. To view a cell comment
A. click the edit comment command on the insert menu
B. click the display comment command on the window menu
C. position the mouse pointer over the cell
D. click the comment command on the view menu
Answer : C

49. Getting data from a cell located in a different sheet is called ......
A. Accessing
B. Referencing
C. Updating
D. Functioning
Answer : B

50. The Paste Special command lets you copy and paste:
A. Multiply the selection by a copied value
B. Cell comments
C. Formatting options
D. The resulting values of a formula instead of the actual formula
Answer : D