Performing Calculations with Formulas and Functions

Using the Internet, conduct a thorough search for more information on using formulas and functions in Excel. Choose one bullet listed below and explain and also include a reason to use in your worksheet for your bullet from the following:

Choose from the following topics:

Session 3.1

• Translate an equation with a function
• Do calculations with dates and times
• Extend data and formulas with AutoFill
• Use the Function Library
• Calculate statistics

Session 3.2

• Using the Quick Analysis toolbar
• Use absolute and relative cell references
• Use a logical function
• Retrieve data with lookup tables
• Do what-if analysis with Goal Seek

Be sure to cite your sources using APA style format.