COMP 5 - MODULE 6

This key moves the cell pointer on the first cell on the row

• Home

• Ctrl + Home

• Page Up

• Page Down

This key moves the cell pointer on the last cell that contains data.

• Home

• Ctrl + Home

• Ctrl + End

• Page Down

This key moves the cell pointer one cell to the left.

•  $\rightarrow$  
  

•  $\leftarrow$  

• Ctrl + Home

• Ctrl + End

It is used to indicate the active cell. This can be moved through the use of the mouse, the Name box, and the keyboard. 

• Cell pointer

• Cell address

• Panning

• Zooming

This allows you to move the display on the screen without moving the cell pointer. 

• Zooming

• Panning

• Cell address

• Cell pointer

It is located in the View tab and contains controls for changing the zoom level of the current view. 

• Zooming

• Zoom Group

• Panning

• Cell pointer

The default view that displays the worksheet as a grid of cells.

• Normal

• Page Layout

• Page Break Preview

• Full Screen View

The view that displays the worksheet organized into pages that allows you to adjust the positions of the page breaks.

• Normal

• Page Layout

• Page Break Preview

• Full Screen View

The view that hides all other interface components except for the worksheet area.

• Normal

• Page Layout

• Page Break Preview

• Full Screen View

A technique which allows the Excel user to reduce or enlarge the view of the worksheet displayed on the screen. 

• Zooming

• Panning

• Page Break Preview

• Full Screen View