ISY1305 Exam 3 Review

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

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: =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....
View Full Document

This note was uploaded on 09/25/2008 for the course ISY 1305 taught by Professor Sanchez during the Spring '08 term at Baylor.

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 Right Arrow Icon
Ask a homework question - tutors are online