VBA

1. Which language is not a true object-oriented programming language?

a.)  VB.NET

b.)  VB 6

c.)  C++

d.)  C#

e.)  Java

 

2. A GUI:

a.)  uses buttons, menus, and icons.

b.)  should be easy for a user to manipulate.

c.)  stands for Graphic Use Interaction.

d.)  Both a and b.

e.)  All of the above.

3. Visual Studio .NET provides which feature:

a.)  debugging.

b.)  application deployment.

c.)  syntax checking.

d.)  Both a and b.

e.)  All of the above.

4. What does IDE stand for?

a.)  Integrated Development Environment

b.)  Integrated Design Environment

c.)  Interior Development Environment

d.)  Interior Design Environment

e.)  None of the above.

5. Which type of project can a developer choose in the New Project dialog box?

a.)  Visual Basic Projects

b.)  Visual C# Projects

c.)  Visual C++ Projects

d.)  Both a and b.

e.)  All of the above.

6. Which is not a main component of the Visual Studio IDE

a.)  Solution Explorer

b.)  Tool Box

c.)  Start Menu

d.)  Designer Window

e.)  Properties Window

7. Which does the solution explorer not display?

a.)  Form Properties

b.)  Reference Folder

c.)  Form File

d.)  Assemble File

e.)  All are part of the solution explorer.

 

 

 

 

 

 

 

8. Which is true about the name and text property of a control?

a.)  They are the same when the control is first created.

b.)  The text property changes to match any changes in the name property.

c.)  The name property changes to match any changes in the text property.

d.)  They are never the same unless the programmer makes it that way.

e.)  They are not allowed to be the same and an error will occur if they are.

9. For which task does the IDE provide multiple ways to accomplish the task?

a.)  Putting a control on the form

b.)  Running the program

c.)  Activating the property window for a control

d.)  Both a and b.

e.)  All of the above.

10. Which are the standard prefixes for the Button and Combo box controls respectively?

a.)  btn and chb

b.)  btn and cbo

c.)  bto and chb

d.)  bto and cbo

e.)  cmd and cbo

11. Which are the standard prefixes for the text box and label controls respectively?

a.)  tex and lbl

b.)  tex and lab

c.)  txb and lbl

d.)  txb and lab

e.)  txt and lab

12. Which task is accomplished in the Code editor?

a.)  Adding forms to the project

b.)  Adding controls to the form

c.)  Adding event procedures to the form

d.)  Both a and b.

e.)  All of the above.

 

13. Which is not a feature of a GUI that makes learning a program easy for users?

a.)  Online help

b.)  WYSIWYG formatting

c.)  Dialog boxes

d.)  Detailed key strokes and commands

e.)  Icons

 

14. An object is composed of:

a.)  properties.

b.)  methods.

c.)  events.

d.)  Both a and b.

e.)  All of the above.

 

15. Which statement about objects is true?

a.)  One object is used to create one class.

b.)  One class is used to create one object.

c.)  One object can create many classes.

d.)  One class can create many objects.

e.)  There is no relationship between objects and classes.

 

16. Which is not true about forms and controls in Visual Basic?

a.)  They are pre-built.

b.)  They are graphical objects.

c.)  New versions of the classes must be created with each project.

d.)  Buttons can be created with the drag and drop method.

e.)  All of the above are true.

 

17. Which is an example of Visual Basic Objects?

a.)  Control objects

b.)  ASP.NET

c.)  ADO.NET

d.)  Both a and b.

e.)  All of the above.

18. The .Net class library:

a.)  contains over 25,000 classes.

b.)  uses namespaces to manage all of the classes.

c.)  has the System.Form namespace for classes used in Windows-based application.

d.)  Both a and b.

e.)  All of the above.

 

19. Which is not a property of the Common control class?

a.)  Show

b.)  BackColor

c.)  Font

d.)  ForeColor

e.)  Name

20. Which property determines whether a control is displayed to the user?

a.)  Hide

