Click Cell to Add to a Formula
It appears that you can't just click a cell to add it to a formula. This is one of the most critical basic functions of spreadsheets. I created a simple formula =3+A2, but if I simply enter =3+ (then try to click on cell A2 to add it to the formula), it doesn't add A2 automatically and I get an Invalid error.
Without this ability it takes 3x to 5x longer to create a complex formula.
creativeinfluence