WorksheetsSpreadsheets
Total questions: 8
Worksheet time: 5mins
A spreadsheet is divided into what?
Columns, rows and cells
Lines and squares
Parallel and diagonal lines
Helixes
Which symbol would you use in a formula for multiplication?
x
/
+
*
Which symbol would you use for a formula in division?
x
/
+
*
On a spreadsheet, all cells are named. In cell B10, the 'B' refers to which of these?
The row where that cell is located
The type of information which can be entered into that cell
The column where the cell is located
The type of calculation which has been entered into that cell.
Which of these could be used in a spreadsheet to display your data?
A bar graph
A line graph
A pie chart
All of the above
Which of these is the correct formula for an addition?
=SUMB6+B7
B6+B7
=SUM(B6+B7)
=B6+B7
Which of these could a spreadsheet NOT be used for?
Creating a graph from your science investigation results
Calculating the cheapest mobile phone package from a range of choices
Finishing your English writing homework
Storing the test results for a class of year six pupils
What does it mean to format a cell?
To make a cell bigger
To make a cell smaller
To insert a picture into a cell
To choose what type of information can be entered into a cell and how it is displayed
