Excel Terminology

Edit Mode is activated when editing a formula.  Editing may be commenced by selecting a cell and then pressing F2 the edit shortcut, double-clicking the cell (if editing in cells is on) or clicking in the formula bar..  While in Edit Mode, any cursor movement keystrokes will move the insertion cursor within the expression or value being entered, and the selection keystrokes select one or more characters or 'words' in the value or expression.  [click the link to see a screenshot of the Edit Mode flag]

End Mode is activated or cancelled by pressing the End key, providing legacy support for range selection, as used in DOS spreadsheets.  When End Mode is set, the action taken depends upon the next key pressed..  [click the link to learn more and see a screenshot of the End Mode flag]

Enter Mode is activated when entering a value or expression in a cell.  While in Enter Mode, any cursor movement keystrokes will trigger Point Mode, allowing the user to select a range or ranges into the expression.  [click the link to see a screenshot of the Enter Mode flag]

Extend Selection Mode is activated when pointing in a reference, and either the F8 Extend Selection shortcut is pressed or the : (colon) character is pressed after pointing to a range..  While in Extend Selection Mode, pressing keys that move the active cell will change the address of the second reference n the range, extending or shrinking the referenced range, diagonally opposite the active cell..  [click the link to see a screenshot of the Extend Selection Mode flag]