Paper 5 — Final Mock

Marking Scheme

Section — Multiple Choice — Remember

Q1. (b) Private information goes to the grown-ups who look after you. Option (c) tempts people because classmates feel safe, but anything in a group chat can be screenshotted and forwarded to anybody. [1]

Q2. (b) Editor is the biggest role, so that person can change what you wrote. Option (a) describes Viewer, which is the smallest role and usually the safer choice. [1]

Q3. (a) Age, name and class are all typed in, and typing is free. Option (b) is a comfortable guess, but no game checks whether a player really is nine years old. [1]

Q4. (c) Delete only reaches copies you own. Option (d) is a common belief, but nothing quietly tidies away somebody else's picture for them. [1]

Q5. (c) Anaya went from bystander to upstander in about a minute. Option (a) is the trap — laughing once does not lock you in, and the sooner you switch the more it helps the target. [1]

Q6. (d) Every forward adds more people watching, so the hurt grows. Option (b) is the trap — reporting sends it to the app's own team, not to your friends. [1]

Q7. (a) Honest means crediting words and pictures you did not make. Option (c), being careful, is about asking before you post a photo with another person in it. [1]

Q8. (c) Autoplay picks the next video so that you never have to choose. Option (b) sounds close, but counting your time is a different tool that tells you nothing until you look. [1]

Q9. (b) Many different people cover ground no single person can. Option (a) is the classic mistake: one child adding eleven lines has given one opinion, not eleven. [1]

Q10. (a) Raw data is the material everything else is made from — useless on its own, but nothing is made without it. Option (c) is the mix-up, because the baked answer is the information, not the flour. [1]

Q11. (d) In December the Friday numbers slipped, and only the record that kept going noticed that games period had moved. Option (c) is the near-miss, because the point is not the daily habit but the proof that the fix still works. [1]

Q12. (d) C5 — the column letter always comes first, then the row number. Option (a) 5C is the classic mix-up, and Sheets will not accept it. [1]

Q13. (c) Text hugs the left. Option (d) is the trap: currency looks like letters and digits together, but it is still a number, so it lines up on the right. [1]

Q14. (a) Bold makes row 1 look different from the data below it. Option (c) zoom makes everything bigger together, so the heading still looks the same as the rest. [1]

Q15. (d) The words Player and Runs stay in row 1 instead of being sorted like scores. Option (a) is the trap, because sorting never changes how a table looks, only the order of its rows. [1]

Q16. (a) Hidden — the rows are still in the sheet, which is why the row numbers skip. Option (b) is the mistake this whole topic exists to prevent, because deleting cannot be undone later. [1]

Q17. (b) MAX gives back the biggest value in the range. Option (c) MIN is its opposite and gives the smallest, and swapping the two is the commonest slip. [1]

Q18. (d) A cell reference means whatever that box holds right now, so the answer updates by itself. Option (a) swaps the letter and the number around. [1]

Q19. (d) The four sweets are parts of one whole stall of 40 boxes, so the slices add up to 100%. Option (a) is exactly Anaya's mistake, because four days of takings are separate amounts and not shares of one thing. [1]

Q20. (c) Bar heights sit against a scale, so you can see the size of the gap. Option (d) is the near-miss: labels tell you the shares, but a pie still cannot show how much bigger one day was. [1]

Section — Multiple Choice — Understand & Apply

Q21. (a) It says what she did and nothing that could reach her. Option (d) looks harmless because no address appears, but a school plus a section narrows it to about thirty children in one building. [2]

Q22. (d) Restricted keeps the audience to the four she names, and Editor is the smallest role that still lets them add slides. Option (c) is the near-miss: Viewers can read the slides but cannot add anything. [2]

Q23. (c) Saying no costs nothing, and telling an adult early keeps the mess small. Option (a) is the clever-sounding trap — by the time she changes it, whoever collected the old one has already used it. [2]

