www.ThinkITI.com

Home
MCQ
Search
Free Apps
Important
Study Groups
Contact Us
Policy

Home
MCQ
Objective Questions
ITI
COPA
COPA Set-1
Programming with VBA
8

Programming with VBA MCQ with Answers

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

CDate()

IsDate()

Day()

Dateadd()

Answer is:

IsDate()

Programming with VBA MCQ with Answers

For more MCQ's Click Here

Related Programming with VBA MCQ with Answers

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

User Data Functions

User Defined Functions

Undefined Functions

Used Data Functions

Answer is:

User Defined Functions

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

Day()

Date()

Month()

Date part()

Answer is:

Day()

11) Which function returns the current system date and time in VBA?

Date()

Day()

Hour()

Now()

Answer is:

Now()

12) Which function extracts the first 5 characters from a string in VBA?

Right(str,5)

Left(str,5)

Mid(str,5)

Substr(str,5)

Answer is:

Left(str,5)

Programming with VBA MCQ with Answers

For more MCQ's Click Here