Why Use Spreadsheets?BasicsFormulasFormula OperatorBasic MathSUM, PRODUCTMAX, MINAVERAGE, MEDIAN, MODERANK, PERCENTRANK, PERCENTILEROUND, TRUNCRAND, RANDBETWEENCONCATENATEVLOOKUP, HLOOKUPIFCOUNTIF, SUMIFOR, ANDCommon Formula ErrorsAnchorsGoal Seek and Solver in ExcelGoal SeekSolverOne-Way Data TablesSummary