Study Guides (238,486)
UOIT (305)
Midterm

# Midterm Notes.docx

21 Pages
228 Views

School
UOIT
Department
Course
BUSI 1520U
Professor
Amin Ibrahim
Semester
Fall

Description
Chapter 2 Introduction to ExcelProfit Margin Profit Difference in sales price and cost percentage of the sale price This amount represents the amount to cover operating expenses and tax which are not covered in this analysisCell ReferenceExcel offers three types of cell references for use when a formula is copiedAbsoluteA1RelativeA1MixedA1 or A1Relative Cell ReferencesWhen the formula shown in the formula bar is copied relative address A8 is modifiedwhen the formula A8B5 is copied from row 8 to row 9 the formula become A9B5Absolute Cell ReferencesWhen the formula shown in the formula bar is copied absolute address B5 is fixedThe down payment rate in cell B5 is the same for each row and should not be altered during a copy operationFor example when the formula A8B5 is copied from row 8 to row 9 the formula become A9B5Mixed Cell ReferencesIn mixed reference A1 the column is fixed but the row may be altered during a copyIn mixed reference A1 the row is fixed but the column may be altered during a copyCreating a Lookup TableThe VLOOKUP function searches a lookup table for a value and returns the result from the related columnVLOOKUP has three required arguments1Lookup value Value youre looking up2Table array range of data lookup table3Column index of return value Column you wanna lookup directly4Range Look Up You want formula to display an error if an incorrectof years has been enteredCalculating Payments with the PMT FunctionThe PMT financial function calculates the periodic payment for a loan with a fixed interest rate and term lengthPMT has three required arguments1Interest rate2Number of periods3Present value amount of loanDesigning the Logical TestOperatorDescriptionEqual toNot equal toLess thanGreater thanLess than or equal toGreater than or equal to
More Less

Related notes for BUSI 1520U

OR

Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Join to view

OR

By registering, I agree to the Terms and Privacy Policies
Just a few more details

So we can recommend you notes for your school.