Java Games: Flashcards, matching, concentration, and word search.

Chapter 10

AB
argumentsThe values that an Excel function uses to perforn calculations or operations
compound criteriaThe use of two or more criteria on the same row- all conditions must be met for records to be included in the results
conditional formattingA format that changes the appearance of a cell
dataFacts about people, events, things, or ideas
databaseAn organized collection of facts related to a specific topic
DAVERAGE functionA function that determines an average in a database that is limited by criteria set for one or more cells
DCOUNT functionA function that counts the number of occurrences of a specified condition in a database
DelimitedA text file in which the text is separated by commas or tabs.
DSUM functionA 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
fieldA specific type of data such as name, emp;oyee number, or social security number that is stored in columns
functionsPredefined formulas that perform calcluations by using specific values, called arguments, in a particular order or structure
Get External Data groupA 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 setsA 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
informationData that das been organized in a useful manner
Microsoft AccessA database program, which you can collect, track, and report data
queryA process of restricking records through the usr of criteria conditions that will display records that will answer a question about the data
recordAll the categories of data pertaining to one person, place, thing, event, or idea
schemaAn XML file that contains the rules for what can and cannot reside in an XML data file
screenshotAn image of an active window on your computer that you can insert into a worksheet
syntaxThe arrangement of the arguments in a function
tableInformation stored in a format of rows and columns
CONCATENATEA text function used to join up to 255 strings of characters.
Data connectionA link to external data that automatically updates an Excel workbook from the original data whenever the original data source gets new information.
Flash FillAn 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.
LEFTA text function that returns the specified number of characters from the beginning (left) of a string of characters.
LOWERA text function that changes the case of the characters in a string, making all characters lowercase.
MIDA text function that extracts a series of characters from a text string given the location of the beginning character.
PROPERA text function that capitalizes the first letter of each word.
RIGHTA text function that returns the specified number of characters from the end (right) of a string of characters.
Text functionA function that can be used to combine or separate data, change case, and apply formatting to a string of characters.
TRIMA text function that removes extra blank spaces from a string of characters.
UPPERA text function that changes the case of the characters in a string, making all characters uppercase.
WizardA feature in Microsoft Office programs that walks you step by step through a process.


Computer Applications Instructor
Renton Technical College
Renton, WA

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities