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

Select a Range

By definition, a RANGE is a one or more cells on a spreadsheet. The cells may be adjacent or not. There are a couple of ways to select a Range of Cells.

 

Before You Begin: The sample spreadsheet, Counting Chickens 2013.xlsx should be open.

Go to the Original Data spreadsheet.

 

1. Try This: Select a Range with a Mouse

Select Cells E1:E70

(The last row with data in this example.)

 

Keep going...