Question 1 : What is a way to code a random number between 0 and 1 in VBA?WorksheetFunction.Rand()
Question 2 : You want to write "Month" to cell A1. What code will do this?Range("A2").Value = "Month"
Range("A1") = Month
Cells(1,1) = "Month"
Cell(1,1) = "Month"
Question 3 : how do you correct this declaration? Dim items As StringDim items As Integer
Dim item As String
Dim item As Integer
Delete entire line
Question 4 : Which is the file extension that cannot be used for macro excel file ? *.XLSM
Question 5 : Which of these command is used to stop screen flickering ? *Application.HideScreen = True
Application.EnableEvents = False
Application.DisplayAlerts = False
Application.Screenupdating = False
Question 6 : Which of these is a datatype used to store the decimal numbers in variable ? *Double
Question 7 : Which of these command is used to take input from the user ? *Inputbox
Question 8 : Which of these is not a loop in VBA ? *Do While
If End If
Question 9 : Which of these command is to display message in a dialog box ? *ShowMsg
Question 10 : Which of these is correct declaration of macro ? *Sub Welcome
Question 11 : Which of these datatype is used in the variable declaration to store text data ? *String
Question 12 : Which of these keyword is used to declare variables ? *Declare
Question 13 : Which of these is used at module level to force declaration of all variables mandatory ? *Option Variable
Question 14 : Function procedure differs from Sub procedure in that Function procedure:refers to a set of programming instructions that performs some action.
is an information statement that you provide to VBA.
is a set of programming instructions that returns a single value.
is a code in a VBA module.
Question 15 : Which of the following structures is useful for decisions involving three or more options?For Next
Question 16 : Which of the following is most useful for executing VBA statements directly and for debugging your code?Properties Window
Question 17 : Which button helps us to debug our code in VBA?ctrl+F8
Question 18 : What will be the single line code if you want to show the value 1500 from range A5 to C6 and F12?=range("a5:c6","f12")=1500
Question 19 : What is the shortcut key to go to the VBA page?f10
Question 20 : What shortcut key will you use to get the all list of Macros?ctrl+F8
Time Over ..... Thank you for taking Quiz. To get result, please click on the GET RESULT button below
Enter Your name Here :
Enter Your Email Here :
Please Wait while we are generating your result ...