Every time you open or refresh a sheet containing formulas, the values will get automatically updated. However, if you wish to manually re-evaluate formulas used in your sheet, you can use the Recalculate option or click F9. This is highly helpful if your sheet contains dynamic formulas like RAND(), RANDARRAY(), RANDBETWEEN(), etc.