In cell c3 in the october worksheet, enter a 3-d reference in formula that calculates the overall percentage of total sunday orchestra front tickets sold based on the total available orchestra front seating. the formula must sum the total sunday orchestra front seats sold in cells c3 of the weekly sheets and then divide it by the sum of the available orchestra front seats in cell b3 of the weekly sheets. avoid raw numbers and use an appropriate mix of relative and mixed references to derive the correct percentage. format the result with percent style. copy the formula to the range c4: c6 and then to the range d3: g6.