City Guilds Model Questions Vol1 2024 Information Technology Question 7
Practice objective / multiple choice question 7 from the 2024 City Guilds Model Questions Vol1 Information Technology examination.
Cell \(B1\) contains the tax rate 0.075. Column \(A\) lists amounts for four items: 1200, 2500, 1800 and 3000. In cell \(C1\) the formula \(=A1*\$B\$1\) is entered and copied down to \(C4\). A student mistakenly used a relative reference to \(B1\) (i.e., wrote \(=A1*B1\)) before copying, so the tax‑rate column now contains 0.075, 0.080, 0.085 and 0.090 respectively (each row increased by 0.005). The total tax is summed in \(C5\) with \(=SUM(C1:C4)\). What is the difference between the erroneous total tax and the correct total tax?
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2024 Information Technology Question 7. It is one of the objective questions from the 2024 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.