50.1K

Verified Solution

Link Copied!

amming a M - G 1 Click on the tab and enter your name in cel al felis et 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 5 The basic mathematical operators are and 100000 7 Rodition to add the values in cells Aland 4 the formula is 1.84 10000 3 Subtraction. To subtract the value in cell 04 from the value in cel A1, the formula 104 5 5 Multiplication: To multiply the values in cells Aland B4, the form is 1 10 Dision To divide the value in cel A1 by the wave in cel B4, the formula 41/4 11 12 Using the function $40,000 13 The function has the following tax SUN COST SALVAGELIFE PERIOD FACTOR 14 Each variable may be either a valor a formula that returns avale 15 The final variable factor, is the depreciation rate. If omitted this presumed to be double declining balance 16 Using about addresses 17 Once a formula is created, you willen want to copy the formula to other columns and rows. It's important to understand that excel always es relative 18 addresses unless you indicate otherwise by creating an absolute address for example, you are calculating the cost of purchasing2 boxes of ceralata cost of $3.95 per box the formula in cell 828126*827. Although we readcel 28 a: Multiply 2 boxes by $3.95", Excel is actually calculating the value in cell 028 as Multiply the value in the cell in the same column column 2 rows above frow 26) by the value in the cell in the same column I row above trow 20" 21 22 Boxes of cereal 2 6 11 23 Price per bo $3.99 24 Total cost $7.90 $23.70 $63.45 $9935 25 26. This works just fine to calculate the cost of 2 but if we copy the formula in cell 021 to C. Del wil me relative references. The formula in cele wil become sca). Since Gall C7 is blank, the formula will return value of which han excelent deal for boor but accuratel) 28 Adding Son before the color row reference locks the formula to specific location 29 30 11 if we modify the formule in 28 to 12658527before we cow the formulate will not change the rower the column of the cond war when the 1 15 DOO Please enter your name in cell C1. Cost Salvage Life (in years) $0 $0 0

Answer & Explanation Solved by verified expert

See Answer