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

(Showing: 21 - 30 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.

21. 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 doesn’t adjust relative cell references
22. To copy cell contents using drag and drop press the
[A] End key
[B] Shift key
[C] Ctrl key
[D] Esc key
23. Which of the following is the latest version of Excel
[A] Excel 2000
[B] Excel 2002
[C] Excel ME
[D] Excel XP
24. Which of the following is not a worksheet design criterion?
[A] Efficiency
[B] Aditibility
[C] Description
[D] Clarity
25. Comments can be added to cells using
[A] Edit > Comments
[B] Insert > Comments
[C] File > Comments
[D] View > Comments
26. To delete an embedded objects, first
[A] Double click the object
[B] Select the object by clicking it
[C] Press the Shift + Delete keys
[D] Select it and then press the delete key
27. Files created with Lotus 1-2-3 have an extension
[C] 123
[D] WK1
28. 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
29. 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
30. Documentation should include
[A] Destination and users of the output data
[B] Source of input data
[C] Information on the purpose of the workbook
[D] All of the above
Are these questions helpful for you?

Comments: (Your feedback is valuable to us)