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


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

  4. A.

     Number

    B.

     Character

    C.

     Label

    D.

     Date/Time


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

  6. A.

     Contents

    B.

     Objects

    C.

     Scenarios

    D.

     All of the above


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

  8. A.

     Apostrophe ( ‘ )

    B.

     Exclamation ( ! )

    C.

     Hash ( # )

    D.

     Tilde ( ~ )


  9. Concatenation of text can be done using

  10. A.

     Apostrophe ( ‘ )

    B.

     Exclamation ( ! )

    C.

     Hash ( # )

    D.

     Ampersand ( & )


  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


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

  14. A.

     Standard Formulas

    B.

     Array Formula

    C.

     Complex Formulas

    D.

     Smart Formula


  15. An Excel Workbook is a collection of ________

  16. A.

     Workbooks

    B.

     Worksheets

    C.

     Charts

    D.

     Worksheets and Charts


  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


  19. MS-EXCEL is based on ________

  20. A.

     WINDOWS

    B.

     DOS

    C.

     UNIX

    D.

     OS/2