ADM 1370 Study Guide - Quiz Guide: Computer Simulation, Business Intelligence
22 Apr 2016
School
Department
Course
Professor
Document Summary
Covers module 2: all units of the required course pack. Covers all class discussions and lectures as well as powerpoints. Covers lab sessions and class demos in excel. Students will be tested on technical aspects of excel. Winter 2016 included questions regarding mainly: bi dashboards, heuristics, modeling methodology, excel techniques, conditional formatting, excel formulas, what-if analysis, goal seek, solver, vlookup function, absolute, relative, mixed cell reference, any emphasized concepts/theories/techniques from class. Excel: computerized spreadsheet application used to build and manipulate worksheets and workbooks. Auto-fill: can be used to duplicate formulas or functions, by dragging down the cell that contains the formula. Function: a named operation that is already predefined which also returns a value. Autosum: summarizes using a sign statistic of row/column sum, average, total, max, min. Formulation: transformation of real problem to a mathematical model, identify problem, then develop model. Solution: solving the model to obtain the optimal solution, analyze model, then test results.
