Google Sheets and Excel have the same types of functions. Listed below are some basic functions and what they do. 

• AVERAGE: Returns the numerical average value in a dataset, ignoring text.

• AVERAGEIFS: Returns the average of a range that depends upon multiple criteria

• CHOOSE: Returns an element from a list of choices based on index

• COUNT: Returns the count of the number of numeric values in a dataset

• COUNTIF: Returns a conditional count across a range

• DATE: Converts a provided year, month, and day into a date

• FIND: Returns the position at which a string is first found within a text

• GETPIVOTDATA: Extracts an aggregated value from a pivot table that corresponds to the specific row and column headings

• IF: Retuns one value if a logical expression is true and another if it is false

• INDEX: Returns the content of a cell, specified by row or column offset

• INT: Rounds a number down to the nearest integer that is less than or equal to it

• LOOKUP: Looks through a row or column for a key and retuns the value of the cell in a result range located in the same position as the search row or column

• MATCH: Returns the relative position of an item in a range that matches a specified value

• MAX: Returns the maximum value in a numeric data set

• MIN: Retuns the minimum value in a numeric data set

• NOW: Returns the current date and time as a date value

• ROUND: Rounds a number to a certain number of decimal places according to standard rules

• SUM: Returns the sum of a series of numbers and/or cells

• SUMIF: Returns a conditional sum across a range

• TODAY: Returns the current date as a date value

• VLOOKUP: Searches down the first column of a range for a key and returns the value of a specified cell in the row found

For a more detailed list of functions, click here.

To insert a function in Google Sheets, there are two options

• Click in the cell for the function, click insert -> function then choose the function 

• Click in the cell, type = and type the 1st letter of the function. Choose the function you want to insert.

When you insert a function, it will give you a sample of how to type the function. You can manually type in the cells for the function or highlight the specific cells to include. 

To see more functions in action, click here.