Test questions

Which device is NOT an input device?

Speaker

Which function is used in a spreadsheet to find the total of cell values in a
range, but only if a specific condition is met?

SUMIF

Which of the following assists the user in organising, maintaining and
improving the efficiency of a computer system?

Utility software

Which acronym refers to human–computer interaction through the use of
visual controls such as buttons and icons?

GUI

In a database report, the records have been grouped by the Learner field.
A count function is used to determine how many certificates each learner
has obtained. This function must be placed in the …

group header section.

Foursquare is a mobile app that recommends new services based on your
past use of services. Foursquare could therefore be categorised as
social…

networking.

File properties

is/are where the attributes of a file can be set as hidden and read-only.

The … tab on the Microsoft Word ribbon includes functions such as
accepting or rejecting tracked changes.

Review

Which ONE of the following applications is NOT a web browser?

Adobe Reader

Which ONE of the following is NOT an example of a multipurpose device/
computer?

Webcam

Full software packages available to a user, for a
trial period, and at no cost.

shareware

An alternative technology used for identification
purposes.

RFID

Laws that protect ownership and rights to
intellectual property.

copyright

A web protocol used by browsers and web servers
to provide secure data transfer.

https

A legal agreement that describes what you may and may not do with
software.

EULA

A .... is a bar at the top of a window that bears the name of
the program you are working in and the name of the file you are working
on.

title bar

If an instruction is used repeatedly by a program, it is temporarily stored in

cache memory

The global address of a website is called a

Uniform Resource Locator

A..... is a pocket-sized device with embedded
integrated circuits that can process data.

smart card

The instructions for starting (booting) a computer are stored in

ROM

The combination of names that indicates where a
folder or file is stored on a computer.

path

Compressing

refers to the process of reducing the size of a file by
producing a smaller, compressed version of the file

Network interface controller

A controller that is used to connect
the computer to the network.

What is the main function of Power supply

The power supply unit is the piece of hardware that converts the
power provided from the outlet into usable power for the many
parts inside the computer case. It converts the alternating current
from your wall outlet into the direct current that the computer
components require.Controls the amount of electricity that is available for the
computer.

What is the main function of a Network switch

This is a device that connects computers in a single network with
cables, to enable communication between them. A network switch is networking hardware that receives and forwards
data to the destination device from a starting device.

What is the main function of a Multifunction printer

A multifunction printer (MFP) is a device that consolidates
(combines) the functionality of a printer, copier, scanner and/or fax
or many different machines into one machine.

What is the main function of a HDMI cable

HDMI is a connector and cable OR connection used to transmit
high-quality and high-bandwidth streams of audio and video
between devices.

Why is the value of a computers Gigahertz so important if you are a gamer

GHz is the unit in which the speed of the CPU is measured and it
determines the clocking speed of your computer when you play a
game to ensure the game is not lagging.This enables a gamer to achieve a higher quality gaming experience.The higher the value, the faster the computer will run.

Why is a solid state drive better than a hard disk drive when purchased as an alternative drive ?

Solid-state drives (SSDs) use flash memory to deliver superior
performance and durability.

SSDs are more durable, run cooler and use less energy and are
faster than HDDs

There are no moving parts in a SSD

HDDs use spinning disks, or platters, to read and write data and they
are slower than SSDs

Why would you need to upgrade your RAM as a gamer

To increase the amount of RAM so as to reduce swapping.

Why would you need to upgrade your sound card as a gamer

The sound card offloads work from your CPU, which in return
gives you better overall performance

Why would you need to upgrade your graphics card as a gamer

To ensure quick screen response time/quality of images

Why would you need to upgrade your cpu as a gamer

To ensure efficiency (smoothness) OR no lagging when a
game is played.

To ensure efficiency (smoothness) OR no lagging when a
game is played.

Name ONE danger that power outages and other power-related
problems could cause to the computer system.

damage equipment, e.g. power supplies, motherboards

a flickering video display

unexpected system start-ups

system not responding

data loss/losing in a game

system crashes

What hardware device can a gamer use to protect their computer against
power surges and spikes?

Surge protector plugs

What is the main function of the operating system?

The OS is software that is intended to help control, support or
operate the computer

Acts as a graphical user interface (GUI) between the user and
computer

Controls the hardware

Controls the software

Expand the acronym "MB".

Megabyte

Explain what the primary key in a database is AND what it is used for.

A primary key is a unique identifier of a particular record in a table.  It is
used to correctly manipulate the data in the table to ensure that it cannot be
duplicated.

Give the phrase/sentence used by database programmers for the linking of
tables in a database ?

Creating (making) a relationship between the tables.

What procedure will you follow, in general terms, to link the two tables?

Table 1 is the client's table. Table 2 is the medical information table.
Use the chosen primary key (called the Foreign Key) from Table 2
and copy it into Table 1. This creates the relationship by using the
common field.

Give a general name for an HTML element such as '<h1>' or '</b>'.

A tag

Explain how you would open an HTML file so that you can edit the HTML code

You will right click on the file in Explorer  and select Edit with/Open with
Notepad++ or Notepad.

How does a network server differ from an ordinary PC linked to the network?

A server is a powerful computer that controls the network and is different
from an ordinary PC that is known as a client computer because it provides
resources and services to all the computers that are linked together in a
network.

