Lesson#1 What are Macros?

Question 1

What is a Macro?

Answer 1

A small computer program i.e. Procedure

Question 2

What are the 2 types of Procedure?

Answer 2

Sub Procedures and Function Procedures

Question 3

What is a Sub Procedure?

Answer 3

A procedure which performs a specific task but won’t return values.

Question 4

What is a Function Procedure?

Answer 4

A procedure which carries out certain calculations and returns a value.

Question 5

What is the structure of a Sub Procedure?

Answer 5

Sub ProcedureName()
Statements
End Sub

Question 6

What are the basic instructions for naming a Procedure?

Answer 6

• Combination of letters and numbers.
• Ensure first character is a letter.
• Don’t use spaces.