Computer Knowledge · University of Kashmir Junior Accounts Assistant (2026) — Set A · Last updated:

View the full solved paper: University of Kashmir Junior Accounts Assistant (2026) — Set A

Which MS Excel function is categorized as volatile, meaning it recalculates every time any cell in the entire workbook is modified or recalculated?

  1. A. VLOOKUP
  2. B. XMATCH
  3. C. SUMIFS
  4. D. INDIRECT (Correct answer)

Correct Answer

Option D — INDIRECT

Detailed Solution & Explanation

In Microsoft Excel, volatile functions (such as INDIRECT, OFFSET, NOW, TODAY, and RAND) recalculate whenever *any* cell anywhere in the workbook changes, regardless of whether their own precedents changed. VLOOKUP, XMATCH, and SUMIFS are non-volatile. Therefore, Option D (INDIRECT) is the verified correct response under MS Excel (Computer Knowledge).

Topics covered: MS Excel