MIS 311 Study Guide - Midterm Guide: Application Server, Computer Hardware, Enterprise Software

• School: Binghamton University
• Department: Mgmt Info Systems
• Course: MIS 311
• Professor: Seyed Eshagh Ashraf Vaghefi

Document Summary

Know the difference between a function and formula. In-class excel review: when using text, be sure to put it in quotes. In order to separate text, use with a space in between them: =(a1, , b1,) Know the difference between relative and absolute referencing (as well as how to use dollar signs) If function: =if(condition, what to do if it is true, what to do if it is false) Nested if function: same structure as an ordinary if function, but replace the false condition with a new if. Countif: counts the number of cells that meets criteria. Sumif: add the values of all the cells that meets criteria. Pmt function: =pmt(rate or percentage, number of payments, present value) Vlookup: =vlookup(cell that you are analyzing, table, column reference, true/false, remember to make the table reference absolute, true for approximate value, false for exact value. Goal seek: sets cell to wanted value by changing another cell.