Which functions are volatile and recalculate on every workbook change?
- A NOW, TODAY, RAND, OFFSET and INDIRECT
- B SUM, AVERAGE and COUNT
- C VLOOKUP and INDEX
- D LEFT, RIGHT and MID
Answer
NOW, TODAY, RAND, OFFSET and INDIRECT
Replacing OFFSET and INDIRECT with INDEX often produces a dramatic speed improvement in a slow workbook.





