Question: Formulas have been input for the Qtr1 forecast which reference the Data Section. Only Relative references were used. Modify the Qtr 1 formulas by changing

 Formulas have been input for the Qtr1 forecast which reference the

Formulas have been input for the Qtr1 forecast which reference the Data Section. Only Relative references were used. Modify the Qtr 1 formulas by changing references to Absolute only where necessary so that the formulas may be copied to the remaining Qtrs. After modifying the references, use the Fill Handle to copy the formulas to the remaining Qtrs. NOTE: All entries must be references or formulas and must properly use Relative and Absolute referencing only where necessary to support the copying of the formulas to the remaining Quarters. Print the completed schedule Print the formula view of the completed schedule Data Section: Selling Exp Percentage Administrative Expense Misc. Rental Income 15% $ 3,000 $ 250 Output Section: Bubaloo Inc. Quarterly Forecast Qtr 1 Qtr2 Qtr3 Qtr4 $ 5,000 $5,500 $ 7,000 $3,200 Sales Operating Expense: Selling Exp (Sales x Exp %) Administrative Exp Total Operating Exp $ 750 formula 3.000 formula $ 3,750 formula formula formula formula formula formula formula Income From Operations Other Income Net Income 1.250 formula 250 formula $ 1.500 formula formula formula formula formula formula formula

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 Finance Questions!