Is there any difference between data and information? Motivate your answer.

Data refers to raw, unprocessed facts and computers take data and process
it into useful information.

List two ways to protect sensitive data

Passwords/encryption and physical safekeeping and backups

give ONE reason why a company would prefer the use of
physical keyboards?

Keyboards offer a more accurate way of capturing data since the touch
pad on a screen is smaller.

You could have applications that require the selection of two keys at a
time and this is easier on a keyboard.

Most of the operators will sit at a workstation and it is therefore better to
have a keyboard to capture data quickly.

Shortcut keys can be used to speed up work.

Touch pad could get very dirty and sticky.

Give ONE
advantage of using a barcode scanner.

When the barcode is scanned, all the information of the customer is
automatically identified.

If the price or the parcel weight changes, it can be changed at one
central place on another computer and the labels will be updated.

Labels can be used to assist in tracking the parcel as it gets scanned
through the different locations that it needs to pass through before
delivery

Give THREE examples of specialised input or output devices that would
assist a visually impaired operator.

Braille keyboard

Braille 'display'

Magnification devices

Large-key keyboards

why is it more important for hardware
to satisfy the recommended requirements of a new software program, rather than the minimum requirements of the software

Minimum requirements are the bare minimum specifications needed to
install and use the software.If you use the recommended requirements
instead of the minimum requirements, you will ensure that the software runs
effectively/efficiently/at its best

List FOUR important elements that should be in any chart to ensure that a
chart will be readable, understood and effective.

Title of the chart

Values on chart (Data Lables)

Gridlines

Correct use of series

Labelling of vertical axis and horizontal axis

Legends

Error bars

Colour coding the data points

Define the term Disk Clean-up and explain
how it works.

Disk Clean-up – utility software designed to free up disk space on a
computer's hard drive.The utility first searches and analyses the hard drive for files that are no longer of any use, and then removes the unnecessary files.

Give ONE reason why a cookie could be beneficial to a client, apart from
ensuring you get the best experience when visiting a website.

Cookies provide a way for the website to recognise you.
Cookies keep track of your preferences.
Cookies store account information for the websites you visit.

what is a web browser

A web browser is a type of application software used to allow people
to access and view web pages on the internet.

what is a search engine ?

A search engine is also software (located on a website), but it is used
to search for documents located on the internet by using keywords
or phrases entered by the user when looking for information

A term used in computing to describe a
substitute for one or more characters in a search
string.

Wild card

An example of a microblogging service.

Twitter

A service that provides online storage of data,
anywhere and at any time

Dropbox

A business that gives a client access to the
Internet at a monthly cost.

ISP

The process where documents are waiting in a
queue to be printed.

Spooling

To correct the display on a monitor that appears to be the wrong size or out of focus, you would need to correct the … of the monitor.

resolution

The Excel function =SUM(A1:B2) will add together values in …

cells A1, A2, B1 and B2.

The process of getting data from a CSV file into an application is called …

importing

A cellular technology representing the generation of technologies that operate
at speeds of up to 100 Mbps.

LTE

When you create a profile on a social networking platform you can manage
your username, password, and the way you receive notifications by using
the …

account settings

Which keyboard shortcut would NOT change the content
or layout of a Word document?

<Ctrl><P>

Which database object allows you to set a primary key?

Table

Which device is classified as both an input and an output device?

Headset

....is an example of a network that is spread over a city.

MAN

A is a website that allows users to work together on changing its
content, using a web browser.

wiki

To identify a person who is not a robot a .... identifying code
can be used.

CAPTCHA

When presenting information in a report you often use formatting such as bold and italics. To retain the formatting, you must save the file as an ..... file

.rtf file

The speed used to connect to a network is usually expressed in terms of

Mbps

What does MAN stand for?

Metropolitan Area Network

What is a wiki?

A collaborative website

What is CAPTCHA?

A tool to verify a human user

What is .rtf?

A file format that keeps formatting

What is Mbps?

A unit for network speed

What is metadata?

Data about data

What code/signature identifies a virus?

Virus definition

What is an update to software?

A patch or new features

What is an SD card?

Small flash memory storage

What are guidelines for online behaviour called?

Acceptable Use Policy

What code/signature identifies a virus?

Virus definition

What is an update to software?

A patch or new features

What is an SD card?

Small flash memory storage

What are guidelines for online behaviour called?

Acceptable Use Policy

Give three environmentally friendly computer practices.

Save power

Recycle hardware

Reduce printing

What are rules for polite online communication called?

Netiquette

Give one example of netiquette.

Don’t spam / respect others

Name two assistive hardware devices.

Trackball

Joystick

What is harassment?

Repeated unwanted messages or harmful info

What is a cyber-attack?

Attack on systems to disrupt access

How can you get help in Word?

Press F1 / use Help menu

What is the advantage of draft printing?

Saves ink

What is the disadvantage of draft printing?

Poor quality

Why might spell check miss errors?

Homophones

Wrong language

Added to dictionary

What shows only certain records in Access?

Filter

Why might =AVERAGE(Score) not work in a spreadsheet?

Must use AVG

Textbox required

Brackets needed

What highlights cells automatically based on rules?

Conditional formatting

How do you put text on multiple lines in a cell?

Wrap text