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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  4. A.

     VisiCalc

    B.

     Lotus 1-2-3

    C.

     Excel

    D.

     StarCalc

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. An excel workbook is a collection of

  14. A.

     Workbooks

    B.

     Worksheets

    C.

     Charts

    D.

     Worksheets and charts

    View Answer

    Workspace

    Discuss Discuss in Forum


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

  16. A.

     Xls

    B.

     Xlw

    C.

     Wk1

    D.

     123

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum