Download Presentation
## Chapter 5 : PowerPoint Presentation

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -

**Chapter 5: PowerPoint Presentation**GO! with Microsoft Excel® 2007 Comprehensive 1e - Original Chapter 5 Chapter 5 Making Decisions with Functions**Objectives**• Create Text Functions • Create Statistical Functions • Insert Date and Time Functions • Create Logical Functions and Insert a Comment**Objectives**• Insert Financial Functions • Create What-If Analysis with Goal Seek • Determine Future Value and Present Value**Create Text Functions**• Functions are built-in formulas that complete tasks quickly. • Functions are usually used for complex mathematical calculations. • They are also used for formatting purposes.**Create Text Functions**• Text functions, such as the TRIM and PROPER functions, format text or add text to a cell. • The PROPER function capitalizes the first letter of each word in a cell entry. • The TRIM functionremoves all spaces from text except for single spaces between words.**Create Text Functions**• =UPPER(A2) Changes text to all UPPERCASE (NANCY DAVOLIO) • =LOWER(A2) Changes text to all lowercase (nancy davolio) • =PROPER(A2) Changes text to Title Case (Nancy Davolio)**Create Statistical Functions**• Statistical functions provide statistical analysis of a worksheet. • The median is the value at the midpoint of a series of numbers. • The mode is the value that occurs the most often in a list of numbers.**Create Statistical Functions**• After you type an = (equal sign) and the beginning letters of a function, Excel displays a dynamic list of valid functions. List of function choices**Create Statistical Functions**• The COUNT function counts the number of cells in the selected range that contain numeric values. • The COUNTA function counts the number of cells in the range that are not empty.**Insert Date and Time Functions**• Date and time functions can be static or volatile. • A static date or time remains the same and does not change. • A volatile date or time is updated each time the worksheet is used.**Insert Date and Time Functions**• The TODAY function returns the current date. Each time the worksheet is opened, the TODAY function recalculates so the current date displays. • Click the Formulas tab, and in the Function Library group, click the Date and Time button. From the displayed list click TODAY.**Create Logical Functions and Insert a Comment**• Logical functions test a logical comparison between expressions. • They determine whether the conditions are true or false.**Create Logical Functions and Insert a Comment**• The AND function tests two or more arguments to see whether they are true or false. • Returns TRUE if all arguments are true. • Returns FALSE if any argument is not true. • The OR function tests two or more arguments to see whether they are true or false and returns TRUE when any one of the arguments is true.**Create Logical Functions and Insert a Comment**• Comments can provide additional information that explains the data in a worksheet. • A comment is a remark that is attached to a specific cell but does not display with the worksheet. • An indicator alerts the user that a comment is attached to the cell.**Create Logical Functions and Insert a Comment**• Printing comments: • Comments can be printed as they are displayed. • Or they can be printed as text at the end of the worksheet.**Create Logical Functions and Insert a Comment**Comment Comments group Red triangle indicates comment is in cell**Insert Financial Functions**• Excel provides more than 50 financial functions. • Three functions that are frequently used are: • Future value: FV (rate, periods, payment) • Payment: PMT (rate, periods, loan amount) • Present value: PV (rate, periods, payment)**Insert Financial Functions**Formulas tab Required arguments Name of function**Create What-If Analysis with Goal Seek**• Goal Seek is one of Excel’s “what-if” analysis tools. • It’s used to find a specific value for a cell by adjusting the value in another cell.**Create What-If Analysis with Goal Seek**• To use Goal Seek: • Select the Data tab. • In the Data Tools group, click the What-If Analysis button. • In the displayed list, click Goal Seek.**Create What-If Analysis with Goal Seek**What-If Analysis button Data Tools group Goal Seek dialog box**Determine Future Value and Present Value**• Two financial functions that are used frequently in business are FV and PV: • Future value (FV)is the amount that an investment made today will be worth in the future. • Present value (PV) is the amount of money invested now in order to have a specific amount of money at a future time.**Covered Objectives**• Create Text Functions • Create Statistical Functions • Insert Date and Time Functions • Create Logical Functions and Insert a Comment**Covered Objectives**• Insert Financial Functions • Create What-If Analysis with Goal Seek • Determine Future Value and Present Value