wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Basic VBA

Total questions: 10

Worksheet time: 3mins

Name
Class
Date
1.

It is similar to the Excel ribbon where you have tabs and options with each tab.

a)

Menu bar

b)

Tool Bar

c)

Project Explorer

d)

Module

2.

It gives you quick access to some of the useful options.

a)

Tool Bar

b)

Menu Bar

c)

VBA Ribbon

d)

Function Bar

3.

Shortcut Key for Project Explorer

a)

Ctrl + K

b)

Ctrl + L

c)

Ctrl + R

d)

Ctrl + P

4.

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

a)

Code Window

b)

Module

c)

Immediate window

d)

Properties Window

5.

This is where you’ll write your code or copy paste a code from somewhere else.

a)

Properties window

b)

Module

c)

Immediate Window

d)

Code window

6.

Properties window short cut key

a)

F6

b)

F4

c)

CTRL + P

d)

F8

7.

is mostly used when debugging code

a)

Properties Window

b)

Immediate window

c)

Code window

d)

Module

8.

Contains set of commands the code should execute

a)

Sub procedure

b)

Function Procedure

c)

Reference

d)

Commands

9.

Wrong code color is

a)

Black

b)

Blue

c)

Red

d)

Green

10.

an action or a 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)

VBA

b)

match index

c)

Macro

d)

Vlook up