review for finals Flashcards
review pack (41 cards)
What is a Cell Reference?
Each cell has an address made up of a letter and number.
What is a Database?
An organized set of data made up of records and fields.
What is a Filter?
Allows user to hide the data that does not meet the criteria.
What is RAM?
Stores programs that are being used by the computer.
What is a Server?
Networked device that serves data to other devices.
What is Block based programming?
Programming language that uses blocks which we can drag and drop in a code.
What does it mean to Upgrade?
It means to improve something or replace it with a better version.
What is Digitise?
Conversion of analogue data to digital data that a computer can process.
What is a Password?
A secret string of words, numbers, and characters that a user sets.
What is a Cell in a spreadsheet?
Each box in the grid of a spreadsheet.
Identify the data type of ‘Japan’.
String.
Identify the data type of ‘3777933’.
Integer.
Identify the data type of ‘1$_H3llo’.
String.
Identify the data type of ‘#’.
Character.
Identify the data type of ‘$’.
Character.
What are the fields in the record about Qatar?
Qatar, 11,636.8 km², 2,656,000, Arabic, Qatari Riyal.
What are the attributes of the record about Qatar?
Country, Size (in km²), Population, Language, Currency.
What are the two kinds of connection for transferring data?
Examples include wired and wireless connections.
What are arithmetic operators? Give 3 examples.
Arithmetic operators are symbols used to perform mathematical operations. Examples: + (addition), - (subtraction), * (multiplication).
Is Secondary storage long-term and retains data even when the computer is turned off?
True.
Is a transistor a tiny device that controls the flow of electricity in the CPU?
True.
Is SUM=(D3:D40) a function that we would use to calculate the total values of cells D3 to D40?
True.
Do Ranking questions allow users to write their own answer?
False.
Is a field in a database a category of data within a record?
True.
