1 / 15

Functions

Functions. About Functions SUM, AVERAGE, MIN, MAX, COUNT, ROUND. WHAT IS AN EXCEL FUNCTION?. A pre-defined formula used in a calculation Excel has over 300 functions – business, scientific & engineering Functions Today: SUM MIN, MAX AVERAGE COUNT ROUND.

arnon
Download Presentation

Functions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Functions About Functions SUM, AVERAGE, MIN, MAX, COUNT, ROUND

  2. WHAT IS AN EXCEL FUNCTION? • A pre-defined formula used in a calculation • Excel has over 300 functions – business, scientific & engineering • Functions Today: • SUM • MIN, MAX • AVERAGE • COUNT • ROUND

  3. Some things you need to know. . . • Argument:A value • Range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent • Cell reference: The set of coordinates that a cell occupies • Constant: A value that is not calculated • E.g., the number 210 and the text "Quarterly Earnings” • Formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value • =SUM(A1:A5) adds all the numbers that are contained in cells A1 through A5. • =SUM(A1, A3, A5) adds the numbers that are contained in cells A1, A3, and A5.

  4. SUM • Description • The SUM function adds all the numbers that you specify as arguments. Each argument can be numbers or cell references. • Syntax • =SUM(number1, [number2], [number3], [number4], ...)

  5. AVERAGE Description Returns the average of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. Syntax =AVERAGE(number1, [number2],...)

  6. MAX AND MIN Description MAX function to find the maximum number in a selected range. MIN function to find the minimum number in a selected range. Syntax =MIN(A2:A7) Smallest number in the range (0) =MAX(A2:A7) Largest number in the range (27) Use the drop down arrow next to the AutoSum button Select Max or Min from the list Ensure the cell range is correct Press Enter

  7. COUNT Description The COUNT function counts the number of cells that contain numbers within a range. Syntax =COUNT([value1], [value2],...)

  8. COUNTA Description The COUNTA function counts the number of cells in a range that are not empty. Syntax =COUNTA([value1], [value2],...)

  9. ROUND Description The ROUND function rounds the value of a cell for you. Syntax =ROUND(number, num_digits)

  10. FORMULA BUILDER Use to take you into the spreadsheet to select a range of cells

  11. Complex Functions

  12. BRACKETS • More than one mathematical symbol is used • BODMAS theory -- Calculations performed in the following order: • Brackets over • Division • Multiplication • Addition • Subtraction

  13. =(B2-B3)*B4 =B2-B3*B4

  14. CALCULATION ORDER BRACKETS ARE ADDED TO FORCE EXCEL TO PERFORM CALCULATIONS IN A DIFFERENT ORDER. THE CALCULATION IN THE BRACKETS WILL BE PERFORMED FIRST NO MATTER WHAT MATHEMATICAL OPERATION IS USED.

  15. EXERCISE Open Functions1.xlsx Insert Formulas SUM, AVERAGE, MAX, MIN Copy Results Save as Functions2.xlsx Cells G2, H2, I2 and J2 Down each appropriate range of cells

More Related