Q24. (d) A screenshot is a second copy sitting in somebody else's post, so his delete button never reached it. Option (a) tempts people because deleting can feel slow, but his own copy went straight away. [2]

Q25. (d) Checking on the target and telling an adult are two of the four upstander moves. Option (a) feels safer than forwarding, but laughing still tells the bully the joke is working. [2]

Q26. (a) Another person's photo is not hers to post, so she asks and accepts the answer. Option (d) is the trap — editing a photo does not turn it into her own, and Kabir is still in it. [2]

Q27. (b) A timer set before he starts decides the ending while he is still deciding anything. Option (c) sounds sensible, but autoplay simply serves more short videos, so the hours are the same. [2]

Q28. (c) A crowd only works when it holds many different people, and Kabir is one person repeating himself. Option (d) is the near-miss: speed is a clue that something is wrong, but the real fault is the repeating. [2]

Q29. (c) 52 − 39 = 13, and a comparison tells the captain exactly how much to find. Option (a) is true but answers nothing on its own, so it is still just data. [2]

Q30. (b) Wednesday was 41 then 44, so about 43 is the sensible guess. Option (a) is the trap for anyone who reads across the wrong column — 20 and 21 are the Thursday numbers. [2]

Q31. (d) C3 — money sits in column C and chaat is in row 3. Option (a) B3 is the same row but holds the number of boxes, which is 11, not the rupees. [2]

Q32. (b) 570, because 150 + 180 + 240 = 570 and SUM skips the text in B3. Option (c) 790 is the money really collected, and the gap of ₹220 between the two totals is the bug. [2]

Q33. (a) A bold header stands out from the data, and right-aligned prices stack digit under digit. Option (b) changes every row equally, so the header still looks the same as everything else. [2]

Q34. (c) Largest first gives Meera 7, Sara 6, Kabir 5, Ishan 3, Priya 2, so Kabir is third. Option (a) Meera is the trap for anyone who counts the rows in the old order instead of the sorted one. [2]

Q35. (d) The numbers move while the names stay still, so every player is shown with somebody else's score. Option (a) is the comforting wrong answer — Sheets does not stop you, which is why this slips past. [2]

Q36. (a) 17, from 9 + 6 + 2 in the three Class 4 rows. Option (b) 14 is the total of the hidden rows, 7 + 4 + 3, and option (c) 31 is the whole list, because filtering hides rows without removing them. [2]

Q37. (c) 1490. Working: 260 + 340 = 600, + 195 = 795, + 410 = 1205, + 285 = 1490. Option (b) 1205 is the total if you stop at Thursday and forget the last row. [2]

Q38. (a) 195 is the smallest and 410 the largest. Option (b) has the right two numbers the wrong way round, which is what happens when MIN and MAX get swapped. [2]

Q39. (c) D4 reads the new price and gives 30 × 6 = 180, while the typed =30*5 knows nothing about cell C4 and stays at 150. Option (a) is the tempting guess that Sheets updates every cell, but typed numbers never change. [2]

Q40. (d) A bar chart compares separate amounts, and 860 − 520 = ₹340. The ₹1,380 in (a) and (b) comes from adding the two days instead of subtracting, which answers a different question. [2]

Section — Multiple Choice — Think & Decide

Q41. (a) The test is whether someone could use it to reach you or log in as you. A first name passes that test on its own, but sitting next to a school name it narrows to one child in one building, which is why it is the hard one. Option (c) is a real position children hold, but a parent's number reaches the child just as surely; (d) is true and is exactly why favourite bowler was easy, not hard. Marking guidance: Tests whether the child sees that safe pieces can add up to a private one, rather than sorting each item on its own. [3]

Q42. (b) The smallest audience and the smallest role that still does the job, and the honest cost is the naming. Option (a) is genuinely tempting and does protect the slides, but a link can be forwarded for ever, so you give up knowing who holds it. Option (c) keeps strangers out yet leaves thirty families able to delete a slide, which is the very thing to prevent. Marking guidance: Tests whether the child weighs a real cost against a real protection instead of picking the tightest or the easiest setting. [3]

