Difficulty: Moderately Easy
Step1
Total a column of cells containing values by clicking on the first empty cell at the bottom of the column and clicking on the “Autosum” icon. This shortcut looks like the capital letter “E” on the toolbar at the top of your screen.
Step2
Copy a formula down all the rows below a cell using the mouse. Click on the cell that contains the formula to be copied and then hover the cursor over the bottom-right corner of that cell until the cursor turns into a little “+” symbol. Once this happens, hold the left mouse button down and drag the cursor to the desired number of rows you want in the formula.
Step3
Edit a formula by clicking on that cell and press the F2 function key. This will bring the cursor to the end of the formula. Use the arrow keys to navigate to where the editing needs to be done in that formula.
Step4
Create a formula faster and more accurately by clicking on cells instead of entering the cell names. Type an "=" (equal sign) in the cell where you want the result then enter the formula clicking on the cells involved. Press the Enter key when done and the result will be displayed in the cell with the formula.
Step5
Switch between absolute and reference formulas by clicking on the cell and pressing the F4 function key. Absolute formulas will always read from the same specific cell whenever the formula is copied to any other cell. Reference formulas will read from cells in the same relative location from where the formula is pasted.
Step6
View all the formulas you have in a particular spreadsheet by using Ctrl+`. (The second key is the grave accent key, which is usually located in the upper left-hand side of the keyboard.) Perform this command a second time to go back to the regular view.
