All of the Following Statements Are TRUE About VBA Procedures

question 5

Multiple Choice

All of the following statements are TRUE about VBA procedures EXCEPT:

• A)Function procedures are often used to create custom functions that can be entered in worksheet cells.
• B)You can have zero or hundreds of Sub procedures and functions written within a single module.
• C)If a Sub procedure is to run when a workbook opens or a worksheet becomes active, then it is typically stored in the workbook or worksheet object to take advantage of the Procedure menu at the top of the Code window.
• D)Three primary types of procedures are supported by VBA.

---

Definitions:

Written Analysis

The process of critically evaluating or discussing a subject in written form to understand its components or relationships.

Bins

Storage containers or categories used in data analysis for grouping data points, or in physical organization to sort items.

Measurement Values

Quantitative data obtained from measuring objects or events, used for analysis or comparison.

Frequency Distributions

A statistical analysis showing the number of instances in which a variable takes each of its possible values.