Instruction: Demonstrate how you would use array functions combined with dynamic array formulas to analyze a dataset containing sales data across multiple regions and product categories. Focus on calculating year-over-year growth and market share changes.
Context: This question evaluates the candidate’s expertise in manipulating and analyzing large datasets using modern Excel features like dynamic arrays and array functions. It tests the ability to derive business insights from data through advanced formula constructions.