Q43. (b) The difference is what the answer would let someone do. A favourite bowler names nobody; a card carrying a full name, a school and a photo names one child. Option (a) is a real instinct but tone is not the danger, and a polite request for an ID is just as unsafe. Option (d) sounds fair, but anything he sends back cannot be checked, so swapping proves nothing. Marking guidance: Tests whether the child judges a request by what it would reveal, not by how it is worded. [3]

Q44. (c) The words he typed are the questions he could not answer, and the login times show which days he is in the lab and how late he is awake. Option (b) is the position Kabir himself holds — passive means recorded without asking, not harmless. Option (a) describes his active footprint, which is the half he does control. Marking guidance: Tests whether the child can tie each passive trace to something specific a reader could work out. [3]

Q45. (b) The joke existed only because he made it, and the moment he pressed send it became a copy he no longer owned; the size of the crowd, though, really was his friend's choice. Option (c) is the over-harsh version that ignores who pressed forward, and (d) rests on the delete button reaching copies it cannot reach. Marking guidance: Tests whether the child can split what Rohan is responsible for from what he is not, instead of judging him wholly guilty or wholly innocent. [3]

Q46. (c) Permission decides the shape of the credit, but it never deletes the credit. 'Photo used with permission' or Meera's initials satisfy both rules, and if she refuses every version, the photo goes. Option (b) is a real position — a rule is a rule — but Meera is the maker and the subject at once, so her no counts; (a) solves the clash by quietly dropping honesty. Marking guidance: Tests whether the child keeps some honest credit while respecting a no, rather than sacrificing one rule to the other. [3]

Q47. (d) The total is 400 (30+25=55, +40=95, +20=115, +130=245, +110=355, +45=400) against 7 x 60 = 420, so the arithmetic passes and the claim still fails: Friday's 130 and Saturday's 110 are each more than double the daily rule, and a weekly total hides them. Option (b) is the near-miss from allowing only six days, 6 x 60 = 360. Marking guidance: Tests whether the child can pass the arithmetic and still judge the week, seeing that a total can hide two heavy days. [3]

Q48. (a) A crowd only reports where the crowd goes, and that leaning is bias — the staff-room tap and the far corner of the ground get few walkers, so few lines. Option (c) is a real worry, but a broken tap in a busy corridor gets reported loudly; (d) is the comfortable belief that many people means complete coverage. Marking guidance: Tests whether the child can name the gap a crowd leaves, rather than trusting size alone. [3]

Q49. (b) 26+18=44, +31=75, +26=101, +44=145. The sentence is shorter than the list and answers a question, which is what makes it information. Option (c) is the near-miss that drops one of the two 26s. The bare 26 in (a) has no label at all, and because two children read 26 it does not even say whose it is. Marking guidance: Tests whether the child can turn a labelled total into a sentence that answers something, and can add five numbers without losing the repeated one. [3]

Q50. (c) Week 1 is 4+3+5+4+12 = 28 and Week 2 is 5+4+6+3+14 = 32. The pattern is real because it repeats — both Fridays are 12 or more while every other day sits between 3 and 6 — but counts hold no reasons, so the cause needs asking, not counting. Option (b) is the total with Friday left out, and (a) reads a cause straight out of the numbers. Marking guidance: Tests whether the child rests a pattern on the repeat and keeps what happened separate from why it happened. [3]

Q51. (a) Pots are in column B and Aloe is in row 5, so B5; column C is height and row 4 is the money plant, so C4 is 48. Option (b) gets the address right and then reads Aloe's own height instead of row 4's, which is the commonest slip here. An address names one exact box on every screen at once, which 'near the middle' never can. Marking guidance: Tests whether the child holds the row and the column steady at the same time, instead of drifting along one line. [3]

