Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which functions are volatile and recalculate on every workbook change?

  1. A NOW, TODAY, RAND, OFFSET and INDIRECT
  2. B SUM, AVERAGE and COUNT
  3. C VLOOKUP and INDEX
  4. 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.

All Microsoft excel MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as