Question

5.
How will you define range name for a set of values in Excel?​

Answer 1

Answer:

Select the cell(s).

On the Formulas tab, in the Define Names group, click the Define Name button.

In the New Name dialog box, specify three things: In the Name box, type the range name. ...

Click OK to save the changes and close the dialog box.

Explanation: