Instruction: Define an Array Formula and provide an example of how it might be used in data analysis.
Context: This question probes the candidate's knowledge of advanced Excel functions, specifically Array Formulas, and their application in handling and analyzing data arrays efficiently.