What can occur when records are deleted from a worksheet?

• A. Records in a reference table may also be deleted
• B. The worksheet may become corrupted
• C. An automatic backup is created
• D. Other users are notified of the change

Answer: (A)

When records are deleted from a worksheet, this action can directly impact any reference tables associated with those records. If the worksheet relies on reference tables for data integrity or lookups, deleting a record from the worksheet may lead to inconsistencies or gaps in the reference table. This is especially true if the reference table is linked or relationally connected to the worksheets, as removing a record can eliminate important contextual information that the reference table requires to function properly.

Therefore, it's crucial to understand that maintaining the integrity of both the worksheet and its reference tables is essential to avoid data loss and errors in analysis when records are deleted.