Correct Answer:
C. (C) Both A & B
The correct answer is (C) Both A & B. In MS Excel, a standard formula often comprises both labels (cell references like A1, B2) and numeric values. For instance, a formula like =SUM(A1:A5, 10) includes cell labels (A1:A5) and a numeric value (10). Therefore, a comprehensive formula can contain both elements.
- (A) Label is partially correct but incomplete, as formulas frequently incorporate numbers.
- (B) Numeric value is also partially correct but incomplete, as cell references are fundamental.
- (D) None of these is incorrect because option (C) accurately describes the components.