using functions in excel
TRANSCRIPT
![Page 1: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/1.jpg)
Using Functions in Excel
![Page 2: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/2.jpg)
Review
A FUNCTION is a built in formula that is a shortcut for common
calculations.
Example: =SUM(A1:A20)
![Page 3: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/3.jpg)
Types of Functions
Excel places functions in various categories
![Page 4: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/4.jpg)
Common Functions
In this class we will use a few common functions
![Page 5: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/5.jpg)
Common Functions
SUM - Adds the contents in the range of the function
PRODUCT – Multiplies the contents in the range of the function
QUOTIENT – Divides the contents in the range of the function
AVERAGE – Finds the average of the content in the range
MAX – Finds the largest value in the range of the function
MIN – Finds the lowest value in the range of the function
ABS – Returns the absolute value of a number
![Page 6: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/6.jpg)
Common Functions
There is NO function for subtraction in excel
![Page 7: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/7.jpg)
Using Functions
Functions can be used in the same ways that formulas are used
![Page 8: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/8.jpg)
Using Functions
Calculation for numbers by themselves.
Example: Gives the sum of the numbers 1 and 3
=SUM(1,3)
![Page 9: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/9.jpg)
Using Functions
Calculation for numbers and cells.
Example: Gives the sum of cell A1 and the number 3
=SUM(a1,3)
![Page 10: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/10.jpg)
Using Functions
Calculation for cells.
Example: Gives the sum for the range of cells a1 through c1
=SUM(a1:c1)
![Page 11: Using Functions in Excel](https://reader038.vdocuments.us/reader038/viewer/2022100523/5549a283b4c905a6758b4f81/html5/thumbnails/11.jpg)
Using Functions
IMPORTANT!!
When using NUMBERS with functions; use a comma
=SUM(1,3)
When using cell references with function, use a colon
=SUM(a1:c1)