Latest:
LinkedIn Microsoft Excel Certification 

If a range name is used in a formula and the name is deleted, what happens to the formula?

Editorial Staff
  • The formula display a warning but the actual cell address is substituted for the deleted name.
  • The formula becomes invalid and displays a #NAME? error.
  • The actual cell addresses replace the original range name in the formula.
  • The formula becomes invalid and displays a #N/A error

The correct answer is:

  • The formula becomes invalid and displays a #NAME? error.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers

You May Also Like

To calculate gross pay, hours are multiplied by the hourly rate. What formula would you put in cell C4 to then able to copy that cell down to the rest of the column

Editorial Staff 0

Which VLOOKUP function, when entered into cell L2 and then dragged to cell L5, returns the average number of calls for the representative IDs listed in column J?

Editorial Staff 0

How many columns in Excel sheet by default ?

Certificate Land 0