Gce Model Questions Vol1 2017 Computer Studies Question 28
Practice objective / multiple choice question 28 from the 2017 Gce Model Questions Vol1 Computer Studies examination.
In a spreadsheet, cells A1 through A5 contain the numbers 2, 5, 8, 11, 14. Cell C1 holds the constant 3. In cell B1 the formula `=SUM(A1:A5)*C$1` is entered and then copied down to cells B2 through B5 using the fill‑down command. After the formula is copied, the values in column A are changed to 3, 6, 9, 12, 15 (i.e., A1=3, A2=6, …, A5=15). What value will appear in cell B3?
Answer Options
About This Question
This is Gce Model Questions Vol1 2017 Computer Studies Question 28. It is one of the objective questions from the 2017 Gce Model Questions Vol1 Computer Studies examination.
Difficulty level: Hard .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.