PROGRAMMING WITH VBA - Quiz

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

2 3 4 7

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

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

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

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

User Data Functions User Defined Functions Undefined Functions Used Data 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()