Shared Flashcard Set

Details

dftdr fgtfyf
ghygjgjjjhujh
29
Chemical Engineering
9th Grade
01/24/2012

Additional Chemical Engineering Flashcards

 


 

Cards

Term
1.Absolute Cell Reference
Definition
A cell reference that does not change when copied
Term
2.Alphabetical order
Definition
See ascending order
Term
3.Amortization
Definition
A method for computing equal periodic payments for an
Term
4.Amortization table
Definition
Displays the interest and principal amounts for each payment
Term
5.Arguments
Definition
The data required by a function.
Term
6.Ascending order
Definition
In order from lowest to highest.
Term
7.AVERAGE
Definition
Function that adds the values ina range of cells and then
Term
8.Chronological
Definition
See Ascending order.
Term
9.Descending
Definition
In order from highest to lowest
Term
10.Destination
Definition
The upper left cell of the range where data is to be pasted
Term
11.Function
Definition
Performs a calculation that results in a single value.
Term
12.If function
Definition
Function that is used to make a decision based on.
Term
13.Installment loan
Definition
Loan that is repaid in a series of periodic payments
Term
14.Key sort column
Definition
The column that contains the values that a sort is based on.
Term
15.Linked cells
Definition
Data that is connected to the source cell and will
Term
16.MAX
Definition
Function that displays the largest value in a range of cells.
Term
17.MIN
Definition
Function that displays the smallest value in a range of cells.
Term
18.PMT
Definition
Function that calculates the periodic payment for an
Term
19.Principal
Definition
The amount of money owed on a loan.
Term
20.Relational Operators
Definition
Used to compare two values
Term
21.Round Function
Definition
Changes a value by rounding it to a specific number of
Term
22.Sorting
Definition
Arranging data in a specified order.
Term
23.Source
Definition
The cell or range of data to be copied when copying or moving
Term
24.Spreadsheet Model
Definition
A worksheet containing data relating to a particular situation.
Term
25.Static
Definition
Copied data that is not connected to the source.
Term
26.Sum
Definition
Function that adds the values in a range of cells.
Term
27.Syntax
Definition
The expected form or structure of a function
Term
28.What-If analysis
Definition
The process of making decision using a spreadsheet.
Term
29.What-If question
Definition
A question that is answered using a worksheet model
Supporting users have an ad free experience!