Q.1
A spreadsheet is divided into what?
  • Columns, rows and cells
  • Lines and squares
  • Parallel and diagonal lines
  • Helixes
Q.2
Which symbol would you use in a formula for division (dividing a number)?
  • x
  • /
  • ÷
  • *
Q.3
Which of these could be used in a spreadsheet to display your data?
  • A bar chart
  • A line graph
  • A pie chart
  • All of the above
Q.4
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?
  • It will make it easier if you want to rearrange your spreadsheet
  • A formula will instantly calculate the change in cost if you need to change the price of the pizzas
  • The spreadsheet will be tidier if you use a formula
  • It is always faster to calculate in your head rather than to use a formula
Q.5
Which symbol would you use in a formula for multiplication (to multiply two or more numbers)?
  • x
  • /
  • ÷
  • *
Q.6
On a spreadsheet, all cells are named. In the cell named 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 that cell is located
  • The type of calculation which has been entered into that cell
Q.7
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
Q.8
Which of these is the correct formula for an addition?
  • =SUMB6+B7
  • B6+B7
  • =SUM(B6+B7)
  • =B6+B7
Q.9
What is an electronic spreadsheet?
  • A large piece of cloth spread over a flat surface
  • A software package used to organize information
  • A piece of A3 paper spread out so that you can see it clearly
  • A word processing file
Q.10
Which of these could a spreadsheet NOT be used for?
  • Creating a graph from your science investigation results
  • Calculating the cheapest cell phone package from a range of choices
  • Finishing your English writing homework
  • Storing the test results for a class of year six pupils
0 h : 0 m : 1 s