Excel VBA Regulatory Frameworks & Compliance 2

Question 1

Under SOX Section 302, what VBA practice best supports the CEO/CFO certification requirement for financial controls?

Accepted Answer

Maintaining a VBA audit log that records every financial cell modification with timestamp and user

Answer

SOX Section 302 requires executives to certify internal controls, so VBA audit logs documenting who changed what financial data and when directly support that certification.

Question 2

A VBA macro processes HIPAA-covered patient data. Which approach complies with the Minimum Necessary Standard?

Accepted Answer

Request only the specific fields needed for the current operation

Answer

HIPAA's Minimum Necessary Standard requires accessing only the PHI fields actually needed for the specific task, not entire records.

Question 3

Which VBA technique helps enforce PCI DSS Requirement 3.4 regarding rendering Primary Account Numbers (PANs) unreadable?

Accepted Answer

Using VBA to mask PANs by showing only the last four digits in the cell

Answer

PCI DSS Requirement 3.4 mandates rendering PANs unreadable wherever stored; VBA masking to show only the last four digits implements this standard.

Question 4

A GDPR compliance officer asks you to implement a 'right to erasure' workflow in Excel VBA. What should the macro do?

Accepted Answer

Locate all rows referencing the data subject's ID and permanently delete their personal data across all worksheets

Answer

GDPR's right to erasure (Article 17) requires complete removal of a data subject's personal data from all locations, not partial deletion or obfuscation.

Question 5

When building a VBA solution for a FINRA-regulated broker-dealer, which record retention practice is most compliant?

Accepted Answer

Using VBA to enforce read-only status on finalized reports and log any export or print action

Answer

FINRA Rule 4511 requires broker-dealers to preserve records in a non-alterable format; enforcing read-only status and logging access supports this requirement.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Regulatory Frameworks & Compliance 2