Value: 12 Guiding labels show the logical relationships among the worksheets and provide hyperlinks to navigate directly to any worksheets. Please match the following guiding labels and their purposes: a. Projects outputs from calculations based on decisions and parameters b. Depicts the fundamental logic of the model itself C. Gives step-by-step instructions for using the model d. Provides some historical data and records assumptions used in the model e. Records the major changes made to the model over time f. Describes the purpose and assumptions behind the model 1. Overview a 2. Instructions 3. Log of changes a 4. Influence chart a 5. Assumptions 6. Model a Check Answer Design Workbooks for Ease of Navigation and Use Selecting a function will bring up a window showing needed inputs. Function value will be shown in window automatically Value: 2 We want to calculate the payment on a car loan. Using the PMT function, what is the returned value based on the following (rounded to 2 decimals): Rate = 0.1 Nper - 24 PV = 15000 Check Answer Range Names Any cell or range of cells may be named Name or cell reference may be used in formulas Names easier to debug and use Require extra work to enter and maintain Select Formulas Defined Names Define Name to assign a name Pull-down window at top left of spreadsheet Shows all named cells for workbook Can be used to enter individual cell names