Problem
I. Create a formula in cell E4 that calculates the value of the on-hand inventory, based on the price paid for the item in B4 and the quantity On Hand.
II. Use an absolute reference to calculate the sale price of one item in cell F4. Calculate a markup of 65% using the mark-up value shown in cell I1.
III. Copy the formulas created above into the range E5:F14; first convert any necessary cell references to absolute so that the formulas work correctly in all cells.
IV. Calculate the total value of all inventory on hand in E15 and add an outside border.