Read: Excel Module $03$ Performing Calculations with Formulas and Functi...

vdots:

$($ii$)A$ A

a$.$ In cell W$10,$ calculate the lower control limit by returning the value of cell V$5$ minus the value of cell V$10$ times cell V$6.$ Use absolute references for cells V$5$ and V$6$ and a relative reference for cell V$10.$ Check your formula by verifying that cell W$10$ shows the value $598\mathrm{.}45.$

b$.$ In cell $x10,$ calculate the upper control limit by returning the value of cell V$5$ plus the value of cell V$10$ times cell V$6.$ Once again, use absolute references for cells V$5$ and V$6$ and a relative reference for cell V$10.$ Check your formula by verify that cell X$10$ shows the value $651\mathrm{.}61.$

c$.$ Use AutoFill to extend the formulas in the range W$10$:X$10$ over the range W$10$:X$33$ to show the lower and upper control limits for batch sizes ranging from $2$ up to $25.$