ICDL Exam Cram 2

Rules that control who can perform actions with files and other resources on a computer.

Stored email contact information.

A function, such as Excel's SUM and COUNT , that operates on a range of data to produce a single result.

A device capable of storing or displaying a smooth range of values, for example, a mercury thermometer.

Software that is used for a particular task, such as writing a letter, displaying a file, or composing music.

A type of high-speed phone line that carries more information in one direction than the other.

An Excel feature to quickly fill in information such as days of the week or months of the year.

A copy of your files. Some people (and most organizations) routinely backup their entire systems.

A system for representing numbers using only the digits 1 and 0. It is the system that computers use internally.

A single piece of yes or no information.

A measurement of the speed of data transmission.

Stored links that quickly access the Internet pages you view frequently.

The process of turning on your system.

Eight bits of information.

Web pages and other files that are stored on your local system for quicker viewing.

A storage device resembling a music CD.

The basic unit of an Excel worksheet.

Part of an Excel formula that refers to another cell. Cell references can be absolute ($A$1) or relative (A1).

(1) The integrated circuit that provides the brain of a computer.

(2) Informally, the box housing the CPU circuit and other hardware.

A computing scheme in which a central server delivers information to and receives updates from many client computers.

The structural part of a table that composes a field.

Electronic reduction of a file size or folder.

A small text file left on your local system by a Web site.

An expression that limits the results of a query.

Stores data in tables built of rows and columns .

A removable storage device most suited for backups of information.

In a mail merge, the document that contains the unique data that personalizes each letter.

A field property that defines what type of data the field can store.

A PowerPoint file containing elements such as colors and fonts that you can use to apply a consistent look to a presentation.

The mode in which you modify a database object's design.

An onscreen work area. In Windows , it's the screen that greets you when you turn on your system and from where you can launch your most often used applications and files.

Shortcut icon that works the same as the Start menu item.

A device that stores information in discrete values. Computers are digital devices that use the values 1 and 0 for storage.

A camera that stores photographs in memory rather than on film.

Code that allows you to send an encrypted message via a secure Web site.

Similar to digital certificate but used with email.

A removable storage device that holds a small amount of data.

Transfer of data from a Web site to your local system.

A Windows method of selecting and dragging screen elements from one position to another.

European Computer Driving License. The ECDL is administered by the ECDL Foundation, http://www.ecdl.com.

Purchasing of goods or services over the Internet.

Transmission of messages and files over the Internet.

A type of security by which the process translates text into code.

A legal contract that governs the acceptable use of a software package.

A branch of applied science that is concerned with designing workplaces that are both efficient and comfortable.

The three or four characters following the dot character ( . ) at the end of a filename.

A network that connects a company with its business partners .

The smallest unit of data in a table.

A method used to transfer files over the Internet.

A built-in feature that locates text within a document.

A storage element in which you can store other folders and files.

A primary key value in a related table. Foreign keys provide a way to link data in one table with data in another table.

A database object by which you can interact with the data.

To prepare a storage device so that it can store computer files.

An instruction to Excel that tells it how to calculate the contents of a particular cell.

Software that may be legally used without paying a license fee.

In Excel, an operation that keeps some cells visible even when you scroll to another location in the worksheet.

In Excel, a built-in calculation such as SUM , COUNT , or AVERAGE .

One billion operations per second, a measure of CPU speed.

A user interface featuring windows, icons, colors, and fonts.

A storage device designed to permanently hold large amounts of data.

All the physical parts of a computer.

Stored links in your Web browser that track the sites you've recently visited.

Text that, when clicked, accesses another area of the current document, another file, or another Web page.

The method that computers use to communicate with other computers over the World Wide Web.

International Computer Driving License. It is the version of the ECDL for countries outside Europe.

A small image that represents an object or file.

A visual representation from a disk file.

An internal structure that stores key values which act as pointers to the stored data.

The general term for all the hardware, software, and services associated with computer use.

Any piece of hardware that you can use to send information to the computer.

The language used to enter text at any given time.

A type of high-speed phone line for fast computer networking.

A single global wide area network (WAN) that connects millions of computers together.

Company that provides access to the Internet.

A network that connects computers belonging to a single company.

An input device that is similar to an airplane's control stick.

A portable computer that is designed to be folded up to protect its screen.

An input device that allows you to select an area directly onscreen.

A network that connects the computers at a single location.

The process of merging two documents into one, new document.

The document that contains the repeated data (form letter) in a mail merge.

