CIS125S Chapter 10

Screenshot

An image of an active window on your computer that you can insert into a worksheet.

Database

An organized collection of data related to a particular topic or purpose.

Functions

Predefined formulas that perform calculations by using specific values, called arguments.

Syntax

The arrangement of the arguments in a function.

DSUM

A database function that adds a column of values in a database that is limited by criteria set for one or more cells.

Text function

A function that can be used to combine or separate data, change case, and apply formatting to a string of characters.

TRIM

A function that removes extra blank spaces from a string of characters.

RIGHT

A function that returns the specified number of characters from the end of a string of characters.

CONCATENATE

A function used to join up to 255 strings of characters.

Get External Data

A group of commands that enables you to bring data from an Access database, from the Web, from a text file, or from an XML file into Excel without repeatedly copying the data.

Icon sets

A group of three, four, or five small graphic images that make your data visually easier to interpret.

Extensible Markup Language (XML)

A language that structures data in text files so that it can be read by other systems, regardless of the hardware platform or operating system.

Query

A process of restricting records through the use of criteria conditions that displays records that answer a question about the data.

Delimited

A text file in which the text is separated by commas or tabs.

Record

All the categories of data pertaining to one database item such as a person, place, thing, event, or idea, stored in a horizontal row in a database.

Flash Fill

An Excel feature that predicts how to alter data based upon the pattern you enter into the cell at the beginning of the column.

Importing

Bringing data in from an external data source is known as:

Data

Facts about people, events, things, or ideas.

Conditional formats

Formatting characteristics that are applied to cells when the value in the cell meets a specified condition are called:

Field

Information that describes a record and is stored in columns.

Data connection

Link to external data that automatically updates an Excel workbook from the original data whenever the original data source gets new information.

Compound criteria

The use of two or more conditions on the same row—all of which must be met for the records to be included in the results.