Excel 2016 Introduction

Excel 2016

Lesson – Working with Ranges

E XERCISE

W ORKING WITH R ANGES



T ASK Select and work with ranges.

1. Open Region02.xlsx . 2. Use the keyboard to select B5:B8 . 3. Use the mouse to select A5:C8 . 4. Select the following non-adjacent ranges: A5:A8 and C5:C8 . 5. Select the range D5:E8 and enter the numerical data in the following table into the selected range: D E

5

53875

57234

6

47122

48463

7

47383

49872

8

42348

45832

6. Type the text Qtr 1 in cell B4 . 7. Use the fill handle to create a quarter label series in the range B4:E4 . 8. Click anywhere in the workbook to deselect the cells. 9. Close the workbook without saving it.

Completed Exercise

OFFICEPRO, Inc.

Page 95