Formula and Function Management
Ø Formulas enable calculations in a worksheet.
Ø Excel recalculates values automatically based on changes in cell data.
Ø To enter a formula, start with = sign followed by the calculation.
Ø For example, =A1+B1 adds the values in cells A1 and B1.
Ø Functions are predefined formulas performing specific operations.
Ø Functions accept arguments and return results.
Ø Results can be calculations, text, references, logical values, or arrays.
o Examples include determining loan payments or calculating investment returns.