Excel 2016 Introduction

Lesson - Working with Columns and Rows

Excel 2016

E XERCISE

W ORKING WITH C OLUMNS AND R OWS



T ASK Work with columns and rows.

1. Open Region08.xlsx . 2. Select columns B through E . Change the width to 8.00 . 3. Select rows 2 through 7 . Change the height to 14.25 . 4. Select column F . Use the AutoFit feature to make the column wide enough to display the text in cell F1 . AutoFit column I as well. 5. Select columns B through E and hide them. 6. Unhide columns B through E . 7. Insert a blank column before column I . 8. Insert three blank rows at the top of the worksheet. 9. Use the Insert Options list to format the new rows the same as the row below. 10. Type Worldwide Sporting Goods into cell A1 , and type Regional Sales into cell A2 . 11. Insert two blank rows before row 10 . 12. Delete the blank row 10 and the blank column I . 13. Close the workbook without saving it.

Page 146

OFFICEPRO, Inc.