Cell Reference: Allows you to refer to data from another cell in the worksheet. . From the Excel Simulation below, if in a bla was entered, the formula would output the result from cell B7, or 400,000 in this example . Absolute Reference: Allows you to maintain the original cell reference when a formula is copied to another cell. The cell reference is locked by putting a dollar sign (S) before the column and row references. By default a cell reference is re formula to another cell the values update based on a relative reference. For example. if you copy the formula -88-89 from cell Ci to cell C2, the formula in cell C2 will relatively update to be B9+B10" since the copied formula moved down one ceil, the formul references also moved down one cell. Conversely, by adding the absolute cell reference "locks" to the equation, the formula will not change when copied to any other cell. For example,-$8$8$B$9" written in cell C1 is copied to cell C2, the formula in cell C2 remain -$8$8+$8$9 specific column or row and the other reference becomes a relative reference and "moves" with the for For example, if you copy the formula B$8+89" from cell C1 to cell C2, the formula in cell C2 will update to be" 8$8+810" since the copied formula moved down one cell, the formula cell relative references also moved down one cell, but the absolute "locked"r remained the same so when you copy a You can also use a mixed cell reference by only "locking" the column or row only ($88 or B$8) which locks that mula as its copied to another Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following k iplus sign to add), (minus sign to subtract). (asterisk sign to multiply), and / (forward slash to divide). Fro in a blank cell -818+819" was entered, the formula would add the values from those cells and output the result, example. If using the other math symbols the result would output an appropriate answer for its function. m the Excel Simulation below, if or 250,000 in this SUM function: Allows you to refer to multiple cells and adds all the values. Yo tion. From the Excel Simulation below, if in a blank cell -SUM(8138 u can add individual cell references or ranges to utilize this B14.815)" was entered, the formula would output the result of adding those three separate cells, or 375,000 in this example. Similarly, if in a blank cel SUM(813:815) output the same result of adding those cells, except they are expressed as a range in the formula, and the r example esult would be 375,000 in this