Question

1 Approved Answer

Posted on Jul 16, 2024

1. Set the Freeze Panes command so that Rows 1 and 2 and Columns A and B are locked in place while scrolling through the

1. Set the Freeze Panes command so that Rows 1 and 2 and Columns A and B are locked in place while scrolling through the Investment Detail worksheet. In the Investment Detail worksheet, enter an IF function into cell 13. The output of the function should be the word Gain if the Current Investment Value in cell H3 is greater than the Cost of Purchase in cell G3. Otherwise, the output of the function should be the words No Gain. 2. Copy the IF function in cell 13 and paste it into the range 14:117 using the Paste Formulas command. 3. In the Investment Detail worksheet, enter a nested IF function into cell F3. If the Dividend/Yield value in cell E3 is less than 2%, show the word Low. If the Dividend/Yield value in cell E3 is greater than or equal to 5%, show the word High. Otherwise, show the word Moderate. 4. Copy the IF function in cell F3 and paste it into the range F4:F17 using the Paste Formulas command. On the Investment Detail worksheet in cell 03, use the OR function within an IF function to evaluate the Current vs. Target value. If the Current vs. Target value in cell N3 is greater than 2% or less than -2%, show the word REBAL. Otherwise, show the word OK. 6. Copy the IF function in cell 03 and paste it into the range 04:017 using the Paste Formulas command. 7. On the Investment Detail worksheet in cell P3, use the AND function within an IF function to evaluate the Current vs. Target value and the Unrealized Gain/Loss value. If the Current vs. Target value in cell N3 is greater than 2% and if the Unrealized 5. wenye Clear Sort S Select Ski Teat GL Y Cust rechans Target V os 1005 YGS 759 J45 2.5% 40 3205 7205 4001 2509 63% Description VICX renveen Grade VSTX Short Term Investment Orade WWERK High Yield Core MUSIX on Tum TRR VOUS Dewiped Mar VEIPX guilty income VISCO Small Cap Grow VSX ViCap VIRX mation VEX TRY merging Marken The Tales Companies TING nason KD Coca Cola Fun Parc w 17 23085% 867 1082 5 811 25 S 120 220 32 18. -3.2013 232 5 0705 $ 200 531 Dond Fund Fund Bond Fund Intematon Demo Skind Ows 10 Donec od also Fund 11 na 14 indd India 16wdividual IT 10 07 SIN 2. 3.1% ZON 2010 882 3 3.145 SOS 5126 5740115 11 11.302 333 3.95 So 157000 355 120 728517 . 9.52 SIE 2007 5561338 708 SON 50% 605 TON 09 -0 3) 46 20 550 100 2005 14000 7.401 3.60% 2803 250 110 ga 7 PER 85 1 BA 3.70 3 5 13 1 45585 O. 239 499 355 02 SONT 50 505 SON -0.0 50 1075 23 23 23 22 11 1. Set the Freeze Panes command so that Rows 1 and 2 and Columns A and B are locked in place while scrolling through the Investment Detail worksheet. In the Investment Detail worksheet, enter an IF function into cell 13. The output of the function should be the word Gain if the Current Investment Value in cell H3 is greater than the Cost of Purchase in cell G3. Otherwise, the output of the function should be the words No Gain. 2. Copy the IF function in cell 13 and paste it into the range 14:117 using the Paste Formulas command. 3. In the Investment Detail worksheet, enter a nested IF function into cell F3. If the Dividend/Yield value in cell E3 is less than 2%, show the word Low. If the Dividend/Yield value in cell E3 is greater than or equal to 5%, show the word High. Otherwise, show the word Moderate. 4. Copy the IF function in cell F3 and paste it into the range F4:F17 using the Paste Formulas command. On the Investment Detail worksheet in cell 03, use the OR function within an IF function to evaluate the Current vs. Target value. If the Current vs. Target value in cell N3 is greater than 2% or less than -2%, show the word REBAL. Otherwise, show the word OK. 6. Copy the IF function in cell 03 and paste it into the range 04:017 using the Paste Formulas command. 7. On the Investment Detail worksheet in cell P3, use the AND function within an IF function to evaluate the Current vs. Target value and the Unrealized Gain/Loss value. If the Current vs. Target value in cell N3 is greater than 2% and if the Unrealized 5. wenye Clear Sort S Select Ski Teat GL Y Cust rechans Target V os 1005 YGS 759 J45 2.5% 40 3205 7205 4001 2509 63% Description VICX renveen Grade VSTX Short Term Investment Orade WWERK High Yield Core MUSIX on Tum TRR VOUS Dewiped Mar VEIPX guilty income VISCO Small Cap Grow VSX ViCap VIRX mation VEX TRY merging Marken The Tales Companies TING nason KD Coca Cola Fun Parc w 17 23085% 867 1082 5 811 25 S 120 220 32 18. -3.2013 232 5 0705 $ 200 531 Dond Fund Fund Bond Fund Intematon Demo Skind Ows 10 Donec od also Fund 11 na 14 indd India 16wdividual IT 10 07 SIN 2. 3.1% ZON 2010 882 3 3.145 SOS 5126 5740115 11 11.302 333 3.95 So 157000 355 120 728517 . 9.52 SIE 2007 5561338 708 SON 50% 605 TON 09 -0 3) 46 20 550 100 2005 14000 7.401 3.60% 2803 250 110 ga 7 PER 85 1 BA 3.70 3 5 13 1 45585 O. 239 499 355 02 SONT 50 505 SON -0.0 50 1075 23 23 23 22 11