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