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

Computer Fundamentals :: MS Excel

  1. To activate the previous cell in a pre-selected range, press

  2. A.

     The Alt key

    B.

     The Tab key

    C.

     The Enter key

    D.

     None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Which button do you click to add up a series of numbers?

  4. A.

     The autosum button

    B.

     The Formula button

    C.

     The quicktotal button

    D.

     The total button

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. When the formula bar is active, you can see

  6. A.

     The edit formula button

    B.

     The cancel button

    C.

     The enter button

    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. To copy formatting from one area in a worksheet and apply it to another area you would use:

  8. A.

     The Edit > Copy Format and Edit>Paste Format commands form the menu

    B.

     The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

    C.

     There is no way to copy and apply formatting in Excel – You have to do it manually

    D.

     The Format Painter button on the standard toolbar

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. In a worksheet you can select

  10. A.

     The entire worksheet

    B.

     Rows

    C.

     Columns

    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. When you link data maintained in an excel workbook to a word document

  12. A.

     The word document cannot be edit

    B.

     The word document contains a reference to the original source application

    C.

     The word document must contain a hyperlink

    D.

     The word document contains a copy of the actual data

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Which area in an excel window allows entering values and formulas

  14. A.

     Title bar

    B.

     Menu bar

    C.

     Formula bar

    D.

     Standard toolbar

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

  16. A.

     Unfreeze panes command on the window menu

    B.

     Freeze panes command on the window menu

    C.

     Hold titles command on the edit menu

    D.

     Split command on the window menu

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. To edit in an embedded excel worksheet object in a word document

  18. A.

     Use the excel menu bar and toolbars inside the word application

    B.

     Edit the hyperlink

    C.

     Edit the data in a excel source application

    D.

     Use the word menu bar and toolbars

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. To create a formula, you can use:

  20. A.

     Values but not cell references

    B.

     Cell references but not values

    C.

     Values or cell references although not both at the same time

    D.

     Value and cell references

    View Answer

    Workspace

    Discuss Discuss in Forum