Spreadsheets

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