Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please I need help with this question, I don't know how to solve it. F M 18 A D E G H 1 J KL
Please I need help with this question, I don't know how to solve it.
F M 18 A D E G H 1 J KL 1. Click on the "SLN" tab and enter your name in Cell C1. If Cell C1 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 A1 and B4, the formula is =A1+B4 8 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 9 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4 10 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 11 12 Using the SLN function 13 The SLN 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 purchasing 2 boxes of cereal at a cost of $3.95 per box, the formula in cell B28 is =B26*B27. Although we read cell B28 as "Multiply 2 boxes by $3.95", Excel is actually calculating 19 the value in cell B28 as "Multiply the value in the cell in the same column (column B) 2 rows above (row 26) by the 20 value in the cell in the same column 1 row above (row.271 21 22 Boxes of cereal 2 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 B28 to C28, Excel will assume 27 relative references. The formula in cell C28 will become =C26*C27. Since Cell C27 is blank, the formula will return a 28 value of $0 (which is an excellent deal for 6 boxes of cereal, but it isn't accurate!) Adding a $sign before the column 29 or row reference locks the formula to a specific location. 31 If we modify the formula in cell B28 to =B26*$B$27 before we copy the formula, Excel will not change the row or the 32 column of the second variable. When the formula is copied to columns C through E, the formulas become: 33 34 Cell C28 =C26*$B$27 35 Cell D28 =D26 $B$27 36 Cell E28 =E26*$B$27 37 38 Sometimes, you will want the column to stay fixed, but allow the row to remain relative when it's copied. If so, add a 39 dollar sign before the column, but not the row (i.e.$B27) If you want the row to stay fixed, but allow the column to 40 remain relative when it's copied, add a dollar sign before the row, but not the column (i.e. B$27). Tapping the F4 button 41 while entering the formula (or in the formula bar) toggles among the 3 absolute options (Absolute Column and Absolute 42 Row $B$28, Absolute Column and Relative Row $B28, Relative Column and Absolute Row B$28) 43 44 6 11 15 30 H A B C D E F G 1 Name: Rab Your score: 0% 2 On January 1 of the current year, the Rab Company purchased office machinery for $139,000. The office 3 machinery has an estimated useful life of 5 years and an estimated salvage value of $4,000. Complete the 4 depreciation schedule below. 5 Each formula in column D must include the SLN function. 6 7 Cost $139,000 8 Salvage $4,000 9 Life (in years) 5 10 11 12 January 1 book Depreciation Accumulated December 31 13 Year value Expense Depreciation book value 14 1 15 2 16 3 17 4 18 5 19 20 21Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started