WorksheetsCambridge National in IT - Glossary of Terms
Total questions: 130
Worksheet time: 1hrs 5mins
Name
Class
Date
1.
Cell references with a $ sign in front of the column and row references - e.g. =SUM($A$1:$D$1) - do not change when the function or formula is copied or moved.
a)
Absolute cell referencing
b)
Access rights
c)
Adware
d)
ANPR
e)
Assets
2.
Control over who has access to a computer system, folder, files, data and/or information.
a)
Absolute cell referencing
b)
Access rights
c)
Adware
d)
ANPR
e)
Assets
3.
Advertising-supported software.
a)
Absolute cell referencing
b)
Access rights
c)
Adware
d)
ANPR
e)
Assets
4.
Automatic Number Plate Recognition.
a)
Absolute cell referencing
b)
Access rights
c)
Adware
d)
ANPR
e)
Assets
5.
Items such as images or videos to be included in the final product.
a)
Absolute cell referencing
b)
Access rights
c)
Adware
d)
ANPR
e)
Assets
6.
A list of all the resources used in a project.
a)
Asset log
b)
Backup
c)
Bias
d)
Biometric protection measure
e)
Blog
7.
A copy of the data or files that are currently in use. Backups are made regularly and stored away from the computer system, preferably in another building in a secure place.
a)
Asset log
b)
Backup
c)
Bias
d)
Biometric protection measure
e)
Blog
8.
An unfair inclination towards or against a person or group of people.
a)
Asset log
b)
Backup
c)
Bias
d)
Biometric protection measure
e)
Blog
9.
A measure that uses a person's physical characteristic, for example a fingerprint, eye scan or voice.
a)
Asset log
b)
Backup
c)
Bias
d)
Biometric protection measure
e)
Blog
10.
A regularly updated website or web page that is usually run by one person, the blogger, or by a very small group of people.
a)
Asset log
b)
Backup
c)
Bias
d)
Biometric protection measure
e)
Blog
11.
An interconnected network of infected computer systems.
a)
Botnet
b)
Box set
c)
Buffering
d)
Caption
e)
Check boxes
12.
A complete set of programmes in a series, which can be downloaded and watched one after the other.
a)
Botnet
b)
Box set
c)
Buffering
d)
Caption
e)
Check boxes
13.
When an internet connection is too slow to show a resource in real time.
a)
Botnet
b)
Box set
c)
Buffering
d)
Caption
e)
Check boxes
14.
The title or label of a diagram, drawing or photograph.
a)
Botnet
b)
Box set
c)
Buffering
d)
Caption
e)
Check boxes
15.
These show a Yes/No choice - ticked when Yes, empty (clear or unticked) when No.
a)
Botnet
b)
Box set
c)
Buffering
d)
Caption
e)
Check boxes
16.
The document that details the client's requirements.
a)
Client brief
b)
Closed question
c)
Comment
d)
Concurrent
e)
Content table
17.
A question with only a set number of answers to be chosen from, for example for 'Can you ride a bicycle?' the answers would be either 'Yes' or 'No'.
a)
Client brief
b)
Closed question
c)
Comment
d)
Concurrent
e)
Content table
18.
A note attached to a piece of text.
a)
Client brief
b)
Closed question
c)
Comment
d)
Concurrent
e)
Content table
19.
Tasks that can be completed at the same time.
a)
Client brief
b)
Closed question
c)
Comment
d)
Concurrent
e)
Content table
20.
A list at the front of a book or report showing what is in the book or report.
a)
Client brief
b)
Closed question
c)
Comment
d)
Concurrent
e)
Content table
21.
Time in a project plan with no tasks assigned. This is used if tasks are not completed on time, to make sure the project still meets the final deadline.
a)
Contingency Time
b)
Critical path
c)
Critical path method
d)
CSS (cascading style sheets)
e)
CSV file
22.
The sequence of tasks that shows the shortest time taken for completion of a project.
a)
Contingency Time
b)
Critical path
c)
Critical path method
d)
CSS (cascading style sheets)
e)
CSV file
23.
A planning technique that aims to prevent time bottlenecks by showing the critical and non-critical tasks for the completion of a project.
a)
Contingency Time
b)
Critical path
c)
Critical path method
d)
CSS (cascading style sheets)
e)
CSV file
24.
Are used to control the presentation of the content on a website.
a)
Contingency Time
b)
Critical path
c)
Critical path method
d)
CSS (cascading style sheets)
e)
CSV file
25.
A type of plain text file where the fields are separated by commas and the records are separated by carriage returns.
a)
Contingency Time
b)
Critical path
c)
Critical path method
d)
CSS (cascading style sheets)
e)
CSV file
26.
Raw facts and figures before they have been processed.
a)
Data
b)
Data dictionary
c)
Data encryption software
d)
Data subject
e)
Data theft
27.
A description of the structure, contents and format of a spreadsheet or a database. The relationships within the database are also included.
a)
Data
b)
Data dictionary
c)
Data encryption software
d)
Data subject
e)
Data theft
28.
Software that is used to encrypt a file or data.
a)
Data
b)
Data dictionary
c)
Data encryption software
d)
Data subject
e)
Data theft
29.
The person the data is being stored about.
a)
Data
b)
Data dictionary
c)
Data encryption software
d)
Data subject
e)
Data theft
30.
Happens when cyber-security attackers steal computer-based data from a person or business, with the intent of compromising privacy or obtaining confidential data.
a)
Data
b)
Data dictionary
c)
Data encryption software
d)
Data subject
e)
Data theft
31.
A specific kind of data item that is defined by the values that can be stored using it or how the data is going to be processed.
a)
Data types
b)
Defamation of character
c)
Delimiter
d)
Denial of Servoce (DoS)
e)
Dependency
32.
When an untrue or false statement is made by one person about another. The statement tries to discredit a person's character or reputation.
a)
Data types
b)
Defamation of character
c)
Delimiter
d)
Denial of Servoce (DoS)
e)
Dependency
33.
A separator between values. The delimiter in this list of fruit is a comma: apples, pears, oranges.
a)
Data types
b)
Defamation of character
c)
Delimiter
d)
Denial of Servoce (DoS)
e)
Dependency
34.
A cyberattack where the attackers attempt to prevent authorised users from accessing the service. During a DoS attack the attacker usually sends lots of messages asking the network/ servers to authenticate requests that have invalid return addresses.
a)
Data types
b)
Defamation of character
c)
Delimiter
d)
Denial of Servoce (DoS)
e)
Dependency
35.
A dependent task is one that cannot be started until.
a)
Data types
b)
Defamation of character
c)
Delimiter
d)
Denial of Servoce (DoS)
e)
Dependency
36.
An attempt to make a computer or network system unavailable to its users by flooding it with network traffic.
a)
Distributed Denial of Service (DDoS)
b)
Distribution channels
c)
Duration
d)
Encryption code/key
e)
Encryption software
37.
The methods that can be used by individuals, organisations or businesses to share information.
a)
Distributed Denial of Service (DDoS)
b)
Distribution channels
c)
Duration
d)
Encryption code/key
e)
Encryption software
38.
How much time a task should take to be completed.
a)
Distributed Denial of Service (DDoS)
b)
Distribution channels
c)
Duration
d)
Encryption code/key
e)
Encryption software
39.
A set of characters, a phrase or numbers that is used when encrypting or decrypting data or a file.
a)
Distributed Denial of Service (DDoS)
b)
Distribution channels
c)
Duration
d)
Encryption code/key
e)
Encryption software
40.
Software that is used to encrypt a file or data.
a)
Distributed Denial of Service (DDoS)
b)
Distribution channels
c)
Duration
d)
Encryption code/key
e)
Encryption software
41.
An item at the end of a book or report containing further information about the content in the text. Usually referenced with a number.
a)
Endnote
b)
Erroneous data
c)
Extreme data
d)
Fake news
e)
Feasibility report
42.
Data that is not acceptable to a computer system.
a)
Endnote
b)
Erroneous data
c)
Extreme data
d)
Fake news
e)
Feasibility report
43.
Data that is on the boundary between data that is acceptable and data that is not acceptable to a computer system. Extreme data should be accepted by a computer system as it is still valid data.
a)
Endnote
b)
Erroneous data
c)
Extreme data
d)
Fake news
e)
Feasibility report
44.
Information that has been made up by the people who have written it.
a)
Endnote
b)
Erroneous data
c)
Extreme data
d)
Fake news
e)
Feasibility report
45.
Created during the initiation stage and considers each of the questions and constraints. Success criteria and objectives are defined in this report. The report forms the basis on which the whole project should be completed.
a)
Endnote
b)
Erroneous data
c)
Extreme data
d)
Fake news
e)
Feasibility report
46.
An individual data item within a record. Each field has a unique name and contains a single data type.
a)
Field
b)
Footer
c)
Footnote
d)
Formula
e)
Function
47.
The section at the bottom of the page that contains information that appears on every page.
a)
Field
b)
Footer
c)
Footnote
d)
Formula
e)
Function
48.
An item at the bottom of a page with further information about the content on a page. Usually referenced with a number.
a)
Field
b)
Footer
c)
Footnote
d)
Formula
e)
Function
49.
A spreadsheet formula carries out calculations on numbers using cell addresses and mathematical operators. It can use the ready made functions.
a)
Field
b)
Footer
c)
Footnote
d)
Formula
e)
Function
50.
Spreadsheet functions are ready-made, uilt-in tools for manipulating data.
a)
Field
b)
Footer
c)
Footnote
d)
Formula
e)
Function
51.
A visual method of showing the proposed timing of each task needed to complete a project.
a)
Gantt chart
b)
GIGO
c)
Goal
d)
Green energy
e)
Group/Grouping
52.
Garbage In, Garbage Out.
a)
Gantt chart
b)
GIGO
c)
Goal
d)
Green energy
e)
Group/Grouping
53.
What you wish to be able to do.
a)
Gantt chart
b)
GIGO
c)
Goal
d)
Green energy
e)
Group/Grouping
54.
The use of natural, renewable resources to generate power.
a)
Gantt chart
b)
GIGO
c)
Goal
d)
Green energy
e)
Group/Grouping
55.
several components can be moved as one. A feature usually found in DTP or word processing software.
a)
Gantt chart
b)
GIGO
c)
Goal
d)
Green energy
e)
Group/Grouping
56.
A person who finds out weaknesses in a computer system to gain unauthorised access.
a)
Hacker
b)
Header
c)
House style
d)
HTML
e)
Identity theft
57.
The section at the top of a page that contains information that appears on every page.
a)
Hacker
b)
Header
c)
House style
d)
HTML
e)
Identity theft
58.
A description of the standards for text and graphics in all of the documents to be produced or used by a company.
a)
Hacker
b)
Header
c)
House style
d)
HTML
e)
Identity theft
59.
(hyper-text mark-up language) is used to place content on a website.
a)
Hacker
b)
Header
c)
House style
d)
HTML
e)
Identity theft
60.
When personal details are stolen and used to commit fraud, for example taking out a loan in someone else's name.
a)
Hacker
b)
Header
c)
House style
d)
HTML
e)
Identity theft
61.
An alphabetical list at the end of a book or report that helps readers to find items of content.
a)
Index
b)
Information
c)
Integrated document
d)
Interaction
e)
Internet of things
62.
Processed data that has a meaning and is in context.
a)
Index
b)
Information
c)
Integrated document
d)
Interaction
e)
Internet of things
63.
A document featuring components from other documents, including spreadsheets, databases or web links.
a)
Index
b)
Information
c)
Integrated document
d)
Interaction
e)
Internet of things
64.
How the phases of the project life cycle link together.
a)
Index
b)
Information
c)
Integrated document
d)
Interaction
e)
Internet of things
65.
The , interconnection via the internet of computing devices embedded in everyday objects, enabling them to send and receive data.
a)
Index
b)
Information
c)
Integrated document
d)
Interaction
e)
Internet of things
66.
The person answering the questions.
a)
Interviewee
b)
Interviewer
c)
Intranet
d)
Iteration
e)
Iterative review
67.
The person asking the questions.
a)
Interviewee
b)
Interviewer
c)
Intranet
d)
Iteration
e)
Iterative review
68.
A private network that is accessible only to those people who have log-in, or access, details.
a)
Interviewee
b)
Interviewer
c)
Intranet
d)
Iteration
e)
Iterative review
69.
The repeating of a phase. Each repetition of a phase, when amendments will be made, is called an iteration. The results of an iteration are used as the starting point of the next.
a)
Interviewee
b)
Interviewer
c)
Intranet
d)
Iteration
e)
Iterative review
70.
Carrying out a review, making changes as a result of the review, and then carrying out another review and making more changes. The process is repeated until the solution is as perfect as it can get.
a)
Interviewee
b)
Interviewer
c)
Intranet
d)
Iteration
e)
Iterative review
71.
Analysing the client brief to determine and highlight the important aspects of the project.
a)
Key-word analysis
b)
Logical protection methods
c)
Magnetic wipe
d)
Maintainability
e)
Malware
72.
Computer based methods that can be put in place by the development team or the network/systems administrator. These aim to reduce, or mitigate, the risks to data being stored.
a)
Key-word analysis
b)
Logical protection methods
c)
Magnetic wipe
d)
Maintainability
e)
Malware
73.
Replaces the data with binary and removes all the basic commands stored on the storage device, making the device unusable.
a)
Key-word analysis
b)
Logical protection methods
c)
Magnetic wipe
d)
Maintainability
e)
Malware
74.
Future development of the product in terms of the use of emerging technologies or adapting to any changes in the client's business or organisation.
a)
Key-word analysis
b)
Logical protection methods
c)
Magnetic wipe
d)
Maintainability
e)
Malware
75.
Malicious software.
a)
Key-word analysis
b)
Logical protection methods
c)
Magnetic wipe
d)
Maintainability
e)
Malware
76.
A given point in time when a task is expected to be started or completed.
a)
Milestone
b)
Mobile apps
c)
MOOC
d)
Normal data
e)
Objective
77.
Applications, apps, that are designed to be run on a mobile device such as a tablet or smartphone.
a)
Milestone
b)
Mobile apps
c)
MOOC
d)
Normal data
e)
Objective
78.
A Massive Open Online Course is an online course with unlimited numbers of students and open access via a website.
a)
Milestone
b)
Mobile apps
c)
MOOC
d)
Normal data
e)
Objective
79.
Data that is acceptable to a computer system.
a)
Milestone
b)
Mobile apps
c)
MOOC
d)
Normal data
e)
Objective
80.
What you actually have to do or carry out.
a)
Milestone
b)
Mobile apps
c)
MOOC
d)
Normal data
e)
Objective
81.
Allows the person completing the questionnaire to give a detailed answer in their own words.
a)
Open question
b)
option boxes (or radio buttons)
c)
Password
d)
Patches
e)
Permissions
82.
Allow users to select only one choice from two, mutually exclusive options. The choice is either 'this one' or 'that one', not both.
a)
Open question
b)
option boxes (or radio buttons)
c)
Password
d)
Patches
e)
Permissions
83.
A set of characters that allows access to a computer system.
a)
Open question
b)
option boxes (or radio buttons)
c)
Password
d)
Patches
e)
Permissions
84.
Updates released by software vendors for their software.
a)
Open question
b)
option boxes (or radio buttons)
c)
Password
d)
Patches
e)
Permissions
85.
A set of attributes that determine what a user can do with files and folders, for example read, write, edit or delete.
a)
Open question
b)
option boxes (or radio buttons)
c)
Password
d)
Patches
e)
Permissions
86.
Information held about an individual, such as date of birth, contact details, credit reference files or health records.
a)
Personal data
b)
PERT
c)
Physical protection methods
d)
Primary research method
e)
Project life cycle
87.
Program Evaluation Review Technique.
a)
Personal data
b)
PERT
c)
Physical protection methods
d)
Primary research method
e)
Project life cycle
88.
Security methods that are designed to deny unauthorised access to computer equipment, resources or buildings.
a)
Personal data
b)
PERT
c)
Physical protection methods
d)
Primary research method
e)
Project life cycle
89.
When the data and information collected is fresh data collected for a specific purpose.
a)
Personal data
b)
PERT
c)
Physical protection methods
d)
Primary research method
e)
Project life cycle
90.
Has the phases: initiation; planning; execution; evaluation.
a)
Personal data
b)
PERT
c)
Physical protection methods
d)
Primary research method
e)
Project life cycle
91.
The person who is in overall charge of the project. They do not carry out any of the development tasks associated with the project but manage the tasks, people and resources needed.
a)
Project manager
b)
Project scope
c)
Public authorities
d)
Query
e)
Range
92.
Breaking down a project into manageable tasks.
a)
Project manager
b)
Project scope
c)
Public authorities
d)
Query
e)
Range
93.
Include government departments, the NHS, state schools and the police force.
a)
Project manager
b)
Project scope
c)
Public authorities
d)
Query
e)
Range
94.
A way of interrogating and manipulating data within a database. A query has rules that filter to the specific data needed.
a)
Project manager
b)
Project scope
c)
Public authorities
d)
Query
e)
Range
95.
A group of cells in a spreadsheet.
a)
Project manager
b)
Project scope
c)
Public authorities
d)
Query
e)
Range
96.
Rank order Requires the person completing the questionnaire to compare a list of the same type of items. The items are then ranked, for example from 1 to 10 where 1 is very important and 10 is least important.
a)
Rank order
b)
Rating
c)
Real time
d)
Real-time backup
e)
Real-time data (RTD)
97.
Requires the person completing the questionnaire to rate items on a list individually, for example from 1 to 10 where 1 is very important and 10 is least important.
a)
Rank order
b)
Rating
c)
Real time
d)
Real-time backup
e)
Real-time data (RTD)
98.
When the computer system is connected to the internet the software will automatically be checking all the time for new updates.
a)
Rank order
b)
Rating
c)
Real time
d)
Real-time backup
e)
Real-time data (RTD)
99.
When a backup is automatically carried out each time a change is made to the data.
a)
Rank order
b)
Rating
c)
Real time
d)
Real-time backup
e)
Real-time data (RTD)
100.
Data that is delivered immediately after it has been collected.
a)
Rank order
b)
Rating
c)
Real time
d)
Real-time backup
e)
Real-time data (RTD)
101.
A collection of data about a single item, such as a single student or customer. Each record must be unique.
a)
Record
b)
Relative cell referencing
c)
Reliability
d)
Resources
e)
RFID
102.
Cell references - e.g. ESUM(A1:D1) - that change when the function or formula is copied or moved.
a)
Record
b)
Relative cell referencing
c)
Reliability
d)
Resources
e)
RFID
103.
If the data and information is correct and can be verified.
a)
Record
b)
Relative cell referencing
c)
Reliability
d)
Resources
e)
RFID
104.
The things needed to complete the project. These may include hardware, software and the different specialist roles such as programmers and testers.
a)
Record
b)
Relative cell referencing
c)
Reliability
d)
Resources
e)
RFID
105.
Radio Frequency Identification Tags can use radio frequency to transfer data from the tags to a computer.
a)
Record
b)
Relative cell referencing
c)
Reliability
d)
Resources
e)
RFID
106.
A possible action or inaction to/in the project that, slows it down or prevents it being completed.
a)
Risk
b)
Risk mitigation
c)
Secondary research methods
d)
Section
e)
Social engineering
107.
Creating options and actions to reduce risks and threats to the project.
a)
Risk
b)
Risk mitigation
c)
Secondary research methods
d)
Section
e)
Social engineering
108.
Methods that use data and information that has already been collected, for example using a book or website to find out statistics that have already been collected and, possibly, processed.
a)
Risk
b)
Risk mitigation
c)
Secondary research methods
d)
Section
e)
Social engineering
109.
An area of a page that has its own formatting.
a)
Risk
b)
Risk mitigation
c)
Secondary research methods
d)
Section
e)
Social engineering
110.
The art of manipulatingpeople so that confidential information can be found out.
a)
Risk
b)
Risk mitigation
c)
Secondary research methods
d)
Section
e)
Social engineering
111.
A product that doesn't move, for example a CD/DVD/Blu-ray cover, poster or magazine front cover.
a)
Static product
b)
Strong password
c)
Sum
d)
SWOT
e)
Table
112.
A password usually consisting of six or more characters that are a mixture of upper- and lower case letters, numbers and symbols so that it is very difficult to guess. Not all computer systems allow all characters to be used.
a)
Static product
b)
Strong password
c)
Sum
d)
SWOT
e)
Table
113.
A function used to add up values.
a)
Static product
b)
Strong password
c)
Sum
d)
SWOT
e)
Table
114.
Analysis to find out the Strengths, Weaknesses, Opportunities and Threats of/to a project. Table Contains data about things', for example students, customers or orders.
a)
Static product
b)
Strong password
c)
Sum
d)
SWOT
e)
Table
115.
Contains data about 'things, for example students, customers, orders. Each table has a unique name and contains data held in records.
a)
Static product
b)
Strong password
c)
Sum
d)
SWOT
e)
Table
116.
A plain text file. For importing into Excel, a text file uses tabs or spaces as delimiters for fields and carriage returns to separate records. A file using tabs may be called a TSV file.
a)
Text file
b)
Track Changes
c)
Validation
d)
Validity
e)
Verification
117.
A system of making changes to text but retaining the original text so that changes can be seen and, if required, reversed.
a)
Text file
b)
Track Changes
c)
Validation
d)
Validity
e)
Verification
118.
Can include length checks, presence checks, format checks, range checks and input masks.
a)
Text file
b)
Track Changes
c)
Validation
d)
Validity
e)
Verification
119.
How believable the data and information collected is.
a)
Text file
b)
Track Changes
c)
Validation
d)
Validity
e)
Verification
120.
A check to see whether the data being entered into a computer system is identical to the source from which it came.
a)
Text file
b)
Track Changes
c)
Validation
d)
Validity
e)
Verification
121.
A video blog.
a)
vLog
b)
VoIP
c)
Vulnerabilities
d)
Watermark
e)
Weak password
122.
VoIP Voice over Internet Protocol is a system that enables voice calls to be made over the internet.
a)
vLog
b)
VoIP
c)
Vulnerabilities
d)
Watermark
e)
Weak password
123.
Weaknesses that allow an attacker to launch a cyber-security attack.
a)
vLog
b)
VoIP
c)
Vulnerabilities
d)
Watermark
e)
Weak password
124.
A pattern printed or inserted across an image or document.
a)
vLog
b)
VoIP
c)
Vulnerabilities
d)
Watermark
e)
Weak password
125.
One that is easy to find out, or guess, by both people and computers.
a)
vLog
b)
VoIP
c)
Vulnerabilities
d)
Watermark
e)
Weak password
126.
are designed to read HTML documents and to display them. Web browsers use HTML tags to determine how to display HTML documents.
a)
Web browsers
b)
Workbook
c)
Workflow
d)
Worksheet
e)
WYSIWYG
127.
A collection of worksheets.
a)
Web browsers
b)
Workbook
c)
Workflow
d)
Worksheet
e)
WYSIWYG
128.
What task is dependent on another, what task has to be completed before moving on to the next and which tasks can be completed at the same time as others.
a)
Web browsers
b)
Workbook
c)
Workflow
d)
Worksheet
e)
WYSIWYG
129.
One spreadsheet contained within a workbook.
a)
Web browsers
b)
Workbook
c)
Workflow
d)
Worksheet
e)
WYSIWYG
130.
What You See Is What You Get.
a)
Web browsers
b)
Workbook
c)
Workflow
d)
Worksheet
e)
WYSIWYG
100 %
