Home / Computer Fundamentals / MS Excel :: Section-1

Computer Fundamentals :: MS Excel

  1. Getting data from a cell located in a different sheet is called ________

  2. A.

     Accessing

    B.

     Referencing

    C.

     Updating

    D.

     Functioning

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Which of the following is not a valid data type in Excel?

  4. A.

     Number

    B.

     Character

    C.

     Label

    D.

     Date/Time

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Which elements of a worksheet can be protected from accidental modification?

  6. A.

     Contents

    B.

     Objects

    C.

     Scenarios

    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. A numeric value can be treated as label value if ________ precedes it.

  8. A.

     Apostrophe ( ‘ )

    B.

     Exclamation ( ! )

    C.

     Hash ( # )

    D.

     Tilde ( ~ )

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Concatenation of text can be done using

  10. A.

     Apostrophe ( ‘ )

    B.

     Exclamation ( ! )

    C.

     Hash ( # )

    D.

     Ampersand ( & )

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which area in an Excel window allows entering values and formulas?

  12. A.

     Title Bar

    B.

     Menu Bar

    C.

     Formula Bar

    D.

     Standard Tool Bar

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Multiple calculations can be made in a single formula using ________

  14. A.

     Standard Formulas

    B.

     Array Formula

    C.

     Complex Formulas

    D.

     Smart Formula

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. An Excel Workbook is a collection of ________

  16. A.

     Workbooks

    B.

     Worksheets

    C.

     Charts

    D.

     Worksheets and Charts

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. What do you mean by a Workspace?

  18. A.

     Group of Columns

    B.

     Group of Worksheets

    C.

     Group of Rows

    D.

     Group of Workbooks

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. MS-EXCEL is based on ________

  20. A.

     WINDOWS

    B.

     DOS

    C.

     UNIX

    D.

     OS/2

    View Answer

    Workspace

    Discuss Discuss in Forum