Question: 9. Enter a SUMIFS function in cell C10 on the Summary worksheet. The purpose of th function is to sum the values in the Unrealized

9. Enter a SUMIFS function in cell C10 on the Summary worksheet. The purpose of th function is to sum the values in the Unrealized Gain/Loss column on the Investment Detail worksheet based on two conditions. The first is where the Investment Type column on the Investment Detail worksheet matches the investment type in cell A10 The second condition is where the value in the Percent Gain/Loss column on the Investment Detail worksheet is greater than or equal to 15%. Include cell capacity through Row 25 when defining arguments that require a cell range and use absolute references when needed. NEW View Tell me Allah 12 AA General 07 confum Te 19.0 39 Cel WOS ostment Portfolio 75% $ 1 15 S $ G H de function et capacity 117,625 C Performance Dividende Tar Yield Purchase Va 6.00% 4.60 Moderate STS 2015 Coin B009 3.20% Moderne 50010 S 7 Gen 600 7.2015 High 53.145 3.956 6.00% 4.00% Moderate $ 5.500 5,620 Gan 9.00% 260 Modena S 73405 5555 1000% 250 Moderate $ 11,0755 11 302 No Gain 10.00% 0.30 Low $4,0333 595 10.00% 100% Low 5803 5.644 Gain 9.00 2004 Moderate S 5,706 S 3.607 Gain 9.00 140% Low 3 5.905 8013 Gain 15.00% 2409 Moderate 55.72115 9216 GH 11671 Gain 15.00% 3.60% Modesto 5 7995 S 9857 Gan 15 00 200 Moderato 393695 Symbol Description VFICX Intermediate Investment Grade VESTX Short Term Investment Grade VWEHX High Yield Corporate VUSTX Long Tam Treasury VOMIX Developed Market VEIPX Equity Income VISGX Small Cap Growth VIMSX Mid Cap VTRIX International Value VEIEX Emerging Markets TRV The Travelers Companies Inc Johnson and Johnson Coca Cola mant Type Fund 1 Fund Fund Fund national Stock Fund mestic Stock Fund Peste Stock Fund mestic Stock Fund mational Stock Fund mational Stock Fund vidual Stock vidual Stock vidual Stock DAY www Purce Gal 1.007 23.05 667 1024 311 25.70 120 22 12 5682 On 3.2011 1,135 41 0.74% 2000 SOS 361 35 OTON 3,070 3598 460 62 4 SIS UNI 5.15 7.39 9 200 ZAN 30 3. 5 JNJ OCULIS using the Paste Formulas references when needed. range and use absolute 8. KO Copy cell B10 and paste it into the range B11:B13 using the Paste Formulas command. 9. Enter a SUMIFS function in cell C10 on the Summary worksheet. The purpose of the function is to sum the values in the Unrealized Gain/Loss column on the Investment Detail worksheet based on two conditions. The first is where the Investment Type column on the Investment Detail worksheet matches the investment type in cell A10. un 1 The second condition is where the value in the Percent Gain/Loss column on the Investment Detail worksheet is greater than or equal to 15%. Include cell capacity through Row 25 when defining arguments that require a cell range and use absolute references when needed. 10 Korony cell C10 and paste it into the range C11:C13 using the Paste Formulas

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Show excel formulas used. Enter a SUMIFS function in cell C10 on the Summary worksheet. The purpose of the function is to sum the values in the Unrealized Gain/Loss column on the Investment Detail...

9. Enter a SUMIFS function into cell B13 on the Contribution worksheet that sums the fixed SG\&A costs on the Sales and Cost Data worksheet. The setup of this function is identical to the SUMIFS...

1 . Enter a COUNTIF function in cell B 3 on the Summary worksheet. The function should count the entries in the Investment Type column on the Investment Detail worksheet that match cell A 3 on the...

I am needing help with 7,9, and 11 7. Enter a COUNTIFS function in cell B10 on the Summary worksheet. The function should count the number of investments on the Investment Detail worksheet that match...

Show excel formulas used. Enter a COUNTIF function in cell B3 on the Summary worksheet. The function should count the entries in the Investment Type column on the Investment Detail worksheet that...

3. Enter an AVERAGEIF function in cell C3 on the Summary worksheet. The function should compute the average of the entries in the Dividend/Yield column on the Investment Detail worksheet where there...

if you could please help me solve this excel exercise yes this is excel D3 B D E F G Personal Investments 1 Growth Rate 2 Investment Fund 3. Treasury Bond 4 Corporate Bond 5 Domestic Dividend 6. Mid...

Enter a function in cell B9 on the Investments worksheet that calculates the total of the values in the range B3:B8. b. Copy the function that you just created in cell B9 and paste it into cells C9...

Enter a function in cell B9 on the Investments worksheet that calculates the total of the values in the range B3:B8. Copy the function in cell B9 and paste it into cells C9 and G9. Enter a formula in...

Please help with steps 35 through 47. Hokie Fitness Equipment & Accessories, Inc. is a retailer that sells fitness equipment and accessories. The manager of Hokie Fitness Equipment & Accessories,...

2. a. Draw a pattern for a right pyramid with a square base. b. Assume that your pyramid has a square base with sides 60 cm long and the distance from one vertex on the base to the apex of the...

Thor Inc., a manufacturer of special use flashlights, is considering using activity-based costing to compute product margins, Overhead costs for the just completed quarter have been allocated to the...

The principle of marginal decision - making manifests itself in medical markets in many ways. Which of the following statements is not true? a Ralancing incremental benefite with incremental conts ts...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...