Max function is used to find the maximum value in the cells This function helps to locate where the maximum data is located in the spreadsheet. Max function