# Question & Answer: I4, calculate the Actual Increase/Decrease from the first quarter to the second quarter. Subtract the First Quarter…..

I4, calculate the Actual Increase/Decrease from the first quarter to the second quarter. Subtract the First Quarter value (G4) from the second quarter Total (E4), and then divide that result by the First Quarter value. Press CTRL+ENTER.

In cell

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: I4, calculate the Actual Increase/Decrease from the first quarter to the second quarter. Subtract the First Quarter…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS \$13/PAGE

***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.