Exam 77-420 Microsoft Excel 2013 1. Create and Manage Worksheets and Workbooks 1.2 Navigate Through Worksheets and Workbooks: Use the Name Box

Another Way to Name a Range You can use the Name Box to select and name a Range. Here are the steps.   4. Try This: Define a Named Range The sample spreadsheet is open. Go to the Original Data sheet. Place your cursor in the Name Box. Type: D1:D70 Hit the ENTER key on your keyboard. The data in Column D should be selected.   5. Try This, Too: Name a Range Place your cursor in the Name Box. Type: QuantitySold Hit the ENTER key on your keyboard.   What Do You See? The QuantitySold should be in the Name Box.   Keep going...