Menu
Home / CSE MCQs / Advanced Excel ::

CSE MCQs :: Advanced Excel

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

  2. You can activate a cell by
    3. 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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. A worksheet range is a
    8. 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

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

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. The active cell
    10. 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

  10. How can you remove borders applied in cells?
    11. 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

Java Programming Questions and Answers Interview Questions and Answers