Upgrade to remove ads
Only $2.99/month

Prometheus Chapter 2

Terms in this set (24)

cell reference that remains constant when a formula is pasted into a new cell
Absolute Cell Reference
Both the column and row references are "relative" and will change when the reference is copied and pasted to other cells
A1
The column reference is "absolute" and will remain constant when copied and pasted to other cells. The row reference is "relative" and will change when copied and pasted to cells in other rows of the worksheet.
$A1
The column reference is "relative" and will change when copied and pasted to cells in other columns in the worksheet. The row reference is "absolute" and will remain constant when copied and pasted to other cells.
A$1
Both the column and row references are "absolute" and will remain constant when the reference is copied and pasted to other cells.
$A$1
calculates the sum of numbers in a sequence
SUM Function
"Function Arguments" window is more commonly known as the
Function Wizard
The function wizard does what?
(1) allows you to enter or select the inputs (called arguments) for the function (2) provides a description of the function and each argument

(3) lists the function result based on the inputs you enter.
used to calculate the number of cells in a specified set of cells that contain a number
COUNT Function
returns the simple average of a set of numbers
AVERAGE Function
calculates the largest value in a set of numbers
MAX Function
calculates the smallest value in a set of numbers
MIN Function
What is special about the MAX and MIN function in excel?
Both functions ignore blank cells and those with non-numeric data
counts the number of cells in a range of cells that are not blank
COUNTA Function
calculates the interest rate earned for an investment given the number of payments made as part of the investment, the payment amount, and the current value of the investment.
RATE Function
calculates the annual percentage rate for an interest rate given the number of times per year that interest is charged.
EFFECT Function
calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount.
NPER Function
calculates the payment amount for a loan given the interest rate, number of payments to be made to pay off the loan, and the original loan amount.
PMT Function
calculates the current value (accounting for compounding interest) of an investment given the interest rate, number of payments to be made, and the amount of the payment.
PV Function
calculates the future value of an investment given the interest rate, number of payments to be made, and the amount of the payment.
FV Function
allows you to see which cells are referenced in a particular formula or function
Trace Precedents Feature
allows you to see which other cells reference a particular cell
Trace Dependents Feature
displays the functions and formulas used in each cell of a worksheet instead of the formula or function results
Show Formulas Feature
To find which formulas or functions reference a particular cell
select the cell and click "Trace Dependents."
YOU MIGHT ALSO LIKE...