Menu
Home / CSE MCQs / VBA ::

CSE MCQs :: VBA

VBA -
  1. The Properties window plays an important role in the development of Visual Basic applications. It is mainly used
    2. A.
    To change how objects look and feel
    B.
    When opening programs stored on a hard drive
    C.
    To allow the developer to graphically design program components
    D.
    To set program related options like Program Name, Program Location, etc

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. What is the difference between iserror and iserr?
    3. A.
    Iserr excludes #n/A and returns the value
    B.
    Both are same
    C.
    Iserror excludes #n/A and returns the value
    D.
    Iserr returns when the value is #value

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. VBA is:
    4. A.
    a Microsoft programming language used to extend Excel functions
    B.
    a statistical tool developed by Microsoft for financial analysts
    C.
    an open-source programming environment
    D.
    a Microsoft programming environment that replaces Excel

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. Which of the following VBA windows shows the code of the active object?
    5. A.
    Explorer Window
    B.
    Properties window
    C.
    Immediate window
    D.
    Code window

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. When the user clicks a button, _________ is triggered.
    6. A.
    an event
    B.
    a method
    C.
    a setting
    D.
    a property

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. Which of the following refers to computer code, in VBA, that performs some action on or with objects?
    7. A.
    Excel function
    B.
    Sub-procedure
    C.
    Primary key
    D.
    Integrity constrain

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. A VBA unit is called a _____
    8. A.
    Subroutine
    B.
    Routine
    C.
    Macro
    D.
    Program

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which of the properties in a control's list of properties is used to give the control a meaningful name?
    9. A.
    Text
    B.
    ContextMenu
    C.
    ControlName
    D.
    Name

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. What are the data types in VBA?
    10. A.
    Boolean
    B.
    Byte
    C.
    Currency
    D.
    All of these

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. What is Default in VBA among the following?
    11. A.
    Pass By Address
    B.
    Pass By Reference
    C.
    Pass By Value
    D.
    None of the above

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers