Excel VBA Regulatory Frameworks & Compliance 4

Question 1

A VBA workbook is used in GxP (Good Practice) pharmaceutical manufacturing. Which version control practice is required?

Accepted Answer

Maintaining a numbered version history with change descriptions, author, date, and approval status in a controlled log

Answer

GxP regulations require documented version control with change descriptions and approvals to ensure validated systems remain in a known, controlled state.

Question 2

Under the EU AI Act's transparency requirements, a VBA tool that uses AI-generated risk scores to make lending decisions must:

Accepted Answer

Inform users that AI is being used to generate scores and provide an explanation of the key factors

Answer

The EU AI Act requires transparency about AI use in high-risk applications, including informing affected persons and explaining AI decision factors.

Question 3

A VBA solution must comply with NERC CIP-007 (Systems Security Management) for a utility company. Which control applies?

Accepted Answer

Implementing VBA-enforced session timeouts that lock the workbook after a defined period of inactivity

Answer

NERC CIP-007 requires session management controls for systems accessing BES Cyber Systems, including automatic session termination after inactivity.

Question 4

Which VBA technique supports GDPR Article 25 (Data Protection by Design and by Default)?

Accepted Answer

Designing the data entry form to collect only the minimum personal data fields required and defaulting optional fields to empty

Answer

GDPR Article 25 requires that only necessary personal data is collected by default; VBA forms should be designed to minimize data collection from the start.

Question 5

A VBA macro automates fund transfer calculations for a money services business regulated under FinCEN. Which compliance feature is essential?

Accepted Answer

Flagging and logging any transaction at or above $10,000 for potential Currency Transaction Report (CTR) filing

Answer

FinCEN requires Currency Transaction Reports for cash transactions of $10,000 or more; VBA must flag these automatically to support BSA compliance.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Regulatory Frameworks & Compliance 4