A large computer that is typically used to run the operations of an entire department or company.

A slide whose elements are shown on every slide in a PowerPoint presentation.

One million operations per second, a measure of CPU speed.

Element at the top of an application window that displays built-in features and options.

Field codes within the body of the main document that match fields in the data source document.

An input device that lets you issue voice commands to a computer.

A device for converting digital computer data to analog phone signals and vice versa.

An output device that displays information on a screen.

A list of files that you have recently opened in a particular application, normally found at the bottom of the File menu.

An input device that lets you control a cursor onscreen by moving around on a flat surface.

The ability of the computer to perform more than one task at the same time. For example, you can open both a word processing program and a spreadsheet at the same time.

Rules of proper online behavior.

A computer that relies on devices elsewhere on the network to store information for it.

An association between two tables where a primary key value can relate to one, many, or even no records in the related table.

An association between two tables where a primary key value relates to only one (or no) record in the related table.

Software that controls the basic operations of the computer.

An accessory card in the base unit of a computer that handles video display, network communications, or other tasks .

Any piece of hardware that the computer can use to send information to you.

A nonprintable character that determines the end of a paragraph.

A secret piece of information used to verify your identity to the computer.

Any device that is outside of the computer's main base unit.

A computer that fits on or under an individual desktop and that stores its own information.

A shirt-pocketsize computer with limited storage capacity.

A visual representation from a built-in set of images in an application.

An output device that uses one or more pens to create drawings.

A single PowerPoint file containing one or more slides.

The field or fields that uniquely identify a record.

An output device that prints text or graphics on paper.

A piece of software with a particular function.

Begins each word with an uppercase letter; the remaining letters in the word are lowercase.

The normal voice telephone network.

A database object that answers questions about the data by selecting and limiting the data you see.

Computer memory that can be either read or written but which loses its contents when you switch the computer off.

Describes a file you can view but not change.

Computer memory whose contents cannot be altered but which maintains its value even when the power is removed.

Describes a file you can both view and change.

The actual data for one entity in a table.

A Windows folder that stores deleted files.

Rules that control when data can be added, modified, or deleted.

A database application that stores and manipulates data and allows for relationships to be formed between tables.

An association between two tables.

A database object that displays data in meaningful groups and orders.

The beginning level of storage on a hard drive or diskette.

The related fields that compose a record.

An input device that can convert printed text or graphics into computer files.

System setting that determines the size of screen elements (by changing the total number of pixels on the screen).

A file that displays moving elements when the computer is idle for a specific length of time.

A graphical element that allows you to view data that extends past the right or bottom of the screen.

An online service that provides links to target documents.

Software that can be freely used for a limited period of time without paying a licensing fee.

Icons that execute defined tasks, such as opening a file.

A single screen of information within a presentation.

Similar to the paragraph mark in that it forces text to the next line.

The intangible instructions that tell the CPU and hardware what to do.

An output device that conveys information by means of sound.

An Excel file containing one or more worksheets.

An element that constantly updates with information about the current task or environment.

Any device designed to store computer files.

A folder within a folder.

An electronic device that protects your system from high voltage spikes that would otherwise destroy your system.

An object used to organize text and graphics in rows and columns.

Commuting by modem instead of physically.

A program that allows you to enter and manipulate text in a document and then saves that document.

Element at the top of a window that displays descriptive text about the window.

Window element that displays built-in features and options by way of icons.

An input device that lets you control the cursor by moving your finger or a stylus around a flat pad.

An input/output device that displays information and allows you to select information by touch.

An input device that lets you control the cursor by moving a ball in a fixed frame.

The speed with which a computer can send information across a network.

In Excel, to allow all rows and columns of a worksheet to scroll freely.

A Web address. Type it into a Web browser to find a Web page you want to view.

An identifier for a particular user on a network.

The mode in which you actually interact with data through database objects.

Malicious computer code that is designed to spread from computer to computer.

Specialized software that scans your system, diskettes, and email for signs of virus infestation.

A software application that accesses information on the Internet.

A network that connects computers at multiple locations.

A symbol that represents one or more characters.

The most common user interface element for displaying and gathering information.

The graphical interface that Windows uses to display the system's file structure.

The contents of a single tab in an Excel spreadsheet. One spreadsheet may contain from one to an unlimited number of worksheets.

A network that uses HTTP to request and display Web pages. It is only one way of accessing all the information available on the Internet.

A removable storage device that holds a few hundred megabytes of information.