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 explainwhat this formatting does and how it can be used in your chosen career field. Feel free to also discuss how this can be used throughout your academic endeavors.

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.