GPP (C)

By Computing Department

GPP questions Credit level for new course.


1. What is the difference between RTF and ASCII file formats?

    ascii has all the formatting information and RTF does not

    RTF has all the formatting information and ASCII does not.

    ASCII has some of the formatting information and RTF has none.

2. Keyboard shortcuts

    are icons on the screen which take you straight to a program.

    are shortcuts which automatically backup your files.

    are keypresses which save you from having to go through lots of menus to get things done.

3. Changing the speed of your mouse, the size and shape of the icons on the desktop are ways of

    altering the system's performance

    amending the output to the printer

    customising the HCI

4. If a file is dynamically linked to another file

    The source file changes every time the linked file is updated.

    the linked file changes every time the source file is updated.

    Both files change any time any one of them is updated.

5. This is a document which is stored on the computer then personalised by putting names and addresses in it.

    Standard paragraph

    Template

    Wizard

    Standard letter

6. A group of packages, usually from the same company, which have common data formats allowing them to exchange data easily is known as

    integration between packages in a common suite.

    integration between packages in a format suite.

    integration between packages in a software suite.

7. Which type of cell referencing in a formula changes according to where the formula is copied to in a spreadsheet?

    Absolute referencing

    Relative referencing

    Replicated referencing

8. Which type of referencing locks a formula onto a cell, nomatter where in the spreadsheet it might be moved to?

    Absolute referencing

    Relative referencing

    Replicate referencing

9. Which of these formulae is using absolute referencing?

    If($A$5>50;"pass";"fail")

    if(A5>50;"pass";"fail")

    If(A5>50;"$50";"$20")

10. Which of the following formulae would correctly work out the bonus for the sale of desktops and put it into column F?

    IF(E6>20;c16;0)

    IF(E5>20;B16;0)

    IF(E6>20;0;c16)

11. These are used to uniquely identify a record in a database file

    Query

    search on more than one field

    keyword

    field type

12. What kind of output format is this?

    Card

    List

    Grades

13. cropping a graphic is

    cutting out part of the graphic

    making the whole graphic a smaller size

    Making the whole graphic a larger size

    inserting more details into the graphic

14. A scanned graphic

    cannot be edited in a graphic package

    can only be viewed but not edited

    can only be scaled but not edited entirely

    can be edited once opened in a graphics package

15. This is an example of

    importing text

    using a text wizard

    text wrap around a graphic

    editing a scanned graphic

16. Bringing text into a DTP document from another file is called

    Text wrap

    Text pouring

    Importing text

    Porting text

17. You can capture audio and store it in your computer by using

    simply by using a microphone on its own

    by using presentation software

    a microphone, recording software and a sound card.

18. To capture an image and store it in your computer by using

    a digital camera or a scanner

    copying a file from a hard disk

    creating a graphic using a graphics package

19. Tables are useful in web pages for

    counting up large numbers

    editing graphics

    keeping text and graphics together

20. This is a part of a web page, which when you hover, or click, the mouse over it opens up another web page.

    Table

    Template

    Hotspot

21. An expert system has the advantage of

    Having the knowledge of an expert in the software.

    allowing you to communicate on-line with an expert.

    Forwarding your question as an e-mail to an expert.

22. This is an outline document which has already been fromatted with indents, margins and styles set up

    Template

    Standard letter

    Wizard

    Standard paragraph

23. Scanned text can be edited if

    It has been scanned using presentation software

    It has been scanned using DTP software

    It has been scanned using Optical Character reading software (OCR)