Adding a GroupBox to the Form and Using Financial.Pmt Method - Visual Basic Questions and Answers

1.

________ is used to add a GroupBox to the interface.

   A.) GroupBox tool
   B.) Group tool
   C.) View Window
   D.) Properties Window

Answer: Option 'A'

A GroupBox tool is used to add a GroupBox to the interface. The GroupBox tool is located in the containers section of the toolbox, because a GroupBox serves as a container for other controls.

DigitalOcean Referral Badge

2.

_________ is used to separate related controls from other controls in the form.

   A.) GroupBox
   B.) GroupBox tool
   C.) View Window
   D.) Groups

Answer: Option 'A'

You can use GroupBox to visually separate related controls from other controls in the form. For example, suppose you are designing a calculator, the Groupbox in the interface will visually separate the controls relating to principle, rate and term information from the rest of the controls.

DigitalOcean Referral Badge

3.

When you delete a groupbox the controls inside it are __________

   A.) Retained
   B.) Given to another groupbox
   C.) Data loss occurs
   D.) Deleted

Answer: Option 'D'

Deleted

The groupbox and the controls contained in the groupbox are treated as one unit. When you move the groupbox, the controls inside the groupbox are moved. Likewise when you delete a groupbox, the controls inside it are deleted.

DigitalOcean Referral Badge

4.

Use __________ for the optional label entered in the groupbox’s text property.

   A.) Sentence capitalization
   B.) Mixed capitalization
   C.) Row capitalization
   D.) Word capitalization

Answer: Option 'A'

Sentence capitalization

You can include an identifying label in the group box, by setting the group box’s text property. Labeling a group box is optional, but if you do label it, the label should be entered using sentence capitalization.

DigitalOcean Referral Badge

5.

The __________ method creates a periodic payment on either a loan or an investment.

   A.) Financial
   B.) Pmt
   C.) Financial.Pmt
   D.) Calculate

Answer: Option 'C'

The Financial.Pmt method creates a periodic payment on either a loan or an investment and it returns the calculated value as a Double number. The syntax is Financial.Pmt (Rate,NPer, PV) ; where Rate is the interest rate per period, Nper is the total number of payment periods and PV is the loan amount.

DigitalOcean Referral Badge

6.

What will be the output of the following Visual Basic expression?

Financial.Pmt (0.05, 3, 9000)

   A.) -3304.88
   B.) -3408.48
   C.) -3034.88
   D.) -3043.88

Answer: Option 'A'

The above expression calculates for a loan of Rs. 9000 for 3 years at 5% interest. Rate is 0.05, Nper is 3 and PV is 9000. The annual payment rounded off to nearest is, -3304.88.

DigitalOcean Referral Badge

7.

What will be the output of the following Visual Basic expression?

-Financial.Pmt (0.06/12, 5*12, 12000)

   A.) 200
   B.) 231.99
   C.) 345
   D.) 324.99

Answer: Option 'B'

231.99
The above expression calculates the monthly payment for a loan of Rs. 12000 for 5 years at 6% interest. Rate is 0.06/12, Nper is 5*12 and PV is 12000. The monthly payment rounded to the nearest and expressed as a positive number is 231.99.

DigitalOcean Referral Badge

8.

The number that appears after the period in the __________ value indicates the order in which the controls were added to the groupbox.

   A.) Tab index
   B.) Tab order
   C.) Groupbox tool
   D.) Tab value

Answer: Option 'A'

You need to lock the controls in place and set the tab order. The number that appears after the period in the tab index values indicates the order in which the controls were added to the group box. The current tab index values appear on blue boxes in the form.

DigitalOcean Referral Badge

9.

The TabIndex value of a group box is 5. If the txtName control was the first control added to the group box, its TabIndex value will be __________

   A.) 1
   B.) 5.0
   C.) 5.1
   D.) 1.5

Answer: Option 'B'

The TabIndex values of the controls contained within the groupbox starts with the tab index value of the groupbox itself. Thus the control txtName has tabIndex 5, which indicates that the control belongs to the GroupBox and not to the form.

DigitalOcean Referral Badge

10.

Which of the following calculates the quarterly payment on a loan of $6000 for 3 years at 9% interest? Payments should be expressed as a negative number.

   A.) Financial.Pmt (0.09/4, 3*12, 6000)
   B.) Financial.Pmt (0.09/4, 3*4, 6000)
   C.) Financial.Pmt( 0.09/12, 3*4, 6000)
   D.) Financial.Pmt(0.09/12, 3*12, 6000)

Answer: Option 'B'

Financial.Pmt (0.09/4, 3*4, 6000)

When we calculate quarterly, we divide the rate by 4, and multiply the Nper by 4, thus option b is correct. On the other hand, when we calculate monthly, we divide the rate by 12 and multiply the Nper by 12. Similarly, when we calculate half yearly, we divide the rate by 2 and multiply the Nper by 2.

DigitalOcean Referral Badge

Adding a GroupBox to the Form and Using Financial.Pmt Method - Visual Basic Questions and Answers Download Pdf

Recent Posts