For example, in cell B26 enter the formula "= B5".

Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. If you do not get this answer, find the errors in your worksheet and correct them.

Save your completed Applying Excel form to your computer and then upload it here by clicking %u201CBrowse.%u201D Next, click %u201CSave.%u201D You will use this worksheet to answer the questions in Part 2.