Gce Model Questions Vol1 2024 Computer Studies Question 20
Practice objective / multiple choice question 20 from the 2024 Gce Model Questions Vol1 Computer Studies examination.
In a spreadsheet, cells A1 to A4 contain the numbers 120, 85, 95 and 110 respectively. Cell B1 has the formula =IF(AND(A1>=100, A1<=130), "Pass", "Fail") and this formula is copied down to B2:B4 using relative references. What values appear in cells B1 through B4?
Answer Options
About This Question
This is Gce Model Questions Vol1 2024 Computer Studies Question 20. It is one of the objective questions from the 2024 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.