The leaflet has been formatted with three columns of

1.   ?    equal widths and no spacing
2.   ?    variable widths and no spacing
3.   ?    equal widths and equal spacing
4.   ?    variable widths and equal spacing

The paragraphs in the leaflet are formatted with a

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

The user could take a picture from a magazine and insert it into the document by using a

1.   ?    browser
2.   ?    clip-art file
3.   ?    microphone
4.   ?    digital scanner

The image at Q has been positioned

1.   ?    above the text
2.   ?    behind the text
3.   ?     in front of the text
4.   ?    using text wrapping

The list at R is presented inconsistently due to

1.   ?    bullet size
2.   ?     text indentation
3.   ?    bullet indentation
4.   ?    paragraph formatting

The text at P should read ‘It is as easy as that’. This error can be found





automatically by software using

1.   ?    a grammar checker
2.   ?    a spellchecker
3.   ?    print preview
4.   ?    a dictionary

Questions 7 to 15 are about this spreadsheet. Formulas have been used to calculate values in columns D, F and G and rows 8 to 11.

Discount is calculated by multiplying Gross Income by % Discount and dividing by 100. The formula in cell F3 is

1.   ?    =F3*D3/100
   
   
   
2.   ?    =100/D3*E3
3.   ?    =E3*F3/100
4.   ?    =D3*E3/100

Discount is calculated by multiplying Gross Income by % Discount and dividing by 100. Net Income is Gross Income less Discount. If the % Discount in cell E4 is changed to 8, the other values that will change automatically are in cells

1.   ?    F4, F8, G4, G10, G11
2.   ?    E4, F4, G4, G10
3.   ?    F4, G4, G10, G11
4.   ?    F4, F9, G10, G11

The formula in cell G11 is

1.   ?    =SUM(G3:G7)/4
2.   ?    =AVERAGE(G3:G7)
3.   ?     =AVERAGE(G2:G9)
4.   ?    =AVERAGE(G3:G10)

The formula in cell D3 is B3*C3. This is replicated to cell range D4:D7.
The formula in D7 is

1.   ?    =B3*C3
2.   ?    =B7*C7
3.   ?    =D4*D7
4.   ?    =B3*C7

To present the data in cell A3 in one line, the user should

1.   ?    increase the column width
2.   ?    increase the row height
3.   ?    use a larger font size
4.   ?    use a frame

The cell ranges used to produce this chart are

1.   ?    A1:A7 and D3:E7 and G3:G7
2.   ?    A3:A7 and D3:D7 and G3:G7
3.   ?     A1:A7 and E3:E7 and F3:F7
4.   ?    A3:A7 and E3:G7

The user positioned the text ‘Minimum Gross Income’ by merging cells

1.   ?    A8:C8
2.   ?    A8:C9
3.   ?    A8:C10
4.   ?    A8:C11

The text in row one is horizontally aligned

1.   ?    top
2.   ?    left
3.   ?    right
4.   ?    centre

To sort the spreadsheet on Net Income so that the data for the smallest Net Income comes at the top of the list, the user should select cell range

1.   ?    G3:G7 and sort ascending on Net Income
2.   ?    A3:G7 and sort ascending on Net Income
3.   ?    A3:G7 and sort descending on Net Income
4.   ?    G3:G7 and A3:A7 and sort ascending on Net Income

Questions 16 to 20 are about this extract from a database.

The items whose Stock Level is at or below the Re-order Level have Product Codes

1.   ?    ME964BE, PGA300BE
2.   ?    ME964BE, PGA300GY
3.   ?    ME964BK, PGA300GY
4.   ?    ME964BK, PGA300BE

The search criteria for finding all products priced at less than £50.00 with 1,000 or more in stock is

1.   ?    Price < 50.00 AND Stock Level >= 1000
2.   ?    Price < 50.00 AND Stock Level > 1000
3.   ?    Price < 50.00 OR Stock Level >= 1000
4.   ?    Price < 50.00 OR Stock Level > 1000

If the database holds customer names and addresses, personalised letters
can be created automatically using

1.   ?    the product code
2.   ?    the primary key
3.   ?    mail merge
4.   ?    e-mail

The only field suitable as the primary key is

