SMS221 Chapter 1: NPExcel2016 M01 B
Document Summary
Performing calculations with formulas: formula, an expression that returns a value, written using operators that combine different values, resulting in a single displayed value. Performing calculations with formulas: entering a formula, click cell where you want formula results to appear, type = and an expression that calculates a value using cell references and arithmetic operators. Performing calculations with formulas: copying and pasting formulas worksheet, guidelines for writing effective formulas, keep them simple, do not hide data values within formulas, break up formulas to show intermediate results. Simplifying formulas with functions: function, named operation that returns a value, simplifies a formula, reducing a long formula into a compact statement; for example, to add values in the range a1:a10: Use the sum function to accomplish the same thing: Modifying a worksheet: moving and copying a cell or range, using the count function, inserting a column or row, deleting a row or column, inserting and deleting a range.