Multiple choice technology

which of the following is the Volatile function?

  1. now

  2. sum

  3. then

  4. average

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

NOW() is a volatile Excel function because its value changes whenever the worksheet recalculates, even if no inputs change. Volatile functions automatically recalculate every time any cell is modified. SUM, THEN (not a real function), and AVERAGE are non-volatile.