Infotech English For Computer Users Student's Book - Unit 15
A spreadsheet displays information in the form of a table with a lot of columns and rows - TRUE/FALSE
TRUE
If you type the value 800 in C3, the value in cells C5 and C12 will be recalculated - TRUE/FALSE
TRUE
Spreadsheet programs can generate a variety of charts and graphs - TRUE/FALSE
TRUE
The value of the cell C12 is the result of applying the formula C5-C10 - TRUE/FALSE
TRUE
Each field holds _____
a separate piece of information
A collection of data stored in a PC in a systematic way
database
A _____ is a collection of related data, and the software used in databases to store, organize and retrieve the data is called the _____ , or _____
database database management system DBMS
_______________ 2GB of RAM, 1TB HD Colour 19" 2GB of RAM, 250GB HD DBMS, relational database Anti-virus, anti-spyware 2,400 dpi, PostScript
description
A single piece of information in a record
field
Information is entered into a database via _____
fields
Information is entered into the database via _____. Each field holds a separate piece of information, and the fields are grouped together in _____
fields records
Records are grouped together into _____ which hold large amounts of information
files
A database program lets you create an _____ - a list of records ordered according to the content of certain fields
index
Updating a file means _____
making changes, adding news records or deleting old ones
Some companies have several computers sharing as database over a _____
network
The best database packages also include _____ facilities, which can make businesses more productive
network
_______________ 850€ 170€ 975€ 245€ 60€ 230€ Sub-total (21%)
price
_______________ Ulysses Classic Flat LCD screen Portable Ulysses D5 database Antidote JP Laser printer CQ
product
_______________ 4 4 2 1 6 1
quantify
A database _____ function allows you to extract information according to certain conditions or criteria
query
A tool that allows you to extract information that meets certain criteria
query
A unit of a database file made up of related fields
record
A _____ database maintains separate, related files, but combines data elements from the files for queries and reports
relational
Modern databases are _____ - that is, they are made up of related files: customers and orders, vendors and purchases, students and tutors, etc
relational
To look for specific information, for example the name of an employee
search
This helps you to _____ the database and _____ records into numerical or alphabetical order very quickly
search sort
Most aspects of the program can be protected by user-defined passwords and other _____
security devices
Files can easily be _____ - you can always change fields, add new records or delete old ones
updated
Access to a common database over a network can be protected by using _____
user-defined passwords and other security devices
However, technically, a _____ is a collection of cells grouped on a single layer of the file
worksheet
This worksheet shows the income and expenses of a company. Amounts are given in $millions. The terms _____ and _____ are often used interchangeably
worksheet spreadsheet
Spreadsheets cannot be used as databases - TRUE/FALSE
FALSE
The value of cell B5 is the result of adding the value in cells B2 and B3 - TRUE/FALSE
FALSE
You cannot change the width of columns - TRUE/FALSE
FALSE
In a spreadsheet you can only enter numbers and formulae - TRUE/FALSE
FALSE
To classify records into numerical or alphabetical order
sort
A _____ refers to both the computer program that displays data in rows and columns, and to the table which displays numbers in rows and columns
spreadsheet
A database management system is used to _____
store organize and rentrieve information from a database