ADM 1370 Study Guide - Income Statement
Document Summary
Range: a rectangular group of cells in a worksheet. Precedence: a set of pre-defined rules used to determine the sequence in which operators are applied in calculation. Absolute cell references: cell addresses that stay fixed and are not adjusted as a formula is copied. =average (num1,num2) excel sums the values in the range and then divides by the number of non- blank cells in the range. Condition functions: result may be a specified value or a calculated value e. g. Nested if: when one if function is placed inside another if function to test an addition condition. Number of if function in total would be one less than the number of possible outputs. Dashboards: quick distilled snapshots, highlighting the key includes, for instant decision making. What-if analysis: the study of how the uncertainty in the output of a model can be attributed to different sources of uncertainty in the model inputs.