Microsoft Excel Quiz Questions and Answers - MS Excel MCQ - Page 4

(Showing: 31 - 40 out of 125 MCQs)

Microsoft Excel Quiz Questions and Answers from MS Office topic. These MS Excel mcq are important for the banking examinations. Important MS Office Computer Awareness Questions Answers (mcq) listing for techincal aptitude for IBPS PO , MT Exam, Bank PO, Clerk, SBI, RBI and other competitive.

31. 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
32. Which elements of worksheet can be protected from accidental modification
[A] Contents
[B] Objects
[C] Scenarios
[D] All of above
33. You can select a single range of cells by
[A] Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
[B] Pressing the Ctrl key while dragging over the desired cells
[C] Pressing the Shift key and an arrow key
[D] Dragging over the desired cells
34. You can edit a cell by
[A] Clicking the formula button
[B] Double clicking the cell to edit it in-place
[C] Selecting Edit>Edit Cell from the menu
[D] None of above
35. 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
36. When you want to insert a blank imbedded excel object in a word document you can
[A] Click the object command on the insert menu
[B] Click the office links button on the standard toolbar
[C] Click the create worksheet button on the formatting toolbar
[D] Click the import excel command on the file menu
37. 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
38. 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
39. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
[A] Press Ctrl +Home
[B] Press Home
[C] Press Shift + Home
[D] Press Alt + Home
40. If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:
[A] Press the Erase key
[B] Press Esc
[C] Press the Enter button
[D] Press the Edit Formula button
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)