PROGRAMMING WITH VBA - Quiz

1) What is the storage size of decimal data type in VBA?

2 bytes 4 bytes 8 bytes 12 bytes

2) What is the storage size of currency data type in VBA?

2 bytes 4 bytes 8 bytes 12 bytes

3) How many numeric data types available in Excel VBA?

4 5 7 8

4) What is the another name for keywords in VBA?

Literals Variables User defined words Reserved words

5) Which key word is used to declare the variable in VBA?

Sub Declare Dim AS