Question

Open a worksheet and name the range containing the cells A1:B3 and A6:B8 as Red.

Answer 1

Step 1: Click on Formulas tab

Step 2: Click on Define Name

Step 3: Type "Red" in Enter a name for the data range

Step 4: Delete the entry in Select the range of cells

Step 5: Select the range A1:B3 and by holding Control key (or Command in mac) select A6:B8

Step 6: Click OK.

Now, your selected ranges are named Red.