Q52. (d) 40+55+25 = 120 on the sheet, while the tin holds 180, and the gap of exactly 60 is B4: typing the letters turned the entry into text, and SUM skips text silently. The free clue is that B4 hugs the left edge. Option (b) is the near-miss from stopping a row early; the fix is to type 60 alone and then set Format, Number, Currency. Marking guidance: Tests whether the child ties the exact size of the gap to the one text cell rather than blaming the formula. [3]

Q53. (c) A bold header separates names from data, right-aligned numbers stack digit under digit, and borders stop the eye slipping into the next plant's row — and Marigold is still 14 pots and 35 cm afterwards. Option (a) changes every row equally, so the header stops standing out at all; (d) picks the same three changes and then claims formatting alters the data, which it never does. Marking guidance: Tests whether the child chooses contrast that helps reading and knows formatting changes the look of a cell, never its contents. [3]

Q54. (d) Heights largest first read 48, 41, 35, 27, 22, so the plants read Money plant, Rose, Marigold, Aloe, Tulsi and each row carries its own pots along: 6, 9, 14, 11, 8. The pots look out of order, and that is correct, because pots were never the sorting column. Option (a) sorts the pots too, which is exactly the mistake this topic exists to catch. Marking guidance: Tests whether the child moves whole rows and accepts that the untouched column ends up unsorted. [3]

Q55. (a) Checking row by row: Tulsi 48 for 22, Marigold 41 for 35, Money plant 35 for 48 and Rose 22 for 41 are all wrong, while Aloe shows 27 and really is 27. Option (c) has the right count with the wrong reason — the 27 did move, and simply happened to land back in its own row, so it is luck, not safety. The fix is undo, then select the whole table. Marking guidance: Tests whether the child checks each row against the truth and can tell a lucky match from a correct one. [3]

Q56. (b) Ticked means shown, so unticking Green hid the very rows she wanted. She sees Diya, Kavya and Nikhil, 5+8+6 = 19, while the Green points are 7+4+3 = 14; and 19+14 = 33 checks the working. Option (c) is the fear this topic exists to settle — the Green rows are still in the sheet, which is why the visible row numbers skip. Marking guidance: Tests whether the child knows unticking hides rather than deletes, and can total both the visible and the hidden rows. [3]

Q57. (d) SUM was 22+35=57, +48=105, +27=132, +41=173, and the drop of 18 makes 155. MAX moves to 41 and now points at a different plant altogether, while MIN stays 22 because Tulsi never moved. Option (b) is the near-miss that subtracts the new 30 instead of the difference of 18. Marking guidance: Tests whether the child recomputes all three and notices that one changed value can move MAX onto a different plant. [3]

Q58. (c) C2:C6 stops at row 6, so C7 is simply not part of it — the functions are obeying their instructions exactly, and it is the instruction that is out of date. With all six, MIN is 19 and SUM is 173+19 = 192. Option (d) has both numbers right for the wrong reason, and 'broken' is what stops a child from fixing the range. Marking guidance: Tests whether the child blames the range rather than the function, and still recomputes both answers correctly. [3]

Q59. (d) =B3C3 reads the new price and gives 5 x 36 = 180, while =530 knows nothing about cell C3 and stays at 150; the new column total is 175+180+135 = 490. Option (b) fixes chilli and forgets to redo the grand total, which is half the work. Option (a) is the tempting belief that Sheets updates typed numbers too. Marking guidance: Tests whether the child sees why a reference updates and a typed number does not, and carries the change through to the total. [3]

Q60. (a) The chart follows the question. A bar answers how much more, 14 - 7 = 7 points; a pie answers what share, and the whole is 14+11+8+7 = 40, so Blue is 8 out of 40, which is 20%. Option (c) reads the count 8 straight off as a percentage without dividing. Option (d) swaps one 'always' for another, and a pie is only allowed here because the houses really do make one whole. Marking guidance: Tests whether the child rejects 'always', finds the whole before quoting a share, and attaches each number to the right chart. [3]