Excel Formulas

Sheet4 Sheet3 Sheet2 FormulaBasic AB CD Data1 Num1 Num2 Data in cell Numeric String Formula = 2+ 3 Range : Intesection Union , Space =SUM(G8:K8) =SUM(G8:J8 H8:K8) =SUM(G8:I8,I8:K8) Operator Precedence Formula Compose of Constant Operator Function Control Order of Precedence by ( ) Working sheet Calculation Manual Auto Ctrl+Alt +F9 for all F9 Setting Relative Reference VS Absolute Reference =G47*H47 =$G$47*$H$47 =Num1*Num2 Copy formula without adjust relative reference(by formula bar) Display worksheet formula 1. Choose Tools, Options to display the Options dialog box. 2. Choose the View tab. 3. Activate the Formulas check box. 4. Click OK. Excel displays the worksheet formulas. Convert Formula to value F2+F9+Enter Range Name How to name range? Insert Range name define How to insert range name in formula? F3 How to apply range name? Link Reference To other sheet To other workbook Enter the data in multiple sheet Enter 3 D formulas Condition Format 0.00 0.00 00.00 0.00 0.00 0.00 0.00 000.00 00.00 0.00 0.00 0.00 0.00 0.00 0.00 00.00 0.00 0.00 0.00 0.00 00.00 00.00 00.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 00.00 0.00 0.00 00.00 0.00 0.00 0.00 0.00