CI Quiz : Everyday VBA

Which format shoul be used when saving file with macros?

• .xlsx

• .xlsm

• .html

• .pdf

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