Does Google Sheets have "Volatile" Functions like Excel?

yes, Google Sheet does have volatile functions:

  • NOW
  • TODAY
  • RAND
  • RANDBETWEEN

and the only issue with them is that they are hard to be frozen