Combining Excel's COUNTIF function and graphing tools produces a tally chart. Getty Solving linear programming problems in a spreadsheet yields equations for maximizing business profits.