Locate and correct the circular reference for the balance in cell i5. the balance should be calculated as the difference between total due and the down payment.

Coca-cola was primarily known for its core competencies in marketing, bottling, and distributing aerated drinks. however, with the success of gatorade, coca-cola developed competencies in the development and marketing of its own sports drink, powerade. which of the following is true of coca-cola? a. it is leveraging existing core competencies to improve current market position. b. it is building new core competencies to protect and extend its current market position. c. it is redeploying and recombining existing core competencies to compete in markets of the future. d. it is targeting the chasm between the early adopter and early majority market segment.