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.

  Publisher

  Access

  Excel

  Power Point

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

  graphs and charts

  colours and shapes

  1s and 0s

  marks and scratches

 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

  bell

  cell

 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

  double click twice

  left click

  triple click

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

  questions

  formulas

  forms

  queries

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

  charts

  calculations

  graphs

  gates

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

  deletes

  meets/greets

  orders/sorts

  finds

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

  For 'Total Count'

  For 'Email'

  For 'Number of Guests'

  For 'Name'

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

  FALSE

  TRUE


Report an error