State the text justifi cation Gordon used on the articles heading. ( b ) When the article was spell-checked the word Devros was highlighted. Explain why the spell checker highlighted this word.

Gordon produces a monthly newsletter for the Dr What fan club. An article from next month’s issue is shown below. ( a ) State the text justifi cation Gordon used on the article’s heading. ( b ) When the article was spell-checked the word Devros was highlighted. Explain why the spell checker highlighted this word. ( c ) State the word processing facility that was used to make the list of costume materials stand out. Halloween Party Dr What club members are looking forward to this year’s Halloween monster costume party in Glasgow. This is always a well attended event, with fans travelling from all over the UK to show off their best homemade costumes. Last year’s winner, Matthew, spent 20 hours creating his fabulous Devros costume from: ¢ cardboard ¢ plastic balls ¢ tape ¢ spray paint. [Turn over 2. (continued) ( e ) When the slides are shown, the audience hears a recording of Dennis describing each photograph. (i) What two items of hardware did Jean need to capture a sound fi le of Dennis describing each photograph? 1 2 (ii) Which of the fi le types below is a sound fi le? Tick ( ? ) one box. .txt .rtf .avi .wav (iii) The sound fi les were then compressed before they were added to the slides. Why were the sound fi les compressed? ( f ) Jean’s mother asks if she can have a copy of the slideshow. Which of the backing storage media below should be used to save a copy of the fi le for Jean’s mother? Tick ( ? ) one box. CD ROM DVD ROM Internal Hard Disk Drive USB Flash Drive 3. Joshway Academy Teen Enterprise Club make and sell boxes of chocolates. They use the application below to calculate how much profi t they will make from each box. ( a ) What type of application is shown in the above diagram? Tick ( ? ) one box. word processor spreadsheet charting database ( b ) The Profi t is the difference between the Selling Price and the Total Cost. What formula has been entered in cell C16? ( c ) Teen Enterprise add œMint Flavouring to a new batch of chocolates. How could the fi le above be altered to include this new information? 1 Teen Enterprise Chocolates 2 3 1 Box of 20 Chocolates Quantity Cost 4 Chocolate 400g £0.89 5 Sugar 50g £0.04 6 Milk 75ml £0.10 7 Cocoa butter 50g £0.23 8 Vanilla Pod 1 £0.40 9 Cardboard Box 1 £0.32 10 Plastic Insert 1 £0.12 11 Chocolate Wrappers 20 £0.05 12 Total Cost £2.15 13 14 Selling Price £3.50 15 16 Profi t £1.35 3. (continued) ( d ) The data is sorted so that the ingredients and packaging costs are all in order from the cheapest to the dearest. Which sentence below best describes how to sort the data? Tick ( ? ) one box. Highlight cells C4 to C11 and sort in ascending order on column C. Highlight cells A4 to C11 and sort in ascending order on column C. Highlight cells C4 to C11 and sort in descending order on column C. Highlight cells A4 to C11 and sort in descending order on column C. ( e ) The Enterprise Club use the application to produce the chart below. State the type of chart shown above.