b.)  Show

c.)  Visible

d.)  Enabled

e.)  Cursor

 

21. The Button control can be activated:

a.)  programmatically through the click event.

b.)  by clicking the button with the mouse.

c.)  with the form’s DefaultButton property.

d.)  Both a and b.

e.)  All of the above.

22. The CancelButton property belongs to which object?

a.)  Button

b.)  Form

c.)  Label

d.)  TextBox

e.)  Timer

 

23. A click event procedure stud for the label control can be created by:

a.)  selecting the object and event from the code editor window’s drop-down boxes.

b.)  typing the code in the code editor window.

c.)  by double clicking the control.

d.)  Both a and b.

e.)  All of the above.

24. In event-driven programming an event is generated by:

a.)  the system.

b.)  a user’s action.

c.)  the program itself.

d.)  Both a and b.

e.)  All of the above.

 

25. Which is not a common control event?

a.)  Click

b.)  SingleClick

c.)  DoubleClick

d.)  MouseMove

e.)  MouseDown

 

26. The Tick event is found only in which object?

a.)  Form

b.)  Button

c.)  TextBox

d.)  Label

e.)  Timer

27. The Activated event is found only in which object?

a.)  Form

b.)  Button

c.)  TextBox

d.)  Label

e.)  Timer

28. The Rnd statement will generate a(n):

a.)  decimal value between 0.01 and 1.00.

b.)  integer value between 0.01 and 1.00.

c.)  decimal value between 0.0 and 1.0.

d.)  integer value between 0.0 and 1.0.

e.)  decimal value between 0.0 and up to 1.0, but not including 1.0.

 

29. The analysis phase of software development involves:

a.)  collecting the requirements about what the program will accomplish.

b.)  creating a detailed plan on how the program will accomplish the requirements.

c.)  writing the software with a program such as VB.NET.

d.)  Both a and b.

e.)  All of the above.

30. Which phase of project development typically costs the most?

a.)  Analysis

b.)  Design

c.)  Implementation

d.)  Maintenance

e.)  Documentation

31. Which is not an integer data type?

a.)  Single

b.)  Byte

c.)  Short

d.)  Integer

e.)  Long

32. Which is a numeric data type?

a.)  Floating point

b.)  Integer

c.)  Boolean

d.)  Both a and b.

e.)  All of the above.

33. Which sequence of char data types is listed from lowest to highest?

a.)  a, A, z, Z

b.)  a, z, A, Z

c.)  A, a, Z, z

d.)  A, Z, a, z

e.)  z, a, Z, A

34. The Date data type does not hold which type of information.

a.)  Seconds

b.)  Hours

c.)  Days

d.)  Months

e.)  Quarters

35. The Boolean data type:

a.)  is unsigned.

b.)  has two states.

c.)  is displayed by the program as yes or no.

d.)  Both a and b.

e.)  All of the above.

36. Which is a valid statement for declaring a variable?

a.)  Const Form As Integer

b.)  Const myForm As Integer

c.)  Dim Form As Integer

d.)  Dim myForm As Integer

e.)  All of the above.

37. VB.Net identifiers:

a.)  are case sensitive.

b.)  can begin with an underscore.

c.)  can begin with a number.

d.)  Both a and b.

e.)  All of the above.

38. The name of a constant:

a.)  must both begin with a letter and be all upper case.

b.)  does not have to begin with a letter but must be all upper case.

c.)  must begin with a letter but can be upper or lower case.

d.)  does not have to begin with a letter and be either upper or lower case.

e.)  None of the above.

39. The proper operator precedence, from first to last, is:

a.)  logical, comparison, and arithmetic.

b.)  arithmetic, comparison, and logical.

c.)  arithmetic, logical, and comparison.

d.)  comparison, arithmetic, and logical.

e.)  logical, arithmetic, comparison.

40. With A = False and B = True, which statement evaluates as True?

a.)  A AND A

b.)  A AND B

c.)  B AND A

