Description Excel Module 3 Performing Calculations with Formulas and Functions Objectives Session 3.1 - Translate an equation into 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 Home insert Draw Formulas Data Review View fx Multex Digital 3 Home insert Draw Formulas Data Review view fx ritatint LC.=XbarA2Rhar where Xbor is the Xbar volve, Abor la the Rbor volve and A2h a maliplicerve cossern bosed on the sarple size of ht somple bovh The velve of the lower contrel limit be LCC=Nhar+A2Rhar where Xbor is the Xbor volve, Aber in the Rber velve and A2 in a malliplicenive coestom bosed on the semple size of the somple both NPEX_3-4 Home insert Draw Formulas Data Review View 7 8 . 9 11 1312 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41. 42 43 44