PROGRAMMING WITH VBA - Practice Mode

1) Which method is used to pass the reference to the arguments?

Ref Val Reference By Ref

Correct Answer: By Ref

2) Which function is used to check whether the given input is numeric or Not in VBA?

Numeric() Isnumber() Isnumeric() Isnum()

Correct Answer: Isnumeric()

3) Which function returns specified part of a given date in VBA?

Day() Datevalue() Datediff() Datepart()

Correct Answer: Datepart()

4) Which function returns the difference between two date values based on the interval specified in VBA?

Datediff() Day() Daydiff() Datedif()

Correct Answer: Datediff()

5) What is the return type of CSng function in VBA?

Boolean Variant Single String

Correct Answer: Single

Previous Question Set Back to Question Sets Next Question Set

Try Another Topic

Try Another Quiz