PROGRAMMING WITH VBA

QuizApp

Home
Teacher
Student

Dashboard
Study MCQ
Computer Operator and Programming Assistant (COPA)
PROGRAMMING WITH VBA
Set 18

Set 18 Practice Mode

Prev Next

Set Completed!

0 / 5

Next Set

Q2201

Permalink

Which scope does the variable declared with dim and remains in the existence only as long as the procedure in which if is declared is running?

A Global scope

B Local scope

C Module scope

D Project scope

Q2202

Permalink

What will be the output of the following VBA code? Sub test() a = 9 Debug.Print Sqr(a) End sub

A 3

B 9

C 18

D 81

Q2203

Permalink

What will be the output for the following VBA code?Debug.print DateDiff('yyyy','1/12/2016','31/1/2017')

A 0

B 1

C 11

D 30

Q2204

Permalink

What will be the output of the following VBA code? Sub test() x = 'institue' Debug.print Format(x,'>') End sub

A Institute

B institute

C INSTITUTE

D instiTUTE

Q2205

Permalink

What will be the output of the following VBA code? Sub test() Dim S AS string S = 'wholehearted' Debug.Print mid(s,6,4) End sub

A arte

B hear

C hole

D eart

Report Question Issue

Your Name (Optional)

Your Email (Optional)

What do you think is the correct answer? *

Select which option you believe is the correct answer.

Feedback *

Verify you're human *

Set 18 Practice Mode

Set Completed!

Which scope does the variable declared with dim and remains in the existence only as long as the procedure in which if is declared is running?

What will be the output of the following VBA code? <br> Sub test() <br> a = 9 <br> Debug.Print Sqr(a) <br> End sub

What will be the output for the following VBA code?Debug.print<br>DateDiff('yyyy','1/12/2016','31/1/2017')

What will be the output of the following VBA code?<br>Sub test()<br>x = 'institue'<br>Debug.print Format(x,'>')<br>End sub

What will be the output of the following VBA code?<br>Sub test()<br>Dim S AS string<br>S = 'wholehearted'<br>Debug.Print mid(s,6,4)<br>End sub