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


  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


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

  6. A.

     Server

    B.

     Destination

    C.

     Client

    D.

     Both b and c


  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


  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


  11. Comments put in cells are called

  12. A.

     Smart Tip

    B.

     Cell Tip

    C.

     Web Tip

    D.

     Soft Tip


  13. Which is used to perform what if analysis?

  14. A.

     Solver

    B.

     Goal seek

    C.

     Scenario Manager

    D.

     All of above


  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


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

  18. A.

     Standard formulas

    B.

     Array formula

    C.

     Complex formulas

    D.

     Smart formula


  19. Hyperlinks can be

  20. A.

     Text

    B.

     Drawing objects

    C.

     Pictures

    D.

     All of above