Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.1 Insert Data In Cells and Ranges: Create Named Ranges

Name the Range 4. Try it: Create a Named Range Select the RANGE G1:K2. Go to Formulas->Defined Names. Click on Define Name.   What Do You See? Microsoft Excel will prompt you to enter the following information: Name: Terms Refers to: =Customers!$G$1:$K$2 Click OK.   Keep going...   Memo to Self: The Scope means this Defined Name is available to every sheet in this Excel workbook. You can limit the scope to one specific worksheet if you wish. Formulas->Defined Names->Define Name