Los Boban Dimowski Technology Assignment - Excel Page Layout Formulas Data Review Draw View Help Power Pivot Genes we 29 Delete $ -% 9 Conditional Formatas C Formaning Styles Sonta o Sole Fort E12 6 B D 1 2 Total FIRST TASK $1,000.00 $50.00 $50.00 $50.00 S50.00 $50.00 Years Initial Deposit Monthly Deposit 10 $1,000.00 S50.00 5 6 7 8 Enter all of the deposits (S1000 and a whole bunch of SSos) made to Tommy and Gina's account over 10 years in column A. Then add all of those values using SUM. Hint: You should not have to type 50 a bunch of times. Use copy and paste or auto-fill. Think carefully about how many times SSO should be listed 9 10 11 12 13 14 15 16 17 18 19 20 0 Type here to search q 40 PSC HO gu %23 ! 1 $ 4 % 5 & 7 ( 9 3 2 6 8 0 Q W R E O Y P U S A D F G H ) Z C C VB NM Boban Dimov Share Review View Power Pivot De 2-28 Idos C is Conditional format as Formatting Format Sort & Find a For Select 12 fo D G H 1 Total SECOND TASK 2 3 Years Initial Deposit Monthly Deposit 10 $1.000.00 550.00 4 5 6 T Write the formula in F2 that will allow you to enter the years and monthly deposit and calculate the total deposits made to the account. (This does not take interest into account. We will consider that later.) Here's a big hint: If you type 10, 1000, or 50 into your formula, you it won't work correctly! 10 11 12 13 14 15 17 19 20 13 These BI 401 PM 9/12/200 Pit So Home 2 End $ 4 POUP 3 % 5 6 & 7 8 W 9 E 0 R T Y O S D F G H J X L C V B B N M Boban Dimovsk ON Technology Assignment 13 (4 - Excel Search Formulas Data View Insert Review Help Draw Power Pivot Home Page Layout Insert General Times New Roman 12-AA D Delete Format Son $ -% -3 Conditional Formatas Cell Formatting Table Styles Styles Number 1 Font C D F G H Total SECOND TASK Years Initial Deposit Monthly Deposit 10 $1,000.00 $50.00 Write the formula in F2 that will allow you to enter the years and monthly deposit and calculate the total deposits made to the account. (This does not take interest into account. We will consider that later.) 3 9 10 11 12 13 Here's a big hint: If you type 10, 1000, or 50 into your formula, you it won't work correctly! 15 16 18 19 O DI d do Pot Son Homes End @ 2 Pol 3 4 % 5 6 7 00 + ( 9 ) 0 ? W E R Y U I 0 S F G H J L