Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

CI Quiz : Everyday VBA

Total questions: 10

Worksheet time: 3mins

Name
Class
Date
1.

Which format shoul be used when saving file with macros?

a)

.xlsx

b)

.xlsm

c)

.html

d)

.pdf

2.

Which shortcut will open Visual Basic Editor?

a)

Alt + F11

b)

Ctrl + Alt + Del

c)

Shift + F8

d)

Shift + Del

3.

VBA code can work only with excel.

a)

TRUE

b)

FALSE

4.

If you record a macro, where it will be stored?

a)

In Sharepoint

b)

In Workbook

c)

In Module

5.

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.

a)

vlookup

b)

match index

c)

sumif

d)

macro

6.

This is where the code that is generated with a macro recorder goes.

a)

Code Window

b)

Module

c)

User Form

7.

Contains a set of commands the code should execute.

a)

Commands

b)

Sub Procedure

c)

Reference

8.

Which word is used to declare a variable?

a)

Dim

b)

Sub

c)

Set

9.

File with macros should be save in .xlsx format.

a)

True

b)

False

10.

VBA stands for

a)

Visual Basic and Application

b)

Visual Basic for Application

c)

Visual Basic or Application

d)

Visual Basic to Application