City Guilds Model Questions Vol1 2025 Information Technology Question 23
Practice objective / multiple choice question 23 from the 2025 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet the following data and formulas are entered:\n\n- Cells \(A1\) to \(A4\) contain the quantities 4, 5, 6, 7 respectively.\n- Cells \(B1\) to \(B4\) contain the unit prices 10, 12, 9, 11 respectively.\n- Cell \(C1\) contains the formula \(=A1 \times B1\). Cells \(C2\) to \(C4\) are obtained by copying the formula in \(C1\) down the column.\n- Cell \(E1\) contains the constant discount factor 0.9.\n- Cell \(F1\) contains the formula \(=C1 \times \$E\$1\). Cells \(F2\) to \(F4\) are obtained by copying the formula in \(F1\) down the column.\n- Cell \(G1\) contains the formula \(=SUM(F1:F4)\).\n\nWhat numeric value is displayed in cell \(G1\) after all formulas are evaluated? (Give your answer to one decimal place.)
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2025 Information Technology Question 23. It is one of the objective questions from the 2025 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.