# Soda Profits ## Instructions The [Coca Cola Co spreadsheet](../../../../2-Working-With-Data/06-non-relational/CocaColaCo.xlsx) is missing some calculations. Your task is to: 1. Calculate the Gross profits for FY '15, '16, '17, and '18 - Gross Profit = Net Operating revenues - Cost of goods sold 1. Calculate the average of all the gross profits. Try to do this using a function. - Average = Sum of gross profits divided by the number of fiscal years (10) - Documentation on the [AVERAGE function](https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6) 1. This is an Excel file, but it should be editable in any spreadsheet platform [Data source credit to Yiyi Wang](https://www.kaggle.com/yiyiwang0826/cocacola-excel) ## Rubric Exemplary | Adequate | Needs Improvement --- | --- | --- | --- **Disclaimer**: This document has been translated using the AI translation service [Co-op Translator](https://github.com/Azure/co-op-translator). While we strive for accuracy, please note that automated translations may contain errors or inaccuracies. The original document in its native language should be regarded as the authoritative source. For critical information, professional human translation is recommended. We are not responsible for any misunderstandings or misinterpretations resulting from the use of this translation.