City Guilds Model Questions Vol1 2019 Information Technology Question 40
Practice objective / multiple choice question 40 from the 2019 City Guilds Model Questions Vol1 Information Technology examination.
In a spreadsheet, cells A1:A5 contain the numbers 2, 4, 6, 8, 10 respectively. Cell D1 defines a named constant X with the formula \( \text{D1}= \text{IF}( \text{SUM}(B1:B5) > 120,\; 5,\; \text{IF}( \text{SUM}(B1:B5) < 60,\; 1,\; \text{SUM}(B1:B5)/30 + 0.5 ) ) \) and cells B1:B5 each contain the formula \( B_i = A_i \times X \). The spreadsheet uses iterative calculation with a maximum of 100 iterations and a convergence tolerance of 0.001, starting with X = 3. Determine the final value of X after convergence, rounded to three decimal places.
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2019 Information Technology Question 40. It is one of the objective questions from the 2019 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.