HAYDON SCHOOL

 

 INFORMATION COMMUNICATION TECHNOLOGY

 Yr 7  Yr 8  Yr 9  Yr 10  Yr 11  Yr 12  Yr 13 Staff and dept Training  Clubs  Links  Feedback

 

Modelling
Dates
Revision
Portfolio work
Student guide
Teacher guide
Information communication
Graphics
Internet

HOMEWORK 1

TASK: You must read the following and see where the gaps are. The words that need to be placed in the spaces are listed below.

 

active     column     cells     number     formulas     letter A1           cursor       Spreadsheets      numeric       row wider      dragging  calculators

 

Computers can be used as amazingly fast and clever_____. The programs that use this ability are called_____.

 

A spreadsheet is made up of_____ (the boxes you type data into). In any spreadsheet the highlighted cell is the_____ cell.

 

The cells which go across the spreadsheet form a_____ and the cells which are stacked on top of each other form a_____. Each row is labelled with a_____ and each column is labelled with a_____ - for example: column A, row 1, would be cell_____.

 

Every cell is capable of holding data. The data can be_____ or alphabetic (letters and words). Some of the data will be_____.

 

If the columns are too narrow, you can make them_____ by placing the on the line between each column and then_____ it the desired width.

 

Spreadsheets can be set up so that special layout instructions can apply to the whole spreadsheet or to any particular column, row or cell. For instance you can give commands to:

 

   show all the data as whole numbers (integers).

   always put two numbers (or more) after every decimal point.

   put a % sign after any number in a particular column.

   put a £ sign in front of every number in a particular row.