When using Excel functions play an important role in finding values for a range of cells. Learn all about using functions in Excel.
- Open an existing Excel workbook. If you want, you can use our practice workbook.
- Create a function that contains one argument. If you're using the example, use the SUM function in cell B16 to calculate the total quantity of items ordered.
- Use the AutoSum command to insert a function. If you are using the example, insert the MAX function in cell B23 and use the cell range D3:D15 for the argument to find the most expensive item that was ordered.
- Explore the Function Library, and try using the Insert Function command to search for different types of functions.