***ALL THAT IS NEEDED IS THE FORMULA THAT SHOULD BE ENTERED IN I4*** 2 Second Qu
ID: 3845380 • Letter: #
Question
***ALL THAT IS NEEDED IS THE FORMULA THAT SHOULD BE ENTERED IN I4***
2 Second Quarter Sales Projecte Actual Increase increase /Decrea /Decreas May June Total Average First Quart se 4 North 500000 150000 325000 975000 325000 825000 845625 5 South 125000 250000 50000 450000 461250 6 Central 300000 250000 175000 800000 820000 925000 7 Total 8 Average Second Quarter sheet2 Sheet3. READY L .lil 500 Points: xL Step 1.2.3: Use Cell References in a FormulaandApplythe order of Precedence Mo In cell I4, calculate the Actual IncreaselDecrease from the first quarter to the second A quarter. Subtract the First Quarter value (G4) from the second quarter Total (E4), and then divide that result the First Quarter value. Press CTRL+ENTER.Explanation / Answer
Formula that should be entered in I4 is:
=(E4-G4)/G4
This formula substracts G4 from E4 and then divide result by first quarter value
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.