What happens when a data modification deletes records in a worksheet?

When a data modification deletes records in a worksheet, all records displayed in that worksheet are indeed deleted. This means that the action applies to the entire set of data that is visible at that moment, rather than just a selective group or individuals.

The specific design and functionality of most data management systems imply that a bulk operation, such as deletion in a worksheet context, is meant to ensure that the user is modifying the displayed dataset. Therefore, if a delete command is issued, every record currently visible will be targeted for deletion, as it assumes the user's intention is to clear that data entirely rather than selectively.

The other options suggest scenarios that are not consistent with typical data handling processes; for instance, only deleting selected records implies a more manual operation which does not apply when general deletion actions are invoked, while archiving or requiring confirmation indicates additional steps that don't align with the direct deletion of all displayed records.