PROGRAMMING WITH VBA - Practice Mode

1) How many levels of variable scope available in VBA?

2 3 4 7

Correct Answer: 4

2) What will be the output of the following VBA code?
Debug.printformat(#1/1/2017#,'yyyy/mm/dd')

01-01-2017 Sun, Jan01, 2017 01-01-2017 Sunday, January 01, 2017

Correct Answer: 01-01-2017

3) Which function returns true if the expression is a valid date, otherwise it returns false in VBA?

CDate() IsDate() Day() Dateadd()

Correct Answer: IsDate()

4) What is the full form of UDF in VBA?

User Data Functions User Defined Functions Undefined Functions Used Data Functions

Correct Answer: User Defined Functions

5) Which function returns the day of the month (number from 1 to 31) given date value in VBA?

Day() Date() Month() Date part()

Correct Answer: Day()

Previous Question Set Back to Question Sets Next Question Set

Try Another Topic

Try Another Quiz