year-7 Data Modelling and e-safety
  • 1. Which of these is the correct formula for an addition?
A) =SUMB6+B7
B) =B6+B7
C) =SUM(B6+B7)
D) B6+B7
  • 2. A spreadsheet is divided into what?
A) Parallel and diagonal lines
B) Columns, rows and cells
C) Helixes
D) Lines and squares
  • 3. Which symbol would you use in a formula for division (dividing a number)?
A) _
B) /
C) *
D) +
  • 4. Formulae must always start with which symbol?
A) subtract
B) Equal
C) divide
D) Add
E) bracket
  • 5. In a cell reference, for example A1, what does the letter refer to?
A) The column the cell is in
B) The row the cell is in
C) The worksheet the cell is in
  • 6. In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.
A) Cell
B) Numbers
C) Labels
D) Formulas
  • 7. what is the name of the highlighted Cell
A) B6
B) C4
C) B7
D) A6
  • 8. Which of the following is not an excel function?
A) MIN
B) AVerage
C) MAX
D) MUM
E) SUM
  • 9. what does the MAX function do?
A) Finds the Odd number in a range of cell
B) Find the biggest number in range of Cells
C) Finds the even number in a cell
  • 10. What does the Min function do?
A) Finds the best number in a range of cells
B) Finds the smallest Number in a range of cells
C) Find the biggest number in a range of cells
  • 11. what does the Randbetween function do?
A) Finds the Biggest Number in a range of cells
B) Finds the smallest number in a range of cells
C) Generate a random number between a given range
  • 12. what does the formula =b2/b3 do?
A) it adds the contents of cell b2 and b3
B) it does nothing
C) it divides the contents of b2 by b3
D) it divides the contents of b3 by b2
  • 13. Which month had the highest average temperature?
A) July
B) September
C) January
D) August
  • 14. Which month had the lowest average temperature?
A) September
B) October
C) July
D) February
  • 15. April and May have the same average temperature as June and July.
A) True
B) None
C) Both
D) False
  • 16. Which make of car was the most popular?
A) Nissan
B) Peugeot
C) Toyota
D) Vauxhall
  • 17. Which was the lowest selling make?
A) Nissan
B) Toyota
C) vauxhall
D) Jaguar
  • 18. What do we call a cell being worked on?
A) Active Cell
B) Current cell
C) Passive Cell
D) Live Cell
  • 19. A cell can be referred to in a formula using a relative or .......
A) Address Reference
B) Absolute Reference
C) Key reference
  • 20. The work space is divided into rectangles called .......
A) Sells
B) Shells
C) Cells
D) Bells
  • 21. Which of these is not a formula?
A) -C3/F2*H5
B) =C3+F2*H5
C) =C3*F2*H5
D) =C3-F2*$H5
  • 22. Spreadsheets are good at doing ....... analysis of data
A) what-if
B) how-why
C) why-when
  • 23. Which of these is not a commonly used function?
A) MINGIN
B) MIN
C) MAX
D) MOD
  • 24. What symbol would we use to subtract the content of one cell from another?
A) /
B) *
C) -
D) =
  • 25. what is the name for each vertical part of a spreadsheet that is represented by a letter
A) Row
B) Cell
C) Column
  • 26. The cell reference for the shaded cell is
A) B2
B) 2:B
C) 2B
  • 27. The formula used to calculate the total cost is?
A) =C3+D3
B) =C3//D3
C) =C3&D3
  • 28. in Cell C11 the formula to find the largest number in the Cells above is?
A) =MAX(C3:C10)
B) =Largest(C3:10)
C) =Biggest(C3:C10)
  • 29. Which is an example of absolute cell referencing?
A) A1
B) $A$1
C) £A£1
  • 30. What do we use Excel for?
A) Writting a letter
B) Spreadsheets
C) Don't know
D) Making tea
  • 31. When a photo or video is shared on the internet, who might be able to see it?
A) Anyone
B) No One
C) Only me
D) Only my Parents
  • 32. One of your teachers slipped over on the field and someone took a video of it on their phone. It gets sent to you. Do you share it?
A) Probably, but only to my friends.
B) Wouldn’t that be mean?
C) Yes! It was hilarious!
  • 33. One of your classmates has shared a photo of you that you really don’t like. What do you do?
A) Share an embarrassing photo of them in return!
B) Tell an adult and explain why you’re unhappy.
C) Nothing; it’s up to them what they post online.
  • 34. You took a photo of your friend doing something that might get her into trouble. Do you share it?
A) I’d only share it with my closest friends, so no one else will see it.
B) No, I wouldn’t like it if she did that to me.
C) She’d definitely see the funny side, and no one will remember!
  • 35. You receive a message from a school friend asking for the phone number of another friend you both have. What do you do?
A) Apologise and say that you can’t send them the telephone number because you don’t want to share someone else’s personal information.
B) Message back straight away with the telephone number. You’re all friends so there’s no problem here.
C) Check with your other friend first, to make sure they’re happy for you to share their telephone number with this person.
  • 36. There’s an exciting new game that lots of your friends have started playing but it’s rated for ages 18+. You’re visiting a friend when they ask if you want to play it. What do you do?
A) Suggest holding off until next time you visit, so you can ask your parents first.
B) Say no, thank you. The age limit is there for a reason and it would break the law to play it.
C) Say yes and grab a controller. You can’t play it at home but this way your parents will never know.
  • 37. You’re signing up to the website of a new game. The form asks for the following details: Full name, email address, home address, telephone number. What do you do?
A) Report the game – personal information should be kept private and secure.
B) Give them all the details. Companies and organisations can always be trusted to look after their customer’s personal information.
C) Check the webpage for further details about why they need the information or ask an adult to help.
  • 38. Your Mum has given you permission to borrow her phone to use your favourite app. Whilst you’re using the phone, a notification pops up showing your Mum has received a new message – and it looks like it’s about you. What do you do?
A) Hand the phone back to your Mum – it’s her phone so the notification is for her, not you.
B) Open the notification to read the message with your name in. It’s about you, so you should be allowed to read it.
C) Exit the app and open your Mum’s messages. If there’s one message about you, there might be more and you have a right to know what they say.
  • 39. You’re hanging out with several friends at your house, having fun and taking photos. You and your best friend love one of the photos and want to share it online, but another friend is less pleased with it. What do you do?
A) Don’t share the photo. Being a good friend means asking for consent and thinking about how your actions will impact other people.
B) Try to convince your friend who doesn’t like it to change their mind. If you can get them to agree then it’s fine to post it.
C) Share the photo anyway. There’s two votes for sharing it and only one for not.
  • 40. You’ve been given permission to download a new game on a device shared by your family. After the download has completed a pop-up appears asking if the game can access the device’s camera, files and location. What do you do?
A) Select ‘no’ for now so you can check with the other people who use the device and decide whether the game needs to receive that information or not.
B) Select ‘no’ for now so you can play the game and see whether it works without access to the camera, files and location information
C) Say yes for all of them and get started playing the game.
Students who took this test also took :

Created with That Quiz — where a math practice test is always one click away.