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