wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Macro

Total questions: 10

Worksheet time: 3mins

Name
Class
Date
1.

It is used to illustrate a language’s basic syntax

a)

Hello

b)

msgbox

c)

Hello World

d)

Hello Universe

2.

A pointer or logical reference to a location in memory where a piece of data is stored

a)

ClearContents

b)

Dim

c)

Data Type

d)

Variable

3.

Which one is NOT a valid Variable name?

a)

Wow_Variable

b)

12Variable

c)

VariableX

d)

Y

4.

Attribute of data which tells the compiler or interpreter how the programmer intends to use the data.

a)

Data Type

b)

Variable

c)

Int

d)

String

5.

Non-Numeric data type that uses True or False.

a)

Object

b)

String

c)

Date

d)

Boolean

6.

Types of Procedures

a)

Module

b)

Sub

c)

Function

d)

Form

7.

Usually refers to a single cell at a time.

a)

Byte

b)

Dim

c)

Cell

d)

Range

8.

An automated input sequence that imitates keystrokes or mouse actions.

a)

Macro

b)

Micro

c)

VBA

d)

Microsoft Excel

9.

File format for macro enabled excel file.

a)

.doc

b)

.xlsx

c)

.xlsb

d)

.xlsm

10.

Function Key to run all lines of code of a Sub Procedure in VBA IDE.

a)

F4

b)

F5

c)

F6

d)

F7