Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
30 Cards in this Set
- Front
- Back
|
Field
|
a space allocated for a particular item of information
|
|
|
Key Field
|
allows the user to sort and quickly retrieve information from a database by choosing one or more fields to act as keys
|
|
|
Record
|
contains all the information about a single 'member' of a table
|
|
|
Search
|
to explore or examine in order to discover
|
|
|
Query
|
to make a request for information from a database
|
|
|
Sort
|
to arrange according to class, kind, or size; classify
|
|
|
Database Management System (DMS)
|
a collection of programs that enables you to:
-store -modify & -extract information from a database |
|
|
Mail Merge
|
a feature supported by many word processors that enables you to generate form letters
|
|
|
Absolute Reference
|
- has a $ before the column portion of the reference and/or the row portion of the reference
- does not change when a formula or function is copied and pasted to other cells. |
|
|
Cell
|
the intersection between a column and a row in a worksheet
|
|
|
Cell Range
|
- the parameters the user gives excel
- highlighted/selected range of cells |
|
|
Charts/Graphs
|
- visual representations of worksheet data
- allow the user to easily pick out patterns and trends illustrated |
|
|
Columns
|
- run vertically in a spreadsheet and help to identify the location of data
- identified by a letter in the column heading |
|
|
Function/Formula
|
can be as simple as adding two numbers or can be complex calculations needed for high end business projections
|
|
|
Label
|
- used for titles, headings, names, and for identifying columns of data
- contain letters and numbers |
|
|
Macro
|
- a set of instructions that can be triggered by a keyboard shortcut, toolbar button or an icon in a spreadsheet
- used to eliminate the need to repeat the steps of common tasks over and over |
|
|
Relative Reference
|
consists of the column letter and row number that intersect at the cell's location
|
|
|
Replicate
|
There are two types of replication in spreadsheets: absolute and relative. When using a relative reference, the data will change accordingly to the cells around it. Absolute is when you use dollar signs within a formula to ensure that the formulas do not change accordingly.
|
|
|
Row
|
- run horizontally in a spreadsheet
- identified by a number in the row header |
|
|
Set Print Area (Printing)
|
The default setting in Excel tells the printer to print the entire worksheet. A way to manipulate this is to set a print area. This specifies the exact range of cells to print.
|
|
|
Template
|
a document or file having a preset format, used as a starting point for a particular application so that the format does not have to be recreated each time it is used
|
|
|
Validation
|
provides better testing and documentation of individual spreadsheets in less time
|
|
|
"What if's"
|
An example of a "what if" question would be:
What if I worked this number of hours versus that number in a week, how much would I earn?" |
|
|
Worksheet
|
made of lines and columns
|
|
|
Complex Function
|
converts the specified real and imaginary coefficients into a complex number
|
|
|
Customized Macro
|
macros that the user comes up with and creates on their own
|
|
|
Form
|
a file that can be filled in by users along limited and predefined options
|
|
|
Goal Seek
|
used when you know what answer you want but do not know the exact figure to input for that answer
|
|
|
Nested Function
|
- a way of combining the operations of two or more functions in one cell
- nesting takes one function and uses it as an argument for another function |
|
|
Pivot Table
|
a way to extract data from a long list of information, and present it in a readable form
|
