Question

What are the steps to be followed for naming cells and ranges.

Answer 1

Step 1 – Select the cells or ranges that are to be named. 

Step 2 – Select Dene Range from the Data menu Data. 

Step 3 – This will display a dialogue box us “Dene Database Range”. It will provide a place to enter “Name”. 

Step 4 – Click OK on the dialogue box.