$($a$)$In cell A$6,$ type $1.$ Rather than copying the numbers $2$ to $25,$ we can fill down based on the formula in cell A$7$ which is $=$ A$6+1.$ Locate A$7($Since this is where the formula begins$)$ by clicking on the center of the cell. Go to the far lower right hand corner of cell A$7$ and hold down the left mouse button when you see the cursor change. Holding the left mouse button down, drag the cell down to year $40$ and let go off the mouse button. Couple A opens a bank account and decides to deposit $$1500\mathrm{.}00$ at the end of each year for $8$ years in an account which earns $8\%$ interest compounded annually for $40$ years. Year $8$ is the last time they deposit any money meaning there is no deposit value for years $9$ to $40.$ Remember that the Interest column is for the Interest formula, do not just put in the interest rate. When the couple opens the bank account $($the first year$),$ there is no money in Beginning Balance. Set up your spreadsheet for Couple A accordingly. You should get $$18609\mathrm{.}84$ for your ending balance for year $10.$ Couple B decides to "live it up$"$ for the first $8$ years, meaning there is no deposit value for years $1$ to $8.$ At the end of year $9,$ they deposit $$1500\mathrm{.}00$ at the end of each year in an account which earns $8\%$ interest compounded annually. Set up your spreadsheet for Couple B$,$ showing their financial status for $40$ years. You should get $$3120\mathrm{.}00$ for your ending balance for year $10.$

At the year couple B$\text{'}$s account exceeded couple A$\text{'}$s account, $,$ in total how much more had couple B deposited than couple A$?$