MS Excel -02

01. Which of the following is not a worksheet design criterion?

  • 1Efficiency
  • 2Aditibility
  • 3Description
  • 4Clarity

02. Comments can be added to cells using

  • 1Edit > Comments
  • 2Insert > Comments
  • 3File > Comments
  • 4View > Comments

03. To delete an embedded objects, first

  • 1Double click the object
  • 2Select the object by clicking it
  • 3Press the Shift + Delete keys
  • 4Select it and then press the delete key

05. Right clicking something in Excel:

  • 1Deletes the object
  • 2Nothing the right mouse button is there for left handed people
  • 3Opens a shortcut menu listing everything you can do to the object
  • 4Selects the object

06. How can you delete a record?

  • 1Delete the column from the worksheet
  • 2Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
  • 3Select Data > Delete Record from the menu
  • 4Click the Delete button on the Standard toolbar

07. It is acceptable to let long text flow into adjacent cells on a worksheet when

  • 1Data will be entered in the adjacent cells
  • 2No data will be entered in the adjacent cells
  • 3There is no suitable abbreviation of the text
  • 4There is not time to format the next

08. You can use the drag and drop method to

  • 1Copy cell contents
  • 2Move cell contents
  • 3Add cell contents
  • 4a and b

09. You can select a single range of cells by

  • 1Clicking 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
  • 2Pressing the Ctrl key while dragging over the desired cells
  • 3Pressing the Shift key and an arrow key
  • 4Dragging over the desired cells

10. You can edit a cell by

  • 1Clicking the formula button
  • 2Double clicking the cell to edit it in-place
  • 3Selecting Edit>Edit Cell from the menu
  • 4None of above
Page 1 Of 2
Test
Classes
E-Book