1000+ Microsoft Excel Multiple Choice Question Answer [Solved]

1. Each excel file is called a workbook because
A. It can contain text and data
B. It can be modified
C. It can contain many sheets including worksheets and chart sheets
D. You have to work hard to create it
Answer : C

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

3. You can auto fit the width of column by
A. double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
Answer : C

4. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
Answer : C

5. What are the tabs that appear at the bottom of each workbook called?
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs
Answer : D

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

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

8. Which of the following action removes a sheet from workbook?
A. Select the sheet, then choose Edit >> Delete Sheet
B. Select the sheet then choose Format >> Sheet >> Hide
C. Both of above
D. None of above
Answer : A

9. An excel workbook is a collection of
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts
Answer : D

10. The name box
A. Shows the location of the previously active cell
B. Appears to the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar
Answer : B

11. Edit >> Delete command
A. Deletes the content of a cell
B. Deletes Formats of cell
C. Deletes the comment of cell
D. Deletes selected cells
Answer : D

12. 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

13. Which of the following is a correct order of precedence in formula calculation?
A. Multiplication and division exponentiation positive and negative values
B. Multiplication and division, positive and negative values, addition and subtraction
C. Addition and subtraction, positive and negative values, exponentiation
D. All of above
Answer : D

14. Which of the following Excel screen components can NOT be turned on or off?
A. Formula Bar
B. Status Bar
C. Tool Bar
D. None of above
Answer : D

15. Concatenation of text can be done using
A. Apostrophe ( )
B. Exclamation ( ! )
C. Hash ( # )
D. Ampersand ( & )
Answer : D

16. In Excel, a Data Series is defined as what?
A. A type of chart
B. A cell reference
C. A collection of related data
D. A division of results
Answer : C

17. 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

18. You can use the drag and drop method to
A. Copy cell contents
B. Move cell contents
C. Add cell contents
D. a and b
Answer : D

19. 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

20. You can use the horizontal and vertical scroll bars to
A. Split a worksheet into two panes
B. View different rows and columns edit the contents of a cell
C. Edit the contents of a cell
D. view different worksheets
Answer : B

21. Files created with Lotus 1-2-3 have an extension
A. DOC
B. XLS
C. 123
D. WK1
Answer : C

22. How do you display current date only in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()
Answer : B

23. Status indicators are located on the
A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar
Answer : C

24. How can you delete a record?
A. Delete the column from the worksheet
B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
C. Select Data > Delete Record from the menu
D. Click the Delete button on the Standard toolbar
Answer : B

25. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A. Unfreeze panes command on the window menu
B. Freeze panes command on the window menu
C. Hold titles command on the edit menu
D. Split command on the window menu
Answer : B

26. Multiple calculations can be made in a single formula using
A. standard formulas
B. array formula
C. complex formulas
D. smart formula
Answer : B

27. To copy cell contents using drag and drop press the
A. End key
B. Shift key
C. Ctrl key
D. Esc key
Answer : A

28. 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

29. You can enter which types of data into worksheet cells?
A. Labels, values, and formulas
B. Labels and values but not formulas
C. Values and formulas but not labels
D. Formulas only
Answer : A

30. B7:B9 indicates:
A. Cells B7 and cell B9 only
B. Cells B7 through B9
C. Cell B8 only
D. None of the above
Answer : B

31. A typical worksheet has …. Number of columns
A. 128
B. 256
C. 512
D. 1024
Answer : B

32. 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

33. Which of the following is not the correct method of editing the cell content?
A. Press the Alt key
B. Press the F2 key
C. Click the formula bar
D. Double click the cell
Answer : A

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

35. Which of the following is the latest version of Excel
A. Excel 2000
B. Excel 2002
C. Excel ME
D. Excel XP
Answer : D

36. When a label is too long to fit within a worksheet cell, you typically must
A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height
Answer : B

37. How do you select an entire column?
A. Select Edit > Select > Column from the menu
B. Click the column heading letter
C. Hold down the shift key as you click anywhere in the column
D. Hold down the Ctrl key as you click anywhere in the column
Answer : B

38. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A. F8
B. F9
C. F10
D. F11
Answer : B

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

40. 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

41. 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

42. It is acceptable to let long text flow into adjacent cells on a worksheet when
A. data will be entered in the adjecent cells
B. no data will be entered in the adjacent cells
C. there is no suitable abbrevition for the text
D. there is not time to format the text
Answer : B

43. Which area in an excel window allows entering values and formulas
A. Title bar
B. Menu bar
C. Formula bar
D. Standard toolbar
Answer : C

44. Rounding errors can occur
A. When you use multiplication, division, or exponentiation in a formula
B. When you use addition and subtraction in a formula
C. Because excel uses hidden decimal places in computation
D. When you show the results of formulas with different decimal places that the calculated results
Answer : A

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

46. 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

47. 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

48. Which language is used to create macros in Excel?
A. Visual Basic
B. C
C. Visual C++
D. Java
Answer : A

49. Excel probably considers the cell entry January 1, 2000 to be a
A. Label
B. Value
C. Formula
D. Text string
Answer : B

50. We can save and protect the workbook by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above
Answer : D