Explain how to implement array formulas across multiple ranges to summarize data.
Instruction: A2:A4 contains units 2,3,4; B2:B4 contains unit prices 10,20,5; C2:C4 contains discount fractions 0,0.1,0.2. Calculate total revenue after discounts across the aligned ranges, explain the result and entry method, and distinguish range references from array constants.
Context: This question tests the candidate's understanding of array formulas and their ability to use them for advanced data analysis.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
For a calculation across aligned ranges, SUMPRODUCT multiplies corresponding entries and sums the products...