Search Header Logo

Macro Practice Questions

Authored by Maci Friedrich

Computers

University

Used 3+ times

Macro Practice Questions
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the Visual Basic command “ActiveWorkbook.Save”, ActiveWorkbook is a(n):

Property

Object

Method

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A macro that will run every time the file is opened is called a ____________ macro.

User-Defined Function

Public Macro

Private Macro

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The _______________ window in the Visual Basic Editor is where you access the modules containing public macros you have created.

Project Explorer Window

Code Window

Local Window

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A loop that will allow you to run a set of VBA statements over and over again until a specified condition is met is known as a:

For...Next Loop

Do...Loop

Repeat...Loop

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The first word in the first line of a public macro is:

Sub

Public

Macro

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What button do you click on to record a new macro?

New Macro Wizard

Create Macro

Record Macro

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What tab do we use in Excel to work with macros?

Developer

Creator

Macro

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?