Erin Maloney (Bilkent University)


BF174 COMPUTER APPLICATION II (SPRING 2017)



BF174 CLASS FILES → via Moodle (Spring 2017)



BF174 HOMEWORK ASSIGNMENTS


HW# and TOPICINSTRUCTIONS and FILES TO CHANGEANSWERS
HW01: Fall Course Final Review (Part 1), using Excel
HW02: Review (Part 1); INT, TRUNC, QUOTIENT
HW03: RATE, NPER, PMT, PV, FV; FV vs. Function; Amortization
HW04: Copying Web Data; Basic Stats
HW05: Logic; Matrices
HW06: Scenario, Spinner, Various Functions
HW07: Goal Seek, Solver, VLOOKUP, COUNT*, *A, EXACT, Advanced Chart
HW08: LN, EXP, "e", Growth, EFFECT, Continuous, Compounded, Advanced Word
HW09: Data Analysis: Histograms, Random Number Generation, Sampling, Descriptive Statistics; similar functions
HW10: Regression, Trendlines; Desc Stats (cont.); Amortization (cont.)
HW11: NPV, IRR, XNPV, XIRR; Correlation; Conditional Formatting; Pivot, Filters, Subtotal; Slope/Intercept; Secondary Axis
HW12: EViews