Format Number Syntax Function: FORMAT-NUM(value) Parameters: value =  a numeric value Outputs: a formatted string value Description: The FORMAT-NUM()…

Format Date Syntax Function: FORMAT-DATE(value, format) Parameters: value =  a numeric value format =  a combination of text or character…