Home / Computer Fundamentals / MS Excel :: section-3

Computer Fundamentals :: MS Excel

  1. To save a workbook, you:

  2. 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


  3. You can edit a cell by

  4. 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


  5. You can select a single range of cells by

  6. 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


  7. Which elements of worksheet can be protected from accidental modification

  8. A.

     Contents

    B.

     Objects

    C.

     Scenarios

    D.

     All of above


  9. You can use the drag and drop method to

  10. A.

     Copy cell contents

    B.

     Move cell contents

    C.

     Add cell contents

    D.

     A and B both


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

  12. A.

     Data will be entered in the adjacent cells

    B.

     No data will be entered in the adjacent cells

    C.

     There is no suitable abbreviation of the text

    D.

     There is not time to format the next


  13. How can you delete a record?

  14. 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


  15. Right clicking something in Excel:

  16. 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


  17. Documentation should include

  18. 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


  19. Files created with Lotus 1-2-3 have an extension

  20. A.

     DOC

    B.

     XLS

    C.

     123

    D.

     WK1