Downloaded 29 times
Uploaded bywildman099
PPT, PDF935 views
Excel lesson formulas and functions
This document discusses formulas and functions in Excel. Formulas begin with an equals sign and perform calculations using operators like addition, subtraction, multiplication and division. Functions are predefined formulas that perform specific operations, like summing values, finding minimums or maximums, calculating dates or averages. Users can find more functions by clicking Insert and then selecting Function (Fx) to search for functions by description.
![UiPath Automation Suite Installation (Hands-On) [2/3]](https://cdn.slidesharecdn.com/ss_thumbnails/automationsuitecommunitysession2-251015095633-a6d862f1-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
Excel lesson formulas and functions
- 1. Excel Formulas andFunctions Mr. Lee BIM
- 2. Creating Formulas Aformula is an equation that performs a calculation. All Excel formulas begin with an equals sign (=). Operator Meaning Example + (plus sign) Addition =7+1 - (minus sign) Subtraction =F2-4 *(asterick) Multiplication =2*C5 / (forward slash) Division =B2/8 ^ (caret) Exponentiation =4^2
- 3. Excel Formula FunctionsA function is a predefined formula in Excel that performs a specific, built-in operation. Common Functions Function Description =SUM(cells) Adds all the numbers in the specified cells. =MIN(cells) Returns the smallest value in the specified cells. =MAX(cells) Returns the largest value in the specified cells. =DATE(year,month,day) Returns a number that represents the specified date. =AVERAGE(cells) Returns the average of the cells that are highlighted.
- 4. Where can Ifind more Functions? Click insert, then select function (Fx). The Insert Function menu allows you to search for functions after you type in a brief description.