Anatomy of Word: Taking Word tables to the next level
Columns get letters and rows get numbers
More complex Word formulas
So far, you've seen some simple Word formulas such as =SUM(LEFT), which adds p the values in the cells to the left of the formula. But, what if you want to perform a somewhat more complex or granular calculation, such as multiplying two of the numbers in your table, or including just specific cells in a calculation? Word has you covered.
Recall how Excel names cells. The column letter and the row number are concatenated to form a cell reference such as A4 or B6. Excel even provides you with a nice grid to help you keep track of where you are. Word uses the same cell naming scheme, but does not provide you with the nice grid, so you have to do a little counting and reciting of the alphabet. Above gives you a look at how cells are named.
Using these cell references instead of a word like ABOVE and LEFT allows you to avoid problems like the one I showed you in the previous gallery, and allows you to perform direct calculations on values in your table.
So far, you've seen some simple Word formulas such as =SUM(LEFT), which adds p the values in the cells to the left of the formula. But, what if you want to perform a somewhat more complex or granular calculation, such as multiplying two of the numbers in your table, or including just specific cells in a calculation? Word has you covered.
Recall how Excel names cells. The column letter and the row number are concatenated to form a cell reference such as A4 or B6. Excel even provides you with a nice grid to help you keep track of where you are. Word uses the same cell naming scheme, but does not provide you with the nice grid, so you have to do a little counting and reciting of the alphabet. Above gives you a look at how cells are named.
Using these cell references instead of a word like ABOVE and LEFT allows you to avoid problems like the one I showed you in the previous gallery, and allows you to perform direct calculations on values in your table.
