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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  8. A.

     Contents

    B.

     Objects

    C.

     Scenarios

    D.

     All of above

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  20. A.

     DOC

    B.

     XLS

    C.

     123

    D.

     WK1

    View Answer

    Workspace

    Discuss Discuss in Forum