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

Formulas -> Define Name Define a Range The Name Box is a special tool in the top left corner by the Formula bar. You can use the Name Box to Define a Range, instead of selecting the Cells with your mouse.   2. Try This, Too: Define a Range Place your cursor in the Name Box. Type: E1:E70 Hit the ENTER key on your keyboard.   What Do You See? The RANGE from Cell E1 through Cell E70 are selected and highlighted.   Keep going, please...