Sho$-$Biz Novelty Company needs to expand the Inventory spreadsheet to calculate how inventory values differ from the average. Using Excel's relative and absolute cell references allows a formula to be entered ONCE and then copied into all other appropriate cells.