City Guilds Model Questions Vol1 2023 Information Technology Question 21
Practice objective / multiple choice question 21 from the 2023 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet, column A contains Quantity, column B contains Unit Price, column C contains Discount % (applied as a decimal), and column D calculates the Total using the formula \(=A5*B5*(1-C5)\). For row 5 the Quantity entered is 250. The Unit Price should be obtained from a VLOOKUP that returns \(8.75\), but it was mistakenly entered as \(9.25\). The Discount % is determined by an IF formula: if Quantity > 200 then 12 % else 5 %. The Total cell currently shows \(2035\). What should be the correct Total for row 5, and what is the discrepancy between the displayed Total and the correct Total?
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2023 Information Technology Question 21. It is one of the objective questions from the 2023 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.