COPA advanced excel concepts Page-18 Question Bank

86.  What will be the output of the following VBA code?
Sub test ( )
x = “institute”
Debug.print Format (x,”>”)
End sub
निम्नलिखित VBA कोड का आउटपुट क्या होगा?
Sub test ( )
x = “institute”
Debug.print Format (x,”>”)
End sub  [Bharat Skill QB]

(A) Institute
(B) institute
(C) INSTITUTE
(D) instiTUTE

87.  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
निम्नलिखित VBA कोड का आउटपुट क्या होगा?
Sub test ( )
Dim S AS string
S = “wholehearted”
Debug.Print mid(s,6,4)
End sub  [Bharat Skill QB]

(A) arte
(B) hear
(C) hole
(D) eart

88.  What will be the output of the following VBA code?
Sub test ( )
a = “ Computer operator”
Debug.Print left(a,10)
End sub
निम्नलिखित VBA कोड का आउटपुट क्या होगा?
Sub test ( )
a = “ Computer operator”
Debug.Print left(a,10)
End sub  [Bharat Skill QB]

(A) Operator
(B) Computer o
(C) Computer
(D) Computer operator

89.  What will be the output of the following VBA code?
Sub test ( )
Dim l as integer
Dim S as string
S = “Time is money”
l = len(s)
Debug.print “The length is “ & l
End sub
निम्नलिखित VBA कोड का आउटपुट क्या होगा?
Sub test ( )
Dim l as integer
Dim S as string
S = “Time is money”
l = len(s)
Debug.print “The length is “ & l
End sub  [Bharat Skill QB]

(A) 13
(B) The length is 11
(C) The length is 13
(D) THE LENGTH IS 13

90.  What will be the output of the following VBA function? Sub stg ( ) Str = “Mathematics” Debug.Print right (str,6) End sub
निम्नलिखित VBA कोड का आउटपुट क्या होगा? Sub stg ( ) Str = “Mathematics” Debug.Print right (str,6) End sub  [Bharat Skill QB]

(A) Matics
(B) Mathem
(C) Mathemat
(D) Mathematics