Questions 1 to 6 are about 'The Benefits of Information Technology' article
The list at A is presented inconsistently due to:

1.   ?    font size
2.   ?    font style
3.   ?    bullet type
4.   ?    indentation
   

The paragraph at B is formatted with a

1.   ?    hanging indent
2.   ?    first line indent
3.   ?    left whole paragraph indent
4.   ?    right whole paragraph indent

The symbol at C indicates that this article:

1.   ?    can be copied only with permission
   
2.   ?    can be copied by anyone
3.   ?    is confidential
4.   ?    is up to date
   

To change all instances of the term CIT to ICT the user should use:

1.   ?    find and replace
   
2.   ?    a spell checker
3.   ?    copy and paste
4.   ?    drag and drop

To help avoid complete loss of the document file, the user should:

1.   ?    use a password
   
2.   ?    keep a paper copy
3.   ?     make a back up copy
4.   ?    copyright protect the file

The image at D is positioned:

1.   ?    with text wrap
2.   ?    beside the text
3.   ?    behind the text
   
   
4.   ?    in front of the text
   

Questions 7 to 15 are about the database.

Which field should be used as the primary key:

1.   ?    Postcode
2.   ?    Lastname
   
3.   ?    Firstname
4.   ?    Customer ID

Access to this database can be restricted by the use of:

1.   ?    copyright protection
2.   ?     virus scanning
   
3.   ?    a back up file
4.   ?    a password

To find all female customers who live in London, the search criteria are:

1.   ?    sex = "F" OR Town = "London"
2.   ?    sex = "F" AND Town ="London"
3.   ?    sex = "Female" OR Town = "London"
4.   ?    sex = "Female" AND Town = "London"

The data type of the Customer ID field is:

1.   ?    currency
2.   ?    number
3.   ?    text
4.   ?    date

Wildcards help users to:

1.   ?    sort tables of information
2.   ?    move between web pages
   
3.   ?    maintain the confidentiality of files
4.   ?    search when they cannot remember a complete name or word

To list customers in last name order for each town, the user should sort:

1.   ?    first ascending on Town and second ascending on Lastname
   
   
2.   ?    first ascending on Lastname and second ascending on Town
   
3.   ?    first descending on Lastname and second descending on Town
4.   ?    first ascending on Lastname and second descending on Town
   

The youngest female customer living in London is:

1.   ?    SW-9011
2.   ?     E-1234
3.   ?    SW-3333
4.   ?    LL-191

The criterion to find all those customers on or after 01/01/75 is:

1.   ?    Date of Birth > 01/01/75
2.   ?    Date of Birth < 01/01/75
3.   ?    Date of Birth >= 01/01/75
4.   ?    Date of Birth <= 01/01/75

To check the accuracy of entries made to the database, the user should:

1.   ?    proof read
2.   ?    virus check
3.   ?    use a spellchecker
4.   ?    use a grammar checker

Questions 16 to 18 are about the graph.






The X-axis title is at:

1.   ?    E
2.   ?    F
3.   ?    G
4.   ?    H

The chart legend is at:

1.   ?    E
2.   ?    F
3.   ?    G
4.   ?    H

Which pupil has attendance that shows a downward trend:

1.   ?    Taber, S
2.   ?    French, P
3.   ?    Smith, P
4.   ?    Moore, P

Questions 19 to 23 are about the Enrolment Form.

The purpose of the shading in the form is to:

1.   ?    take up more space
2.   ?    fit it on to one page
3.   ?    encourage people to spell accurately
4.   ?    indicate areas where data should not be entered
   

To provide two additional lines for applicants' addresses, the user should:

1.   ?    insert new rows
2.   ?    adjust row heights
3.   ?    insert new columns
4.   ?    adjust column widths

To design the form so that there are eight boxes to enter course codes at Y, the user should:

1.   ?    insert fields
2.   ?    split the cell
3.   ?    merge the cell
4.   ?    insert columns

