Function Meaning SUM Adds up a range of numbers and returns the sum AVERAGE Calculates the average of a range of numbers IF Performs a logical test and returns different values based on the result VLOOKUP Searches for a value in the leftmost column of a table and returns a corresponding value from a specified…