Upgrade to remove ads
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
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.
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.
Both the column and row references are "absolute" and will remain constant when the reference is copied and pasted to other cells.
calculates the sum of numbers in a sequence
"Function Arguments" window is more commonly known as the
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
returns the simple average of a set of numbers
calculates the largest value in a set of numbers
calculates the smallest value in a set of numbers
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
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.
calculates the annual percentage rate for an interest rate given the number of times per year that interest is charged.
calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount.
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.
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.
calculates the future value of an investment given the interest rate, number of payments to be made, and the amount of the payment.
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...
Microsoft Excel Lesson 5 Vocabulary
Lesson 5 Vocab
Excel Workshop 3 & 4
OTHER SETS BY THIS CREATOR
MKTG 436 - Chapter 17
MKTG 436 - Chapter 16
MKTG 436 - Chapter 15
MKTG 436 - Chapter 14