Selecting cells for a formula:

 
We want to enter a formula in the cell A2 (1), and in this example, the formula = AVERAGE is used, in order to calculate the average of the cells B2, through H2.
To add cells B2 through H2, to the formula, it is preferable to select the cells with the mouse or the keyboard in order to avoid typing errors but, what if the formula gets in the way of our selected cells so that we can not click in cell B2 (2)?

After you typed = AVERAGE in cell B1 and clicked it (does not matter if there is data in it) press the down arrow once. Now, the cell B2 is selected so press the “Shift” key along with “Enter” in cell H2.

Awesome!
You've completed Tip 017
START NEXT LESSON