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

Computer Fundamentals :: MS Excel

  1. The Paste Special command lets you copy and paste:

  2. A.

     Multiply the selection by a copied value

    B.

     Cell comments

    C.

     Formatting options

    D.

     The resulting values of a formula instead of the actual formula


  3. The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this?

  4. A.

     You have to retype everything and manually add the dollar signs, commas, and decimals

    B.

     Select Format > Money from the menu

    C.

     Click the Currency Style button on the formatting toolbar

    D.

     None of these


  5. Excel worksheet cells work very similarly to what common element of the windows graphical user interface

  6. A.

     Option buttons

    B.

     List boxes

    C.

     Text boxes

    D.

     Combo boxes


  7. Which of the following options is not located in the Page Setup dialog box?

  8. A.

     Page Break Preview

    B.

     Page Orientation

    C.

     Margins

    D.

     Headers and Footers


  9. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

  10. A.

     Pie chart

    B.

     Row chart

    C.

     Line chart

    D.

     Column chart


  11. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

  12. A.

     Press Ctrl + Home

    B.

     Press Home

    C.

     Press Shift + Home

    D.

     Press Alt + Home


  13. Which of the following methods can not be used to edit the contents of a cell?

  14. A.

     Press the Alt key

    B.

     Clicking the formula bar

    C.

     Pressing the F2 key

    D.

     Double clicking the cell


  15. If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

  16. A.

     Press the Erase key

    B.

     Press Esc

    C.

     Press the Enter button

    D.

     Press the Edit Formula button


  17. To view a cell comment

  18. A.

     Click the edit comment command on the insert menu

    B.

     Click the display comment command on the window menu

    C.

     Position the mouse pointer over the cell

    D.

     Click the comment command on the view menu


  19. When you want to insert a blank embedded excel object in a word document you can

  20. A.

     Click the object command on the insert menu

    B.

     Click the office links button on the standard toolbar

    C.

     Click the create worksheet button on the formatting toolbar

    D.

     Click the import excel command on the file menu