jennyjennyje
11-05-2009, 04:24 AM
Hi guys,
I just started with vba in excel,
does anyone know the answers of thise two questions?
Question 1
Marks: 1 Consider the following expression:
switch(MyTest, MyVal1, True, MyVal2)
Which of the following remarks about it is True?
Choose one answer. a. it is exactly equivalent to iif(MyTest = MyVal2, MyVal1, True)
b. it is exactly equivalent to iif(MyTest = MyVal1, MyVal2, True)
c. it is exactly equivalent to iif(MyTest, MyVal1, MyVal2)
d. it is exactly equivalent to iif(MyTest, MyVal2, MyVal1)
e. it is exactly equivalent to iif(MyTest = MyVal1, True, MyVal2)
Question 2
Marks: 1 A variable MyVar is defined within a procedure called MyProc in a module called "Module 1".
Dim MyVar as Integer
Which of the following is most correct?
Choose one answer. a. MyVar can be used within loops and branches within MyProc but nowhere else
b. MyVar can be used anywhere within Module 1, but not outside the module
c. MyVar can be used within the procedure MyProc but no where else
d. MyVar can be used within the spreadsheet, but no where else
I just started with vba in excel,
does anyone know the answers of thise two questions?
Question 1
Marks: 1 Consider the following expression:
switch(MyTest, MyVal1, True, MyVal2)
Which of the following remarks about it is True?
Choose one answer. a. it is exactly equivalent to iif(MyTest = MyVal2, MyVal1, True)
b. it is exactly equivalent to iif(MyTest = MyVal1, MyVal2, True)
c. it is exactly equivalent to iif(MyTest, MyVal1, MyVal2)
d. it is exactly equivalent to iif(MyTest, MyVal2, MyVal1)
e. it is exactly equivalent to iif(MyTest = MyVal1, True, MyVal2)
Question 2
Marks: 1 A variable MyVar is defined within a procedure called MyProc in a module called "Module 1".
Dim MyVar as Integer
Which of the following is most correct?
Choose one answer. a. MyVar can be used within loops and branches within MyProc but nowhere else
b. MyVar can be used anywhere within Module 1, but not outside the module
c. MyVar can be used within the procedure MyProc but no where else
d. MyVar can be used within the spreadsheet, but no where else