{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ISY1305 Exam 3 Review

# ISY1305 Exam 3 Review - =PMT(rate nper(number of payments...

This preview shows pages 1–2. Sign up to view the full content.

=PMT(rate, nper (number of payments or period of time, pv (present value), fv (future value), type(1= beg. of year 0= end of year) =PPMT(rate, per (specifies the period must be 1 to period total), nper, pv, fv, type) =IPMT(rate, per, nper, pv, fv, type) Amortization table/chart o Used for loans Excel Evaluating Data Logical Functions - IF o (blank=blank , then yes, then no) Lookup Functions – HLOOKUP(looks at rows), VLOOKUP( looks at columns) o (what we know, table array, what we want (in #’s row or col), true or false) Excel Charts (Excel Chapter 5)  Chart Terminology – okay like what does she mean?? Uhhh like data series, chart title, legend, chart area, plot area, back wall and stuff like that I guess How to set it up. Know what to select as your Data Source for a chart. This is the most challenging part of creating a chart. Know how to format the chart. Be familiar with Pie, and Column Charts. Be familiar with elements of a chart: data series, category values, plot area, data markers, etc.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

ISY1305 Exam 3 Review - =PMT(rate nper(number of payments...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online