If a range name is used in a formula and the name is deleted, what happens to the formula?
The formula becomes invalid and displays a #N/A error
The formula display a warning but the actual cell address is substituted for the deleted name.
The actual cell addresses replace the original range name in the formula.
The formula becomes invalid and displays a #NAME? error.