Shared Flashcard Set

Details

Excell
Terms
25
Computer Science
Undergraduate 1
12/08/2014

Additional Computer Science Flashcards

 


 

Cards

Term
Table
Definition
Refers to a database
Term
Database
Definition
Organizational collection of data
Term
Field
Definition
Categories of information from the column headings
Term
Record
Definition
Combine the fields from a row
Term
Query
Definition
Allows us to filter what data we want shown. Process of filtering
Term
Tend Line
Definition
Visual way of graphically representing 2 variables usually over time as to their relationship to each other. Also calculate the R value.
Term
Pivot table report
Definition
Interactive view of data summarized by selecting categories to group the data
Term
Pivot chart report
Definition
Interactive chart view were we can change groupings that represent the data
Term
Slicer
Definition
In pivot charts and tables we can filter data on charts and tables representing them wit a graphical object
Term
Formula auditing
Definition
Check cells referenced in formulas and check formulas referenced in cells
Term
Data validation
Definition
Specify certain types values be accepted in a cell
Term
Solver
Definition
The power house to solve large problems instead of trial and error. Up to 200cells
Term
Constraints
Definition
Limitations imposed on possible value a cell can have
Term
Answer report
Definition
Shows the answer solver derived including what was manipulated and the constraints used.
Term
Scenario manager
Definition
Analysis tool to record and save sets of what-if assumptions
Term
Tracer Arrows
Definition
Blue arrows that point from cell to cell referencing cells in a formula
Term
Precedent
Definition
Cell represented in a formula. If a1+a2 equals a3,a1and a2 are precedent and upstream to A3. A3 is dependent of a1 2
Term
Linear programming
Definition
Mathamtical process of solving problems
Term
Changing cells
Definition
Those cells used in solver that are adjustable in deriving an answer
Term
Target cells
Definition
Cells used in solver whose value solver tries to meet by adjusting the changing cells
Term
Scenario summary worksheet
Definition
These are the productions given us in the summary manager
Term
Procedure
Definition
A step by step process that continues until the task is completed
Term
Data form
Definition
Method of data entering by creating forms or fields from the column headings
Term
VBA
Definition
Visual basic application to extend the capabilities of excel
Term
Macro
Definition
Procedure derived from VBA
Supporting users have an ad free experience!