A user wants to calculate the sum total of numeric values in range A1:A5.
Flipkart technical mcq question, verified with a worked answer. Free to practise - no sign-up.
A user wants to calculate the sum total of numeric values in range A1:A5. Which of the following SUBTOTAL formulas is the correct function call for summation?
Show answer & explanation
In the SUBTOTAL function, the function_num '9' corresponds to the SUM operation. The range must be specified using a colon (A1:A5) to denote a continuous range of cells.
Step-by-step Derivation:
Step 1: Analyze the SUBTOTAL function syntax: =SUBTOTAL(function_num, ref1, [ref2], ...).
Step 2: Identify the function_num for summation. According to Microsoft Excel documentation, function_num 9 is used for SUM (including hidden rows) and 109 is used for SUM (excluding manually hidden rows).
Step 3: Evaluate the options based on the function_num. Option A uses 10 (which is SUM if the range is a single cell, but actually corresponds to COUNTA in the standard 1-11 list). Option B uses 9 (SUM).
Step 4: Evaluate the range syntax. A range from A1 to A5 is correctly represented as 'A1:A5'. Options C and D use 'A1,A5', which refers only to two individual cells rather than the range A1 through A5.
Step 5: Conclusion: Option B correctly combines the SUM function number (9) with the correct range reference (A1:A5).