Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

Steps

Practice Data

3. Press the appropriate key for the desired command. The desired command is applied or, if the command has options, the options are displayed in a menu or gallery. 4. Use the [Up] , [Down] , [Left] and [Right] keys, as necessary, to highlight the desired option. The selected option is highlighted.

Press [H]

Press the [Right] key five times to highlight Orange, Accent 2 (sixth color, first row)

5. Press [Enter] .

Press [Enter]

The selected option is applied.

6.

Close open file.

S CROLLING USING THE M OUSE  D ISCUSSION

You can use the mouse to select a different cell as the active cell. However, if the cell you wish to select is not currently visible you must first scroll the screen display to bring it into view. On larger worksheets, all the data may not fit on the screen display at once. The horizontal and vertical scroll bars allow you to scroll the display so that you can view other parts of the worksheet. Scrolling with the mouse does not change the location of the active cell. You change the location of the active cell by selecting the desired cell. Any commands executed affect the active cell, not necessarily the cells in the part of the worksheet you are viewing. For example, if you click in cell A1, scroll to view cell A50, and then press the [Delete] key, the contents of cell A1 will be deleted, not the contents of cell A50. There are three elements on a scroll bar that you can use to scroll the worksheet. The Scroll Arrows at the top and bottom of the vertical scroll bar and at the left and right ends of the horizontal scroll bar, scroll the worksheet up and down or left and right one row or column at a time with each click of the mouse on the relevant arrow. You can drag the Scroll Box (the white rectangle on the scroll bar that turns gray when you mouse over it) up and down or left and right, as appropriate, to scroll quickly within the area of the worksheet that has been used so far. The movement of the Scroll Box is proportional to the area that has been used. An indicator appears beside the scroll bar while you drag to show which row or column is currently at the top

Page 38

OFFICEPRO, Inc.