What are named ranges used for?

1. To limit the values which can be entered in a sheet
2. To verify the range of the values entered in a selected part of the sheet
3. To give a custom name to a part of a sheet in a workbook
4. none of the above.

 

How to participate:

  • Answer the above question and providing your email address along.
  • Only the answer provided with email address will be marked.
  • Only the first correct answer will be considered.
  • For further details kindly refer to the Competition Rules and Guidelines.