When you open up Excel, you'll see a large grid on the screen. The rows are numbered, and the columns are lettered. You can type words and numbers directly into these boxes. If you click on the "=" button, you can also type in formulas.
Here's the cool thing: Instead of numbers, you can type in the location of other boxes. Let's say you go over to A3 and type "=A1+A2." Now if you type numbers into A1 and A2, the total will be shown in A3. If you change the values of A1 or A2, A3 will recalculate automatically. If you refer back to a box with a formula, it will get the result. For example, if you typed "=A3*2," you will get the value of A3 (A1 + A2) times 2. If you put 5's into A1 and A2, your spreadsheet would look like this:
Excel reads the spreadsheet left to right and top to bottom, so the formula must always come after the figures it uses. For example, you could not enter "=A2+B1" into A1.
Text can be typed into these boxes as well, making it easy to label your inputs and formulas.
Posted 3370 day ago