A | B |
arguments | The values that an Excel function uses to perforn calculations or operations |
compound criteria | The use of two or more criteria on the same row- all conditions must be met for records to be included in the results |
conditional formatting | A format that changes the appearance of a cell |
data | Facts about people, events, things, or ideas |
database | An organized collection of facts related to a specific topic |
DAVERAGE function | A function that determines an average in a database that is limited by criteria set for one or more cells |
DCOUNT function | A function that counts the number of occurrences of a specified condition in a database |
Delimited | A text file in which the text is separated by commas or tabs. |
DSUM function | A function that sums a column of values in a database that is limited by criteria set for one or more cells |
Extensible Markup Language (XML) | A language that structures data in text files so that it can be read by other systems, regurdless of the hardware platform or operating system |
field | A specific type of data such as name, emp;oyee number, or social security number that is stored in columns |
functions | Predefined formulas that perform calcluations by using specific values, called arguments, in a particular order or structure |
Get External Data group | 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 and are used to add emphasis to the conditional format of a list |
information | Data that das been organized in a useful manner |
Microsoft Access | A database program, which you can collect, track, and report data |
query | A process of restricking records through the usr of criteria conditions that will display records that will answer a question about the data |
record | All the categories of data pertaining to one person, place, thing, event, or idea |
schema | An XML file that contains the rules for what can and cannot reside in an XML data file |
screenshot | An image of an active window on your computer that you can insert into a worksheet |
syntax | The arrangement of the arguments in a function |
table | Information stored in a format of rows and columns |
CONCATENATE | A text function used to join up to 255 strings of characters. |
Data connection | A link to external data that automatically updates an Excel workbook from the original data whenever the original data source gets new information. |
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. The data must be in the adjacent column to use Flash Fill. |
LEFT | A text function that returns the specified number of characters from the beginning (left) of a string of characters. |
LOWER | A text function that changes the case of the characters in a string, making all characters lowercase. |
MID | A text function that extracts a series of characters from a text string given the location of the beginning character. |
PROPER | A text function that capitalizes the first letter of each word. |
RIGHT | A text function that returns the specified number of characters from the end (right) of a string of characters. |
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 text function that removes extra blank spaces from a string of characters. |
UPPER | A text function that changes the case of the characters in a string, making all characters uppercase. |
Wizard | A feature in Microsoft Office programs that walks you step by step through a process. |