WorksheetsCI Quiz : Everyday VBA
Total questions: 10
Worksheet time: 3mins
Which format shoul be used when saving file with macros?
.xlsx
.xlsm
.html
Which shortcut will open Visual Basic Editor?
Alt + F11
Ctrl + Alt + Del
Shift + F8
Shift + Del
VBA code can work only with excel.
TRUE
FALSE
If you record a macro, where it will be stored?
In Sharepoint
In Workbook
In Module
An action or set of actions that you can run as many times as you want.
When you create a _____ , you are recording your mouse clicks and keystrokes.
vlookup
match index
sumif
macro
This is where the code that is generated with a macro recorder goes.
Code Window
Module
User Form
Contains a set of commands the code should execute.
Commands
Sub Procedure
Reference
Which word is used to declare a variable?
Dim
Sub
Set
File with macros should be save in .xlsx format.
True
False
VBA stands for
Visual Basic and Application
Visual Basic for Application
Visual Basic or Application
Visual Basic to Application
