PROGRAMMING WITH VBA - Quiz

1) What will be the output of the following VBA code?
Sub test()
a = 'Computer operator'
Debug.Print left(a,10)
End sub

Operator Computer o Computer Computer operator

2) 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

13 The length is 11 The length is 13 THE LENGTH IS 13

3) What will be the output of the following VBA function?
Sub stg()Str = 'Mathematics'
Debug.Print right(str,6)
End sub

matics Mathem Mathemat Mathematics