Home > Key Stage 2 (KS2) > Quizzes > KS2 ICT Practice Test: Spreadsheets - How to Use to Organise Data on Computers
KS2 ICT Practice Test: Spreadsheets - How to Use to Organise Data on Computers
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 56% Most missed: “Which of these could be used in a spreadsheet to display your data?”

Spreadsheets are tables which you can tailor to any size you need and they can display any data you put into them in the form of numbers, text or even graphics. They are used by businesses and other organisations for many purposes, including accounting and record keeping. They are also used by people at home to work out their budgets, and by people at school to display the results of their science experiments as a graph.

KS2 ICT Practice Test: Spreadsheets - How to Use to Organise Data on Computers
Time left 00:00
10 Questions

1. Which of these is the correct formula for an addition?
2. What is an electronic spreadsheet?
3. You are creating a spreadsheet to calculate the cost of a party. You want to know how much you will spend on pizzas. Why is it better to use a formula rather than working out the calculations yourself?
4. A spreadsheet is divided into what?
5. Which symbol would you use in a formula for multiplication (to multiply two or more numbers)?
6. On a spreadsheet, all cells are named. In the cell named B10, the 'B' refers to which of these?
7. What does it mean to 'format' a cell?
8. Which of these could be used in a spreadsheet to display your data?
9. Which symbol would you use in a formula for division (dividing a number)?
10. Which of these could a spreadsheet NOT be used for?