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

Computer Fundamentals :: MS Excel

  1. How do you delete a column?

  2. A.

     Select the column heading you want to delete and select the Delete Row button on the standard toolbar

    B.

     Select the column heading you want to delete and select Insert Delete from the menu

    C.

     Select the row heading you want to delete and select Edit>Delete from the menu

    D.

     Right click the column heading you want to delete and select delete from the shortcut menu

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. How can you find specific information in a list?

  4. A.

     Select Tools > Finder from the menu

    B.

     Click the Find button on the standard toolbar

    C.

     Select Insert > Find from the menu

    D.

     Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. When integrating word and excel, word is usually the

  6. A.

     Server

    B.

     Destination

    C.

     Client

    D.

     Both b and c

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. When a label is too long to fit within a worksheet cell, you typically must

  8. A.

     Shorten the label

    B.

     Increase the column width

    C.

     Decrease the column width

    D.

     Adjust the row height

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. The name box

  10. A.

     Shows the location of the previously active cell

    B.

     Appears to the left of the formula bar

    C.

     Appears below the status bar

    D.

     Appears below the menu bar

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Comments put in cells are called

  12. A.

     Smart Tip

    B.

     Cell Tip

    C.

     Web Tip

    D.

     Soft Tip

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Which is used to perform what if analysis?

  14. A.

     Solver

    B.

     Goal seek

    C.

     Scenario Manager

    D.

     All of above

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. You can use the horizontal and vertical scroll bars to

  16. A.

     Split a worksheet into two panes

    B.

     View different rows and columns edit the contents of a cell

    C.

     Edit the contents of a cell

    D.

     View different worksheets

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Multiple calculations can be made in a single formula using

  18. A.

     Standard formulas

    B.

     Array formula

    C.

     Complex formulas

    D.

     Smart formula

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. Hyperlinks can be

  20. A.

     Text

    B.

     Drawing objects

    C.

     Pictures

    D.

     All of above

    View Answer

    Workspace

    Discuss Discuss in Forum