$7.$ Left$()$ is a string function in VBA.

Option Explicit Dim answer As Integer, subb As Integer Dim Num$1$ As Integer, Num$2$ As Integer Private Sub AddValue$()$ Num$1=22$ Num$2=11$ Range$("$B$2").$Value $=$ Num$1+$ Num$2$ answer $=100$ answer $=$ answer $+1$ MsgBox $($Range$("$B$2").$Value$)$ MsgBox $("$value of cell b$2$ using range syntax is $"$ & Range$("$b$2").$Value$)$ Cells$(5,4).$Value $=$ "hello" MsgBox $($answer$)$ End Sub

$18.$ Option Explicit means that

a$.$ All variables are to be declared

c$.$ The number of variables cannot exceed $100$

b$.$ All variables are case sensitive

d$.$ Constants cannot be used

$19.$ What is the content of cell B$2$ after the program finishes execution?

a$.22$

c$.33$

b$.11$

d$.2$

$20.$ In the above code, Cells$(5,4).$Value refers to the value of Excel cell a$.$ D$5$ c$.$ C$1$ b$.$ D$4$ d$.$ C$4$

$21.$ What is the value displayed in the last dialog box after the program finishes execution?

a$.100$

c$.$ HELLo

b$.$ Msg

d$.101$

Questions $22-30,$ refer to the following the code

Dim MyString As String Sub Testing$()$ MyString $=$ "I went to School" MsgBox $("$Length is $"$ & Len$($MyString$))\text{'}$ string length MsgBox $($UCase$($MyString$))\text{'}$ to upper case MsgBox $($LCase$($MyString$))\text{'}$ to lower case MsgBox $($MyString$)\text{'}$ string as is End Sub

$22.$ If you run the above code, how many dialog boxes will be displayed?

a$.4$

c$.3$

b$.5$

d$.6$

$23.$ The first dialog box will display a$.$ Length is $16$ c$.$ I WENT TO SCHOOL b$.$ I went to School d$.$ i went to school

$24.$ The second dialog box will display

a$.$ Length is $16$

c$.$ I WENT TO SCHOOL

b$.$ I went to School

d$.$ i went to school

$25.$ The third dialog box will display

a$.$ Length is $16$

c$.$ I WENT TO SCHOOL

b$.$ I went to School

d$.$ i went to school

$26.$ The fourth dialog box will display

a$.$ Length is $16$

c$.$ I WENT TO SCHOOL

b$.$ I went to School

d$.$ i went to school

$27.$ The function UCase$($string$)$ converts a string to

a$.$ Lower case

c$.$ color red

b$.$ Upper case

d$.$ color green

$28.$ The function LCase$($string$)$ converts a string to

a$.$ Lower case

c$.$ Integer

b$.$ Upper case

d$.$ Double

$29.$ The variable Mystring is declared of type

a$.$ Double

c$.$ String

b$.$ Integer

d$.$ Currency

$30.$ In the above code, the parts of the code in green color

a$.$ Run at the end

c$.$ Are colored for fun

b$.$ Run in the beginning

d$.$ Do not run because they are comments