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.