The leaflet has been formatted with three columns of
The paragraphs in the leaflet are formatted with a
The user could take a picture from a magazine and insert it into the document by using a
The image at Q has been positioned
The list at R is presented inconsistently due to
The text at P should read ‘It is as easy as that’. This error can be found
automatically by software using
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
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
The formula in cell G11 is
The formula in cell D3 is B3*C3. This is replicated to cell range D4:D7.
The formula in D7 is
To present the data in cell A3 in one line, the user should
The cell ranges used to produce this chart are
The user positioned the text ‘Minimum Gross Income’ by merging cells
The text in row one is horizontally aligned
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
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
The search criteria for finding all products priced at less than £50.00 with 1,000 or more in stock is
If the database holds customer names and addresses, personalised letters
can be created automatically using
The only field suitable as the primary key is
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
Question 21 is about this spreadsheet.

The chart that shows the Sales Data for Week 4 is
Questions 22 to 24 are about this website.
To move between this page and pages already viewed during an internet session, the user should
To make it easy to access this website in the future, the user should
The name EarOne is copyright. This means that it
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?
‘Seconds’ is the title for the
All performance times increased from
If the user had performance data for 18 athletes, a more suitable
presentation method would be a
Questions 29 to 33 are about this survey form.
The purpose of the survey form is to
Application software suited to storing the survey information obtained in
the table would be
There is a problem with the table at Q. To fix this, the user should
The images are presented inconsistently. To correct this, the image at R should be
To provide a tick box at P, the user should
Question 34 to 40 are general questions.
To find where a file has been saved on disk, the user should
35 A publicity flyer would normally have an informal writing style because it
To ensure that data is not lost if a computer system fails, the user should
The characters * and ? are sometimes used in search criteria as
A company posts a price list of its products on its website. The advantage
to the customer is that the company can
To check data has been entered accurately into a database, the user should
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