Home / CSE MCQs / VBA ::

CSE MCQs :: 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


  3. What is the difference between iserror and iserr?
  4. 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


  5. VBA is:
  6. 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


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. A VBA unit is called a _____
  14. A.
    Subroutine
    B.
    Routine
    C.
    Macro
    D.
    Program

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum