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

  Publisher

  Power Point

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

  marks and scratches

  colours and shapes

  graphs and charts

  1s and 0s

 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.

  bell

  atom

  cell

  mell

 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 ____________.

  formulas

  questions

  forms

  queries

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

  gates

  charts

  graphs

  calculations

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

  finds

  orders/sorts

  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