Thursday, 3 September 2015

MS Excel Multiple Choice Questions And Answers

21. Which of the following is not an option in the spelling dialog box?
a.   Edit
b.   Ignore
c.   Ignore all
d.   Change
Ans: a

22. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
a.   Edit
b.   View
c.   Format
d.   Tools
Ans: c

23. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
a.   Edit
b.   Format
c.   Tools
d.   Data
Ans: c

24. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
a.   Edit
b.   Insert
c.   Format
d.   Tools
Ans: d

25. Which of the following is not a worksheet design criterion?
a.   Efficiency
b.   Audit ability
c.   Description
d.   Clarity  
Ans: c

26. To copy cell contents using drag and drop, press the
a.   End key
b.   Shift key
c.   Esc key
d.   None of above
Ans: d

27. If you press …., the cell accepts your typing as its contents.
a.   Enter
b.   Ctrl + Enter
c.   TAB
d.   Insert
Ans: a

28. The auto fill feature
a.   Extends a sequential series of data
b.   Automatically adds a range of cell values
c.   Applies a boarder around selected cells
d.   None of above
Ans: a

29. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
a.   F3
b.   F5
c.   F7
d.   F11
Ans: d

30. you can use the formula palette to
a.   format cells containing numbers
b.   create and edit formulas containing functions
c.   entered assumptions data
d.   copy a range of cells
Ans: b

More Questions & Answers:-
Page1 Page2 Page3 Page4 Page5

No comments:

Post a Comment