Explanation MAX function is used when we want to find the maximum value within a range of cells. Practice MAX here Example   Syntax The syntax of the MAX function…