City Guilds Model Questions Vol1 2023 Information Technology Question 35
Practice objective / multiple choice question 35 from the 2023 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet column \(A\) the cells \(A1\) to \(A5\) contain the numbers 3, 7, 12, 9 and 15 respectively. Column \(C\) uses the formula \(=IF(A1>10, A1-10, IF(A1<5, A1+5, A1))\) copied down to \(C5\). What is the median of the values that appear in cells \(C1\) to \(C5\)?
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2023 Information Technology Question 35. 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.