Spreadsheets

128 Views

Download Presentation
## Spreadsheets

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

**Spreadsheets**A How To!**Identifying Labels and Values**labels values**Identifying Formulas and Functions**formula The result of the formula function The result of the function**Formula or Function?**• =C2+D2+E2 • =AVERAGE(C2:M2) • =E2/B2 • =IF(3A>2A, ‘True’, ‘False’) • =SUM(E4:G4) • =(A2+B2+C2)/3**Identifying Parts of a Spreadsheet Formula**mathematical operators =B2+C2+D2 equal sign—first part of any spreadsheet formula cell reference/address—made up of the column heading and the row number**Identifying Parts of a Spreadsheet Function**=SUM(B2:B6) name of function range equal sign**Relative and Absolute Referencing**• Relative • cells that change when they are copied into other cells • Absolute • cells that do not change regardless of where it is copied