Gce Model Questions Vol1 2020 Computer Studies Question 11
Practice objective / multiple choice question 11 from the 2020 Gce Model Questions Vol1 Computer Studies examination.
In a spreadsheet, cells A1 through A5 contain the numbers 12, 15, 9, 20 and 8 respectively. Cell B1 has the formula =IF(A1>10, A1*0.9, A1*1.1) and this formula is copied down to B5. Cell C1 contains the formula =SUM($B$1:B1) and is copied down to C5. What value is displayed in cell C5 after the copying is complete?
Answer Options
About This Question
This is Gce Model Questions Vol1 2020 Computer Studies Question 11. It is one of the objective questions from the 2020 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.