The purpose of this form is to:

1.   ?    attract students
2.   ?    advertise courses
3.   ?    collect information
   
4.   ?    analyse information

A form would also be suitable for:

1.   ?    producing an invitation
2.   ?    producing a poster
3.   ?    writing a letter
4.   ?    doing a survey

To check the layout of a form before printing, the user should use:

1.   ?    borders
   
2.   ?    print preview
3.   ?    a spell checker
4.   ?    a grammar checker

The type of software that should be used to store student's names, addresses, dates of birth and course code information is:

1.   ?    word processing
2.   ?    spreadsheet
   
3.   ?    database
4.   ?    graphics

The college would like students to enrol via its website. This would disadvantage those who do not:

1.   ?    have good writing skills
2.   ?    have database software
3.   ?    know the college address
4.   ?    have access to the internet

To return to the last web page viewed, the user should click:

1.   ?    home
2.   ?    back
3.   ?    search
   
   
4.   ?    page up

Which of the handles shown could be used to increase the height of the image without changing the width:

1.   ?    K
2.   ?    L
3.   ?    M
4.   ?    N

Questions 29 to 32 use the Attendance spreadsheet. A formula is used to calculate 'Attendance'.
The pupil with the lowest attendance in February is:

1.   ?    Moore, P
2.   ?    Smith, P
   
3.   ?    Taber, S
4.   ?    Frenxh, P

Attendance is the total of the 'Actual' values, divided by the total 'Possible' values for each pupil. The formula in cell H4 is:

1.   ?    =AVERAGE(B4:G4)
2.   ?    =B4+D4+F4/C4+E4+G4
   
3.   ?    =(B4+D4+F4)/(C4+E4+G4)
4.   ?    =(C4+E4+G4)/(B4+D4+F4)

The column headings January, February, March have been formatted using:

1.   ?    split cells
   
2.   ?    merged cells
3.   ?     left alignment
4.   ?    right alignment

To produce a pie chart which compares the pupils' attendance, the user should select the cell range:

1.   ?    A4:H8
2.   ?    A1:A8
   
3.   ?    A4:A8 AND F4:F8
4.   ?    A4:A8 AND H4:H8

Questions 33 to 40 use the Course Prices spreadsheet. Formulas are used to calculate 'Senior Citizen Rate', 'Full Total Cost' and 'Senior Total Cost'. The cell range A1:G1 has been:

1.   ?    split
2.   ?    merged
   
3.   ?    deleted
4.   ?    inserted

The column headings are aligned:

1.   ?    centred vertically
2.   ?    bottom vertically
3.   ?    fully justified
4.   ?    top vertically

The values in cell range E3:E9 are formatted as:

1.   ?    number
2.   ?    currency
3.   ?    percentage
4.   ?    number to zero decimal places

The Senior Citizen Rate is 80% of the Cost per Day. The formula in cell D3 is:

1.   ?    =C/80*100
2.   ?    =C3-C3*80%
   
3.   ?    =C3*80%
4.   ?    =C3-80%

The formula entered in cell D3 has been replicated to cell range:

1.   ?    A3:C3
2.   ?    D4:D9
3.   ?    D4:G9
4.   ?    E3:G3

Full Total cost is the Cost per Day added to the Insurance Cost per Day and then multiplied by the Course Length. The formula in cell F3 is:

1.   ?    =C3+E3*B3
2.   ?    =(C3+E3)*B3
   
3.   ?    =(C3+E3*B3)
4.   ?    =C3+(E3*B3)

If the value in cell B6 is changed, the other values that will change automatically are in cells:

1.   ?    C6, F6, G6
2.   ?    D6, F6, G6
3.   ?    D6, F6
4.   ?    F6, G6

The Senior Citizen rate is changed to 75% of the Cost per Day. When the formula in D3 is changed the value in D3 will:

1.   ?    increase
2.   ?    decrease
3.   ?    stay the same
4.   ?    become a negative number