Sail E0 Webinar

Computer Aptitude

MS EXCEL MCQs

Ms Excel

Total Questions : 506 | Page 10 of 51 pages
Question 91. To save a workbook, you:
  1.    Click the save button on the standard toolbar from the menu
  2.    Press Ctrl+ F5
  3.    Click Save on the Windows Start button
  4.    Select Edit > Save
 Discuss Question
Answer: Option A. -> Click the save button on the standard toolbar from the menu
Question 92. You can edit a cell by
  1.    Clicking the formula button
  2.    Double clicking the cell to edit it in-place
  3.    Selecting Edit > Edit Cell from the menu
  4.    None of above
 Discuss Question
Answer: Option B. -> Double clicking the cell to edit it in-place
Question 93. Which elements of worksheet can be protected from accidental modification
  1.    Contents
  2.    Objects
  3.    Scenarios
  4.    All of above
 Discuss Question
Answer: Option D. -> All of above
Question 94. You can select a single range of cells by
  1.    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
  2.    Pressing the Ctrl key while dragging over the desired cells
  3.    Pressing the Shift key and an arrow key
  4.    Dragging over the desired cells
 Discuss Question
Answer: Option D. -> Dragging over the desired cells
Question 95. You can use the drag and drop method to
  1.    Copy cell contents
  2.    Move cell contents
  3.    Add cell contents
  4.    A and B both
 Discuss Question
Answer: Option D. -> A and B both
Question 96. It is acceptable to let long text flow into adjacent cells on a worksheet when
  1.    Data will be entered in the adjacent cells
  2.    No data will be entered in the adjacent cells
  3.    There is no suitable abbreviation of the text
  4.    There is not time to format the next
 Discuss Question
Answer: Option B. -> No data will be entered in the adjacent cells
Question 97. How can you delete a record?
  1.    Delete the column from the worksheet
  2.    Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
  3.    Select Data > Delete Record from the menu
  4.    Click the Delete button on the Standard toolbar
 Discuss Question
Answer: Option B. -> Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Question 98. Right clicking something in Excel:
  1.    Deletes the object
  2.    Nothing the right mouse button is there for left handed people
  3.    Opens a shortcut menu listing everything you can do to the object
  4.    Selects the object
 Discuss Question
Answer: Option C. -> Opens a shortcut menu listing everything you can do to the object
Question 99. Documentation should include
  1.    Destination and users of the output data
  2.    Source of input data
  3.    Information on the purpose of the workbook
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 100. Files created with Lotus 1-2-3 have an extension
  1.    DOC
  2.    XLS
  3.    123
  4.    WK1
 Discuss Question
Answer: Option C. -> 123

Latest Videos

Latest Test Papers