1.   ?    Price
2.   ?    Colour
3.   ?    Description
4.   ?    Product Code

To list the database in A to Z order of Description, with the prices for
each description listed starting with the most expensive, the user should
sort

1.   ?    ascending on Description and then ascending on Price
2.   ?    ascending on Description and then descending on Price
3.   ?    descending on Description and then ascending on Price
4.   ?    descending on Description and then descending on Price

Question 21 is about this spreadsheet.


The chart that shows the Sales Data for Week 4 is

1.   ?    chart A
2.   ?    chart B
3.   ?    chart C
4.   ?    chart D

Questions 22 to 24 are about this website.

To move between this page and pages already viewed during an internet session, the user should

1.   ?    use the web browser
2.   ?    click the Home button
3.   ?    use the forward/back arrows
4.   ?    make use of the Favourites feature

To make it easy to access this website in the future, the user should

1.   ?    bookmark it
2.   ?    click on the Home button
3.   ?    add it to their Address Book
4.   ?    use a search engine each time

The name EarOne is copyright. This means that it

1.   ?    is confidential
2.   ?    can be freely used
3.   ?    is password protected
4.   ?    can only be used with permission

Questions 25 to 28 are about this line graph.
If the trends over the period April to May continue into June, who will have
the shortest performance time?

1.   ?    Sanjay Rachid
2.   ?    Sasha Wilson
3.   ?    Paul Oakes
4.   ?    Eric Jones

‘Seconds’ is the title for the

1.   ?    chart
2.   ?    legend
3.   ?     x-axis
4.   ?    y-axis

All performance times increased from

1.   ?    April to May
2.   ?    January to May
3.   ?    February to March
4.   ?    January to February

If the user had performance data for 18 athletes, a more suitable
presentation method would be a

1.   ?    table
2.   ?    pie chart
3.   ?    bulleted list
4.   ?    numbered list

Questions 29 to 33 are about this survey form.





The purpose of the survey form is to

1.   ?    order goods
2.   ?    just advertise goods
3.   ?    advertise goods and collect information
4.   ?    advertise goods and summarise information

Application software suited to storing the survey information obtained in
the table would be

1.   ?    database
2.   ?    graphics
3.   ?    browser
4.   ?    e-mail

There is a problem with the table at Q. To fix this, the user should

1.   ?    remove the tick boxes
2.   ?    merge the cells in the row
3.   ?     increase the height of the row
4.   ?    increase the width of the table

The images are presented inconsistently. To correct this, the image at R should be

1.   ?    cropped
2.   ?    vertically moved
3.   ?    increased in size
4.   ?    horizontally moved

To provide a tick box at P, the user should

1.   ?    split the cell into two columns and one row
2.   ?    split the cell into one column and two rows
3.   ?    increase the width of the cell’s border lines
4.   ?    merge the cell with the cells above and below

Question 34 to 40 are general questions.

To find where a file has been saved on disk, the user should

1.   ?    use the directory search tools
2.   ?    search each file in turn
3.   ?    use the backup facility
4.   ?    use find and replace

35 A publicity flyer would normally have an informal writing style because it

1.   ?    cannot be protected by copyright
2.   ?    encourages people to read it
3.   ?    has more accurate content
4.   ?    takes up less space

To ensure that data is not lost if a computer system fails, the user should

1.   ?    save copies of the file with the same name on the system
2.   ?    use different filenames on the system
3.   ?    keep a record of computer failures
4.   ?    backup to a secure medium

The characters * and ? are sometimes used in search criteria as

1.   ?    bookmarks
2.   ?    operators
3.   ?     wildcards
4.   ?    engines

A company posts a price list of its products on its website. The advantage
to the customer is that the company can

1.   ?    set its prices very high
2.   ?     limit access to computer owners only
3.   ?    stop its competitors seeing their prices
4.   ?    update its prices as soon as they are changed

To check data has been entered accurately into a database, the user should

1.   ?    use a spellchecker
2.   ?    check data types
3.   ?    print preview
4.   ?    proof read

A file named Order1 is saved in the Phones folder which is within the Stock folder.

The structure that shows where the Order1 file is stored is

1.   ?    diagram A
2.   ?    diagram B
3.   ?    diagram C
4.   ?    diagram D