Home / CSE MCQs / Advanced Excel ::

CSE MCQs :: Advanced Excel

  1. Statistical calculations and preparation of tables and graphs can be done using
  2. A.
    Adobe Photoshop
    B.
    Excel
    C.
    Notepad
    D.
    Power Point

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. You can activate a cell by
  4. A.
    Pressing the Tab key
    B.
    Clicking the cell
    C.
    Pressing an arrow key
    D.
    All of above

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu
  6. A.
    Edit
    B.
    Format
    C.
    Tools
    D.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. The Software which contains rows and columns is called ______
  8. A.
    Spreadsheet
    B.
    Word processing
    C.
    Database
    D.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. What type of chart is useful for comparing values over categories?
  10. A.
    Pie Chart
    B.
    Column Chart
    C.
    Line Chart
    D.
    Dot Graph

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which of the following is not an option of the spelling dialog box?
  12. A.
    Ignore
    B.
    Ignore all
    C.
    Edit
    D.
    Change

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. A worksheet range is a
  14. A.
    A command used for data modeling
    B.
    A range of values such as from 23 to 234
    C.
    A group of cells
    D.
    A group of worksheets

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. MS-Excel uses the . . . . Function when creating a data table
  16. A.
    Average
    B.
    Count
    C.
    Both of These
    D.
    Table

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. The active cell
  18. A.
    is defined by a bold border around the cell
    B.
    Receives the data the user enters
    C.
    It is the formula bar
    D.
    Only A and B

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. How can you remove borders applied in cells?
  20. A.
    Choose None on Border tab of Format cells
    B.
    Open the list on Border tool in Formatting toolbar then choose first tool
    C.
    Both of above
    D.
    None

    View Answer

    Workspace

    Discuss Discuss in Forum