Discuss the five guidelines for creating calculations in Excel.

Question

What will be an ideal response?

Answer 1

* Know where the formulas should be. An Excel formula is created in the cell where the formula's results should appear. * Know exactly what cells and arithmetic operations are needed. Don't guess; make sure you know exactly what cells are involved before creating a formula. * Create formulas with care. Make sure you know exactly what you want a formula to accomplish before it is created. An inaccurate formula may have far-reaching effects if the formula or its results are referenced by other formulas. * Use cell references rather than values. The beauty of Excel is that whenever you change a value in a cell, any formula containing a reference to that cell is automatically updated. For this reason, it's important that you use cell references in formulas, rather than actual values whenever possible. * Determine what calculations will be needed. Sometimes it's difficult to predict what data will be needed within a worksheet, but you should try to anticipate what statistical information may be required.