Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

E XERCISE

U SING B ASIC W ORKBOOK S KILLS



T ASK Use basic workbook skills.

1. Create a new workbook. 2. Use the keyboard to move the active cell around the worksheet. 3. Use the mouse to move the active cell and to scroll the worksheet vertically and horizontally. 4. Use the Go To dialog box to select cell M90 . Then, return to cell A1 . 5. Enter the text and numbers shown in the following table:

A

B

1

Region

2

Northern

50986

3

Southern

45284

4

Central

42436

5

Western

39675

6

Midwest

6. Delete the entry in cell A6 . 7. Select cell A1 . 8. Using the keyboard, display the KeyTips for the commands on the Home tab. 9. Using KeyTips , format the selected cell to Bold . 10. Save the workbook to the student data folder with the name Region . 11. Close the workbook. 12. Open REGSALES.xlsx . 13. Use the AutoComplete feature to enter the name Jones, P. in cell B9 . 14. Use the Pick From Drop-down List feature in cell B10 to enter the name Banes, M. . 15. Edit cell C6 ; change the value from 3952.68 to 3932.68 . 16. Enter the number 43567.50 in cell C9 . Note: Notice that the ending zero (0) is dropped. 17. Enter the number 33500.7 in cell C10 . 18. Create a new folder named Regions under the student data folder and save the workbook to the Regions folder with the new name REGSALES1.xlsx . Then, close the workbook.

Page 78

OFFICEPRO, Inc.