In cell B7, which SLN depreciation formula uses Cost, Salvage, and Life from B3?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $9.99Unlock all

Prepare for SIMnet Exam 1 with our comprehensive quiz. Access flashcards and multiple-choice questions with hints and explanations. Get ready to succeed!

Multiple Choice

In cell B7, which SLN depreciation formula uses Cost, Salvage, and Life from B3?

Explanation:
SLN computes straight-line depreciation from three values: cost, salvage value, and life. In this setup you want the life to come specifically from cell B3 and stay fixed when you copy the formula. Using an absolute reference to B3 ensures the life input remains the value in B3 no matter where the formula is copied. Therefore, =SLN(Cost, Salvage, $B$3) passes the correct cost and salvage (as defined names or cell references) and uses the Life value from B3 without changing. Using quoted text would pass strings instead of numbers, and using a non-absolute reference could change the life value if the formula is copied.

SLN computes straight-line depreciation from three values: cost, salvage value, and life. In this setup you want the life to come specifically from cell B3 and stay fixed when you copy the formula. Using an absolute reference to B3 ensures the life input remains the value in B3 no matter where the formula is copied. Therefore, =SLN(Cost, Salvage, $B$3) passes the correct cost and salvage (as defined names or cell references) and uses the Life value from B3 without changing. Using quoted text would pass strings instead of numbers, and using a non-absolute reference could change the life value if the formula is copied.

More Multiple Choice Questions
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy