UPPER SECONDARY SCHOOL CERTIFICATE EXAMINATIONS INFORMATION COMMUNICATION TECHNOLOGY -2015 GRADE ICT EXAMINATION QUESTIONS AND ANSWER KEYS
The part of the CPU of a computer that carries out mathematical, comparative and logical process is called a/an
A. Clock. B. Control Unit. C. Arithmetic Logic Unit. D. Random Access Memory.
A computer virus
A. is a firewall.
B. can infect people.
C. is a computer program.
D. can be found in new computers only.
In a given MS Excel spreadsheet, cell A1 contains the value 100. If the function =if(A1<100,”x”, “Y”) is used in cell B1 of the same spreadsheet, the result will be
A. X B. 100 C. 0 D. Y
MS Access is an example of a/an
A. presentation software.
B. database software.
C. anti virus software.
D. word processing software.
The data types of a number field in an MS Access table do not include
A. byte. B. integer. C. long integer . D. decimal.
The controls on an MS Access report do not include
A. text box. B. label. C. circle. D. rectangle.
An MS Access query uses data from
A. reports and forms. B. queries and wizards. C. tables and queries. D. tables and labels.
One of the acronyms used in relation to the Internet is HTTP. HTTP is
A. Hyper Technology Tracking Protocol.
B. Hyper Text Transfer Protocol.
C. Hyper Text Transfer Port.
D. Hyper Transfer Technology Plan.
Which of the following is NOT a Publication Type in MS Publisher?
A. Brochures B. Calculators C. Catalogues D. Flyers
The feature that provides frequently used commands in MS Word or MS Publisher would be
A. Start menu.
B. Short-cut menu.
C. Task bar.
D. Quick Access Toolbar.
The colour scheme of a publication may be altered using the commands on which of the following ribbon or menu options?
A. Home B. Format C. Page Design D. Page layout
Which of the following best describes firewall in ICT? It
A. ensures that data is available to anyone.
B. is a physical wall for fire protection.
C. ensures continuity of operations
D. protects computers or networks from other users or network.
Which of the following best represent the data communication devices?
A. Cables, smart phones, radio, modem
B. Phones, modem, fibre optic, printer
C. Data cables, modem, router, hub
D. Router, mouse pad, satellite, cable
The software that allows people to browse the web for information is
A. Search Engine. B. Multimedia. C. Network Server. D. Browser.
A many to many relationship in a database can be found in
D. Data types
To enter data into a table in MS Access, you can use the
A. design view. B. table properties . C. datasheet view. D. label wizard.
A crosstab query wizard in MS Access
A. displays data in a spreadsheet-like format.
B. creates simple queries from spreadsheet files.
C. finds records with duplicate values.
D. allows data entry by keyboard.
The first page of a website is called a/an
A. web page.
C. world wide web.
D. home page.
An example of an HTML text editor is
A. MS PowerPoint.
B. Windows notepad.
C. PDF creator.
D. Windows Paint brush.
What is the purpose of inserting an alternative text to an image when creating a webpage?
A. If the image cannot be displayed when the page is being viewed, then the text will appear instead.
B. If the text is not given, the image will not show when the page is being viewed.
C. The image needs the text in order for it to be displayed.
D. There is no specific reason.
To have your name showing at the top of any new slide you create in a MS PowerPoint presentation, you would write your name once in the
B. text box.
D. Word Art.
To be able to allow remote viewers to watch your PowerPoint presentation using a web browser, you must choose;
A. Rehearse current slide.
B. Custom Slide Show.
C. Record Slide Show.
D. Broadcast slide show.
Which of the following best describes someone who analyzes business activities and computer systems and recommends appropriate software to be used?
C. Network Engineer
D. Systems Analyst