City Guilds Model Questions Vol1 2020 Information Technology Question 28
Practice objective / multiple choice question 28 from the 2020 City Guilds Model Questions Vol1 Information Technology examination.
A company bought equipment that will be depreciated straight‑line over 5 years with no salvage value. In a spreadsheet, cell A2 holds the purchase price. Cell B2 contains the monthly depreciation expense calculated as \(=A2/60\) (because 5 years = 60 months). The first six months (cells B2-B7) show a depreciation of \(200\) each month. After month 6 the company changes the policy and records a depreciation of \(250\) per month for months 7-12 (cells B8-B13). Cell C13 contains the accumulated depreciation after 12 months, i.e. the sum of B2:B13. Given this information, determine the purchase price entered in A2.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2020 Information Technology Question 28. It is one of the objective questions from the 2020 City Guilds Model Questions Vol1 Information Technology examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.