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

Computer Fundamentals :: MS Excel

  1. Status indicators are located on the

  2. A.

     Vertical scroll bar

    B.

     Horizontal scroll bar

    C.

     Formula bar

    D.

     Standard toolbar


  3. Which of the following is the oldest spreadsheet package?

  4. A.

     VisiCalc

    B.

     Lotus 1-2-3

    C.

     Excel

    D.

     StarCalc


  5. Rounding errors can occur

  6. A.

     When you use multiplication, division, or exponentiation in a formula

    B.

     When you use addition and subtraction in a formula

    C.

     Because excel uses hidden decimal places in computation

    D.

     When you show the results of formulas with different decimal places that the calculated results


  7. You can copy data or formulas

  8. A.

     With the copy, paste and cut commands on the edit menu

    B.

     With commands on the shortcut menu

    C.

     With buttons on the standard toolbars

    D.

     All of the above


  9. You cannot link excel worksheet data to a word document

  10. A.

     With the right drag method

    B.

     With a hyperlink

    C.

     With the copy and paste special commands

    D.

     With the copy and paste buttons on the standard toolbar


  11. Which of the following is a popular DOS based spreadsheet package?

  12. A.

     Word

    B.

     Smart cell

    C.

     Excel

    D.

     Lotus 1-2-3


  13. An excel workbook is a collection of

  14. A.

     Workbooks

    B.

     Worksheets

    C.

     Charts

    D.

     Worksheets and charts


  15. Excel files have a default extension of in Excel-2003

  16. A.

     Xls

    B.

     Xlw

    C.

     Wk1

    D.

     123


  17. You can use the format painter multiple times before you turn it off by

  18. A.

     You can use the format painter button on ly one time when you click it

    B.

     Double clicking the format painter button

    C.

     Pressing the Ctrl key and clicking the format painter button

    D.

     Pressing the Alt key and clicking the format painter button


  19. You can use the formula palette to

  20. A.

     Format cells containing numbers

    B.

     Create and edit formulas containing functions

    C.

     Enter assumptions data

    D.

     Copy a range of cells