1 / 10

INTRODUCTORY MICROSOFT EXCEL Lesson 5 – Function Formulas

INTRODUCTORY MICROSOFT EXCEL Lesson 5 – Function Formulas. Objectives. Identify the parts of a function formula. Use function formulas to solve mathematical problems. Use function formulas to solve statistical problems. Use function formulas to solve financial problems.

danielfigueroa
Download Presentation

INTRODUCTORY MICROSOFT EXCEL Lesson 5 – Function Formulas

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. INTRODUCTORY MICROSOFT EXCELLesson 5 – Function Formulas

  2. Objectives • Identify the parts of a function formula. • Use function formulas to solve mathematical problems. • Use function formulas to solve statistical problems. • Use function formulas to solve financial problems. • Use function formulas to insert times and dates in a worksheet. • Use logical function formulas to make decisions with worksheet data.

  3. Argument Financial function Function formula Logical function Mathematical function Statistical function Trigonometric function Terms Used in This Lesson

  4. Identify the Parts of a Function Formula • A function formula has three components: • the equal sign • a function name • an argument • The argument is a value, cell reference, range, or text that acts as an operand in a function formula. • Example: =SUM (E4:E22)

  5. See Table 5-1 in student book, Mathematical and trigonometric functions Solving Mathematical Problems • Mathematical and trigonometric functions are particularly useful for determining values such as: • Logarithms • Factorials • Sines • Cosines • Tangents • Absolute values

  6. See Table 5-1 in student book, Statistical functions Solving Statistical Problems • Statistical functions can also be used to determine: • Average • Standard deviation • Variance • Maximums • Minimums • Counts

  7. See Table 5-3 in student book, Financial functions Solving Financial Problems • Financial functions are used to analyze loans and investments: • Value of a series of equal payments • Present value of an investment • Payments required to repay a loan

  8. See Table 6-4 in student book, Time, date, and text functions Inserting Times and Dates • Date and time functions may be used to • Convert serial numbers to a month, a day, or a year • Insert the current date or current time.

  9. Using Logical Function Formulas • Logical functions, such as the IF function, may be used to display text or values if certain conditions exist. • For example the IF function will determine whether a student has passed or failed a course. The function formula IF(C4>60,“PASS”,“FAIL”) will display “PASS” if the value in C4 is greater than 60 and “FAIL” if the value in C4 is not greater than 60.

  10. Summary • Function formulas are special formulas that do not require operators. • Excel has more than 300 function formulas. • Function formulas may be used to perform mathematical, statistical, financial, and logical operations. • Function formulas may also be used to format text and insert dates and times.

More Related