19. When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?
A) Cell references are not affected.
B) The user must insert new cell references
C) The user is prompted to enter new cell references
D) Cell references are automatically adjusted

The cell reference is a connection to a cell or a group of cells on a sheet that can be used for calculation in Microsoft Excel Software, and further discussion can be defined as follows:

It calculates the result by reference to the values in the referenced cells.
If you update the value in a cell, the formula automatically adjusts the result.
Since its adjustment is relative to where you copy this formula.
When it doesn't want cell references that alter when you replicate the formula, consider these cell connections absolute cell references.

Therefore the final answer is "Option D"

Learn more:

brainly.com/question/13270273