d.)  B AND B

e.)  None are true.

41. With A = False and B = True, which statement evaluates as False?

a.)  A OR A

b.)  A OR B

c.)  B OR A

d.)  B OR B

e.)  None are true.

42. Which operator is evaluated first?

a.)  NOT

b.)  AND

c.)  XOR

d.)  OR

e.)  They are always evaluated left-to-right.

43. The left side of an assignment statement will hold:

a.)  a variable.

b.)  an object property.

c.)  an expression.

d.)  Both a and b.

e.)  All of the above.

44. The right side of an assignment statement will hold:

a.)  a variable.

b.)  an object property.

c.)  an expression.

d.)  Both a and b.

e.)  All of the above.

45. Which function will return the monthly payments of a loan?

a.)  Pay (Rate, PV, Nper)

b.)  Pmt (Rate, Nper, PV)

c.)  FV (Rate, Nper, Pmt)

d.)  FV (Rate, Nper, PV)

e.)  None of the above.

46. Which function returns the numbers represented in the string “$56.7”?

a.)  Abs

b.)  CDbl

c.)  Int

d.)  Rnd

e.)  Val

47. What will the function Val ($165.30) return?

a.)  0

b.)  165

c.)  165.30

d.)  $165.30

e.)  An error

48. Which function displays a pop-up window?

a.)  MsgBox

b.)  InputBox

c.)  TextBox

d.)  Both a and b.

e.)  All of the above.

49. Which is true about the prompt argument?

a.)  It can be made of multiple values concatenated into one string.

b.)  It can include the vbCrLf constant.

c.)  It can include the ampersand symbol to concatenate strings.

d.)  Both a and b.

e.)  All of the above.

50. In order to process a number typed in a TextBox the programmer must:

a.)  use the Val function to convert the Text value.

b.)  use the CDbl function to convert the Text value.

c.)  use the IsNumeric function to convert the Text value.

d.)  Both a and b.

e.)  All of the above.

 

51. Which TextBox method does not use the clipboard?

a.)  Clear

b.)  Copy

c.)  Cut

d.)  Paste

e.)  All of these methods use the clipboard.

52. Which TextBox property should always be changed first?

a.)  AcceptsReturn

b.)  BorderStyle

c.)  Font

d.)  Name

e.)  Text

 

53. Which is not a valid value for the ListBox SectionMode Property?

a.)  None

b.)  One

c.)  MultiSimple

d.)  MultiExtended

e.)  All of the above.

54. Setting the SelectedIndex property of a ListBox to -1 will:

a.)  cause an error.

b.)  cannot be done.

c.)  de-select any selected item.

d.)  Both a and b.

e.)  All of the above.

55. Which method of a ListBox will remove just one item at a time?

a.)  Items.RemoveAt

b.)  Item.RemoveAt

c.)  Items.ClearAt

d.)  Item.ClearAt

e.)  Items.Clear

 

56. The Items property of a ComboBox:

a.)  is a collection of items.

b.)  is the same as the Items property of a ListBox.

c.)  contains methods and properties.

d.)  Both a and b.

e.)  All of the above.

57. Which value for the ComboBox DropDownStyle property allows a user to type in data?

a.)  DropDown

b.)  DropDownSimple

c.)  DropDownList

d.)  Both a and b.

e.)  All of the above.

58. Which two controls combined to form the ComboBox control?

a.)  ListBox and TextBox

b.)  ListBox and InputBox

c.)  ListBox and MsgBox

d.)  Label and TextBox

e.)  Label and InputBox

59. When a condition in an If…Then statements tests true:

a.)  the next Else statement is activated.

b.)  the next If statement is activated.

c.)  the next Then statement is activated.

d.)  the End If statement is activated.

e.)  a condition can never test true.

 

60. The End If statement is required:

a.)  in all If…Then statements.

b.)  in all Multi-line statements with Else.

c.)  in Single Line statements.

d.)  Both a and b.

e.)  All of the above.