ADM 1370 Study Guide - Midterm Guide: Negative Number
Document Summary
Office button: select all button: used to select all elements of the worksheet, status bar: displays information about a selected command or operation in progress, also displays basic summary information about a selected range of values. Steps to ensure good design: deciding on the purpose of the spreadsheet and how it will be constructed, making it obvious where data is to be entered, entering data and setting up formulas, wherever possible. Formulation: transformation of a real problem scenario into a mathematical model. Solution: solving the model to obtain the optimal solution. Types of models: mental (arranging furniture, visual (blueprints, roadmaps, physical/scale (aerodynamics, blueprints, mathematical (financial analysis) A computer model: a set of mathematical relationships and logical assumptions implemented in a computer as an abstract representation of a real-world object or phenomenon, spreadsheets provide the most convenient way for business people to build computer models. An annuity is a series of constant cash payments made over a continuous period. (ex.