#NUM! Error- When does this error occurs in excel spreadsheet?

This error occurs when a cell reference is not valid

This error occurs with invalid numeric values in a formula or function.

This error occurs when a value is not available to a function or formula

This error occurs when a number is divided by zero