```html

Commonly Used Functions in Microsoft Excel for Spreadsheets

Microsoft Excel offers a wide range of functions that can be used to perform various calculations and data manipulations in a spreadsheet. Some commonly used functions include:

• SUM: Adds up all the numbers in a range of cells. For example, =SUM(A1:A10) would sum the values in cells A1 through A10.
• AVERAGE: Calculates the average of a range of cells. For example, =AVERAGE(B1:B5) would find the average of the values in cells B1 through B5.
• IF: Allows you to perform different actions based on a condition. For example, =IF(C1>10, "Yes", "No") would display "Yes" if the value in cell C1 is greater than 10, otherwise it would display "No".
• VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column. For example, =VLOOKUP(A1, B1:C10, 2, FALSE) would look for the value in cell A1 in the range B1:C10 and return the corresponding value from the second column.
• COUNTIF: Counts the number of cells within a range that meet a specific criteria. For example, =COUNTIF(D1:D10, ">50") would count the number of cells in the range D1:D10 that are greater than 50.

By using these functions and many others available in Microsoft Excel, you can efficiently analyze and manipulate data in your spreadsheets.

```