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