Analyzing and Managing Data with Excel's 'SUBTOTAL' Function
Instruction: Describe how you would use Excel's 'SUBTOTAL' function to analyze a dataset containing sales data by region and product category.
Context: This question assesses the candidate's ability to use SUBTOTAL for filtered or visible-row aggregation, explain function-number and manually hidden-row behavior, and distinguish that calculation from sorting or grouped subtotal workflows.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
SUBTOTAL summarizes a specified vertical range; it does not sort data or automatically group it by region/category...