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?
- A. VLOOKUP
- B. XMATCH
- C. SUMIFS
- 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