i need forumlas that go in the yellow

G's Kitchen, Incorporated ("GK, Incorporated") has been crafting fine chocolates for over sixty years. GK, Incorporated is a well-established local brand, but business really took off when GK, Incorporated hired a social media firmito develop a greater online presence Sales have expanded from a retall storefront in a small Michigan resort town to being sold online and shipped throughout the contiguous United states Recenty, GK, Incorporated signed a retail sgreement whth a prominent national retail chain, in order to meet the demands of the national retail chain While maintaining aligh quality product, GK Incorporated began lesasing refrigerated warehouse space from Penguin Network Storage. LLC to store lust-in-time iryentory of its top products GK. incorporated has hired vou to determine the income tax apportionment percentage in states where it has a physical presence using the data provided in Colurnn G through column L. The apportionment weightings have been provided below Required: 1. Complete the client-provided data with sum formulas for the Everywhere amounts. 2. complete the apportionment calculations using VLOOKUP formulas to the client provided data in GI 51 (HINT: Une the FALSE iogical value for exact match viookuP formulas. Use absolute referencing for the table arring) G51 fx Everywhere G's Kitchen, Incorporated ("GK, Incorporated") has been crafting fine chocolates for over sixty years. GK, Incorporated is a well-established local brand, but business really took off when GK, Incorporated hired a social media firmito develop a greater online presence Sales have expanded from a retall storefront in a small Michigan resort town to being sold online and shipped throughout the contiguous United states Recenty, GK, Incorporated signed a retail sgreement whth a prominent national retail chain, in order to meet the demands of the national retail chain While maintaining aligh quality product, GK Incorporated began lesasing refrigerated warehouse space from Penguin Network Storage. LLC to store lust-in-time iryentory of its top products GK. incorporated has hired vou to determine the income tax apportionment percentage in states where it has a physical presence using the data provided in Colurnn G through column L. The apportionment weightings have been provided below Required: 1. Complete the client-provided data with sum formulas for the Everywhere amounts. 2. complete the apportionment calculations using VLOOKUP formulas to the client provided data in GI 51 (HINT: Une the FALSE iogical value for exact match viookuP formulas. Use absolute referencing for the table arring) G51 fx Everywhere