Create Presentation
Download Presentation

Download Presentation
## Excel: Formulas and Functions

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -

**Objectives**• Name a cell or range • Locate and use Excel’s predefined functions • Debug formulas that contain errors • Record and run a macro**Referencing Cells**• Absolute, relative & mixed • Cell Ranges • A2:A10 (row) • A2:D10 (column) • A2:B6 (range) • Naming a Range of Cells (you can then use a name in formulas)**Creating and Using Formulas**• Create (=) • Formula Syntax (set of rules) • Operator Precedence (use paragraph symbols)**Functions**Predefined functions Function Arguments Trig Functions Excel’s trig function express angles in radians Use DEGREES function to convert radians to degrees Matrix Operations (skip)**Debugging Excel Worksheets**• See Table for Excel Error Messages • Highlight Formulas • Tracing Dependents • Tracing Precedents • Unusual changes in row/column patterns**Macros**• Stored Collection of Commands • Macro stored as a Visual Basic Module • Subject to viruses • Can only save as .xlsm • Excel files w/o macros saved as .xlsx • Macro created by “recording the steps”