What allows for automatic updates or insertions of records in workbooks?

• A. Manual data entry
• B. Macro-based imports
• C. Worksheet created for updates
• D. External database connections

Answer: (C)

The correct answer hinges on the capability of integrating external data within a workbook seamlessly. Automatic updates or insertions of records in workbooks are primarily facilitated by external database connections. This feature allows the workbook to link directly to a data source, enabling real-time updates or automatic imports whenever there are changes made in the external database. The connection ensures that any modifications in the database reflect immediately in the workbook without requiring manual input or the execution of macros.

While options like manual data entry and macro-based imports involve human intervention or programmed actions respectively, they do not provide the automation that external connections offer. A worksheet specifically created for updates focuses more on organization and layout rather than functionality, making it less relevant for automatic updates. Thus, relying on external database connections constitutes the most effective method for achieving the necessary automation in record updates within workbooks.