Preview

05 - Spreadsheets

 1. Spreadsheets are used to store information and data.

  TRUE

  

 2. The most popular spreadsheet program is Microsoft Office ______. Free alternatives include OpenOffice Calc and Google Docs, which runs in a web browser.

  Access

  Excel

  Power Point

  Publisher

 3. Once we have our information in a spreadsheet we can run powerful calculations, make _________________and analyse patterns

  colours and shapes

  1s and 0s

  marks and scratches

  graphs and charts

 4. Every _____ in a spreadsheet or worksheet has a unique cell reference, which consists of a letter and a number. The letter refers to the column and the number refers to the row.

  mell

  atom

  cell

  bell

 5. To select a cell, _________ on it. To enter data, double-click it. To select multiple cells, click and hold the left mouse button and drag it in the direction of the cells you want to select.

  stamp

  triple click

  double click twice

  left click

 6. The three types of data you can enter into a cell are data, labels and ____________.

  queries

  questions

  formulas

  forms

 7. Formulas are _________________ that update automatically if referenced data changes.

  charts

  graphs

  calculations

  gates

 8. The A-Z feature automatically ______ data in ascending/descending order or alphabetically.

  orders/sorts

  finds

  deletes

  meets/greets

 9. In the following spreadsheet, where is it likely that Eric has used a formula?
early_years_spreadsheet_picture1.png

  For 'Total Count'

  For 'Number of Guests'

  For 'Email'

  For 'Name'

 10. John could use a spreadsheet to plan his birthday party and costs.

  FALSE

  TRUE