G H M 1 click on the "SN tab and enter your name in Cella. If Cell Cl is left blank, you will not be able to see your score. 2 Each yellow cell requires a formula 3 The formula must only contain cell addresses. 4 Each correct formula will begin with, or 5 6 The basic mathematical operators are and/ 7 Addition to add the values in cells Al and B4, the formula is =A1184 8 Subtraction. To subtract the value in cell B4 from the value in cell A1, the formula is A1-84 9 Multiplication: To multiply the values in cells Al and B4, the formula is =A1*84 10 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/04 11 12 Using the SLN function 13 The Sun function has the following syntax SLN(COST,SALVAGE LIFE) 14 Each variable may be either a value or a formula that returns a value. 15 16 Using absolute addresses 17 Once a formula is created, you will often want to copy the formula to other columns and rows. It's important to understand that excel always uses relative addresses unless you indicate otherwise by creating an absolute address". For example, if you are calculating the cost of purchasing2 boxes of cerealata 18 cost of $3.95 per box, the formula in cell B2B s-B26*827. Although we readcell B28 as Multiply 2 boxes by $3.95", Excel is actually calculating the value in cell B28 as "Multiply the value in the cell in the same column (column B) 2 rows above trow 26) by the value in the cell in the same column 1 row above 19 20 row 27) 21 22 Boxes of cereal 2 6 11 15 23 Price per box $3.95 24 Total cost $7.90 $23.70 $43.45 $59.25 25 26 This works just fine to calculate the cost of 2 boxes, but if we copy the formula in cell 28 to 28, Excel will assume relative references. The formula in cell 27 28 will become C2607. Since Cell C27 s blank the formula will return value of So which is an excellent deal for 6 boxes of cereal, but it isn't accuratel) 28 Adding a se before the column or row reference locks the formula to a specific location 25+ 30 31 If we modify the formula in cell B28 to 26 SA$27 before we copy the formula, Excel will not change the row or the column of the second variable. When Instructions SIN Please enter your name in cell C1. 6 7 8 in 00 OSS Cost Salvage Life (in years) $0 $0 0 10 11 12 13 14 15 16 17 18 m0