IDM 1020 midterm prep

Large function does what

Data set first and need rank number

Small function

Same as large function

Absolute cell referenceing

is a way to keep a cell reference constant when copying a formula across multiple cells, denoted by a dollar sign ($) before the column and row identifiers.
You want it in front of the letter and the number ex. $E$3


can use f4 key too

What to do mixed cell referencing mutiplication

When doing mutiplication left to top right $ first letter and then $ last number

Ex. $A4*G$9

What to do for mixed cell referencing division

If doing top then dividing by left it should be opposite of mutiplication

Ex. A$5/$C1

Rate formula

Border command near paint can
nper, pmt, pv, fv, type

Loan payments are usually at what point of period (type function)

End, 0

Investingment/savings are paid when

Beginning of the month, 1

Pv stands for

Present value, money at the start, ex loan amount

Fv stands for

Future value, money at the end, ex. goal value in savings

PMT function disection…(what does it contain)

Rate, nper, PV, FV, Type

Rate is..

Interest rate/12 if monthly payments

Nper is…

Number of years X timeline( ex 12 months…. 26 weeks, 52 weeks

PMT in rate formula?

Payment

Lump sum deposit at the beginning is what?

Negative

Where does lump sum deposit go in rate formula

In present value

If lump sum deposit are at beginning of year what happens to payment?

Always 0

Making deposits at the beginning of each year/ more deposits at the first year for lump sum

PMT is yearly deposit , PV is 1st year deposit, and type has to be 1

I

FV formula

rate, nper, pt, type