Creating Formulas with Your Mouse


Instead of typing in each cell reference (in the form of A1, A2, and so on), you can simply use the mouse to point to the cell you want to refer to in your formula. For example, if you want to add the contents of cells A1 and B1, you can enter the following formula with your keyboard:

=A1+B1

Or you can use your mouse. In this instance, you'd start by moving the cursor to the cell where you want to put the answer. Use your keyboard to enter the = sign, then use your mouse to click on cell A1. Use the keyboard again to enter the + sign, then use your mouse again to click on cell B1. Press Enter on your keyboard to finish the formula.

You can also use your mouse to enter a range of cells. Let's say that you want to total all the numbers in the range of cells from A1 to A5. In this instance, you use the SUM function (which we'll discuss in due course), followed by the range; the formula looks like this:

=sum(A1:A5)

To enter this formula, start by entering the =sum( with your keyboard. Next, use your mouse to select the cells from A1 to A5. (Click the first cell, hold down the mouse button, and then drag to include all the cells in the range.) Finally, finish things up by entering the final ) with your keyboard, and press Enter.




Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net