1'===================ABV PROJECT====================== 2'===================MODULE 1 ======================= 3Sub main () 4'you can edit this macro to execute any command when loading this workbook 5'next line call the routine that fill the sheet 6call absmain () 7End Sub 8 9Sub absmain() 10'Do not edit this macro, changes will not be saved with the workbook!!! 11Dim objchart As Object 12Dim objbutton As Object 13Worksheets(1).Name = "Operator" 14Worksheets(2).Name = "Mathfct" 15Worksheets(3).Name = "Textfct" 16Worksheets.Add 17Worksheets(4).Name = "Statfct" 18Worksheets.Add 19Worksheets(5).Name = "Infofct" 20Worksheets(1).Activate 21Cells(1,1).Formula="'expression" 22Cells(1,2).Formula="'result" 23Cells(1,3).Formula="'good result" 24Cells(1,5).Formula="'expression" 25Cells(1,6).Formula="'result" 26Cells(1,7).Formula="'good result" 27Cells(2,1).Formula="'1+1" 28Cells(2,2).Formula="=1+1" 29Cells(2,3).Formula="=2" 30Cells(2,5).Formula="'5+2*3" 31Cells(2,6).Formula="=5+2*3" 32Cells(2,7).Formula="=11" 33Cells(3,1).Formula="'1-1" 34Cells(3,2).Formula="=1-1" 35Cells(3,3).Formula="=0" 36Cells(3,5).Formula="'5*3+2" 37Cells(3,6).Formula="=5*3+2" 38Cells(3,7).Formula="=17" 39Cells(4,1).Formula="'2*3" 40Cells(4,2).Formula="=2*3" 41Cells(4,3).Formula="=6" 42Cells(4,5).Formula="'5+2*3+5" 43Cells(4,6).Formula="=5+2*3+5" 44Cells(4,7).Formula="=16" 45Cells(5,1).Formula="'8/2" 46Cells(5,2).Formula="=8/2" 47Cells(5,3).Formula="=4" 48Cells(5,5).Formula="'5/2+3" 49Cells(5,6).Formula="=5/2+3" 50Cells(5,7).Formula="=5.5" 51Cells(6,1).Formula="'8/3" 52Cells(6,2).Formula="=8/3" 53Cells(6,3).Formula="=2.66667" 54Cells(6,5).Formula="'(2+3)*2" 55Cells(6,6).Formula="=(2+3)*2" 56Cells(6,7).Formula="=10" 57Cells(7,1).Formula="'8\3" 58Cells(7,2).Formula="=8\3" 59Cells(7,3).Formula="=2" 60Cells(8,1).Formula="'8 mod 3" 61Cells(8,2).Formula="=8 mod 3" 62Cells(8,3).Formula="=2" 63Cells(9,1).Formula="'2^3" 64Cells(9,2).Formula="=2 ^ 3" 65Cells(9,3).Formula="=8" 66Cells(11,1).Formula="'1.1+1" 67Cells(11,2).Formula="=1.1+1" 68Cells(11,3).Formula="=2.1" 69Cells(12,1).Formula="'1.1-1" 70Cells(12,2).Formula="=1.1-1" 71Cells(12,3).Formula="=0.1" 72Cells(13,1).Formula="'2.1*3" 73Cells(13,2).Formula="=2.1*3" 74Cells(13,3).Formula="=6.3" 75Cells(14,1).Formula="'8.2/2" 76Cells(14,2).Formula="=8.2/2" 77Cells(14,3).Formula="=4.1" 78Cells(15,1).Formula="'8.2\3" 79Cells(15,2).Formula="=8.2\3" 80Cells(15,3).Formula="=2" 81Cells(16,1).Formula="'8.2 mod 3" 82Cells(16,2).Formula="=8.2 mod 3" 83Cells(16,3).Formula="=2.2" 84Cells(17,1).Formula="'2.2^3" 85Cells(17,2).Formula="=2.2^3" 86Cells(17,3).Formula="=10.648" 87Worksheets(2).Activate 88Columns("A").ColumnWidth = 30.000000 89Columns("D").ColumnWidth = 5.000000 90Columns("E").ColumnWidth = 5.000000 91Cells(1,1).Formula="'function" 92Cells(1,2).Formula="'result" 93Cells(1,3).Formula="'good result" 94Cells(2,1).Formula="'ABS (5.5)" 95Cells(2,2).Formula="=ABS (5.5)" 96Cells(2,3).Formula="=5" 97Cells(2,6).Formula="'ABS" 98Cells(2,7).Formula="'Returns the absolute value of a number " 99Cells(3,1).Formula="'ACOS (0)" 100Cells(3,2).Formula="=ACOS (0)" 101Cells(3,3).Formula="=1.5708" 102Cells(3,6).Formula="'ACOS" 103Cells(3,7).Formula="'Returns the arccosine of a number " 104Cells(4,1).Formula="'ACOSH (2)" 105Cells(4,2).Formula="=ACOSH (2)" 106Cells(4,3).Formula="=1.31695789692" 107Cells(4,6).Formula="'ACOSH" 108Cells(4,7).Formula="'Returns the inverse hyperbolic cosine of a number " 109Cells(5,1).Formula="'ASIN (1)" 110Cells(5,2).Formula="=ASIN (1)" 111Cells(5,3).Formula="=1.5708" 112Cells(5,6).Formula="'ASIN" 113Cells(5,7).Formula="'Returns the arcsine of a number " 114Cells(6,1).Formula="'ASINH (1)" 115Cells(6,2).Formula="=ASINH (1)" 116Cells(6,3).Formula="=0.88137358702" 117Cells(6,6).Formula="'ASINH" 118Cells(6,7).Formula="'Returns the inverse hyperbolic sine of a number " 119Cells(7,1).Formula="'ATAN (1)" 120Cells(7,2).Formula="=ATAN (1)" 121Cells(7,3).Formula="=0.78539816" 122Cells(7,6).Formula="'ATAN" 123Cells(7,7).Formula="'Returns the arctangent of a number 9" 124Cells(8,1).Formula="'ATAN2 (1,2)" 125Cells(8,2).Formula="=ATAN2 (1,2)" 126Cells(8,3).Formula="1.1071487" 127Cells(8,6).Formula="'ATAN2" 128Cells(8,7).Formula="'Returns the arctangent from x- and y- coordinates " 129Cells(9,1).Formula="'ATANH (0.5)" 130Cells(9,2).Formula="=ATANH (.5)" 131Cells(9,3).Formula="=0.54930614" 132Cells(9,6).Formula="'ATANH" 133Cells(9,7).Formula="'Returns the inverse hyperbolic tangent of a number 9" 134Cells(10,1).Formula="'CEILING (7.6,2)" 135Cells(10,2).Formula="=CEILING (7.6,2)" 136Cells(10,3).Formula="=4" 137Cells(10,6).Formula="'CEILING" 138Cells(10,7).Formula="'Rounds a number to the nearest integer or to the nearest multiple of significance " 139Cells(11,1).Formula="'COMBIN (10,2)" 140Cells(11,2).Formula="=COMBIN (10,2)" 141Cells(11,3).Formula="=45" 142Cells(11,6).Formula="'COMBIN" 143Cells(11,7).Formula="'Returns the number of combinations for a given number of objects " 144Cells(12,1).Formula="'COS (pi)" 145Cells(12,2).Formula="=COS (PI())" 146Cells(12,3).Formula="-1" 147Cells(12,6).Formula="'COS" 148Cells(12,7).Formula="'Returns the cosine of a number " 149Cells(13,1).Formula="'COSH (1)" 150Cells(13,2).Formula="=COSH (1)" 151Cells(13,3).Formula="=1.543080" 152Cells(13,6).Formula="'COSH" 153Cells(13,7).Formula="'Returns the hyperbolic cosine of a number " 154Cells(14,1).Formula="'COUNTIF ("">0"",D14:E14,8,0)" 155Cells(14,2).Formula="=countif(""=0"",E1:E4,8,0)" 156Cells(14,3).Formula="5" 157Cells(14,6).Formula="'COUNTIF" 158Cells(14,7).Formula="'Counts the number of non-blank cells within a range which meet the given criteria " 159Cells(15,1).Formula="'DEGREES ()" 160Cells(15,2).Formula="=degrees(3.142)" 161Cells(15,3).Formula="=180.023" 162Cells(15,6).Formula="'DEGREES" 163Cells(15,7).Formula="'Converts radians to degrees " 164Cells(16,1).Formula="'EVEN ()" 165Cells(16,6).Formula="'EVEN" 166Cells(16,7).Formula="'Rounds a number up to the nearest even integer " 167Cells(17,1).Formula="'EXP (2,3)" 168Cells(17,2).Formula="=exp(2,3)" 169Cells(17,3).Formula="=8" 170Cells(17,6).Formula="'EXP" 171Cells(17,7).Formula="'Returns e raised to the power of a given number " 172Cells(18,1).Formula="'FACT (3)" 173Cells(18,2).Formula="=fact(3)" 174Cells(18,3).Formula="=6" 175Cells(18,6).Formula="'FACT" 176Cells(18,7).Formula="'Returns the factorial of a number " 177Cells(19,1).Formula="'FACTDOUBLE ()" 178Cells(19,6).Formula="'FACTDOUBLE" 179Cells(19,7).Formula="'Returns the double factorial of a number " 180Cells(20,1).Formula="'FLOOR (3.75)" 181Cells(20,2).Formula="=floor(3.75)" 182Cells(20,3).Formula="=3" 183Cells(20,6).Formula="'FLOOR" 184Cells(20,7).Formula="'Rounds a number down" 185Cells(21,1).Formula="'GCD ()" 186Cells(21,6).Formula="'GCD" 187Cells(21,7).Formula="'Returns the greatest common divisor " 188Cells(22,1).Formula="'INT (8.3)" 189Cells(22,2).Formula="=INT (8.3)" 190Cells(22,3).Formula="=8" 191Cells(22,6).Formula="'INT" 192Cells(22,7).Formula="'Rounds a number down to the nearest integer " 193Cells(23,1).Formula="'LCM ()" 194Cells(23,6).Formula="'LCM" 195Cells(23,7).Formula="'Returns the least common multiple " 196Cells(24,1).Formula="'LN (4)" 197Cells(24,2).Formula="+LN (4)" 198Cells(24,3).Formula="=1.386294" 199Cells(24,6).Formula="'LN" 200Cells(24,7).Formula="'Returns the natural logarithm of a number " 201Cells(25,1).Formula="'LOG (6)" 202Cells(25,2).Formula="+log(6)" 203Cells(25,3).Formula="0.778151" 204Cells(25,6).Formula="'LOG" 205Cells(25,7).Formula="'Returns the logarithm of a number to a specified base " 206Cells(26,1).Formula="'LOG10(6)" 207Cells(26,2).Formula="=LOG10(6)" 208Cells(26,3).Formula="0.778151" 209Cells(26,6).Formula="'LOG10" 210Cells(26,7).Formula="'Returns the base-10 logarithm of a number " 211Cells(27,1).Formula="'MDETERM" 212Cells(27,6).Formula="'MDETERM" 213Cells(27,7).Formula="'Returns the matrix determinant of an array 9" 214Cells(28,1).Formula="'MINVERSE" 215Cells(28,6).Formula="'MINVERSE" 216Cells(28,7).Formula="'Returns the matrix inverse of an array " 217Cells(29,1).Formula="'MMULT" 218Cells(29,6).Formula="'MMULT" 219Cells(29,7).Formula="'Returns the matrix product of two arrays " 220Cells(30,1).Formula="'MOD" 221Cells(30,6).Formula="'MOD" 222Cells(30,7).Formula="'Returns the remainder from division " 223Cells(31,1).Formula="'MROUND" 224Cells(31,6).Formula="'MROUND" 225Cells(31,7).Formula="'Returns a number rounded to the desired multiple " 226Cells(32,1).Formula="'MULTINOMIAL" 227Cells(32,6).Formula="'MULTINOMIAL" 228Cells(32,7).Formula="'Returns the multinomial of a set of numbers " 229Cells(33,1).Formula="'ODD" 230Cells(33,6).Formula="'ODD" 231Cells(33,7).Formula="'Rounds a number up to the nearest odd integer " 232Cells(34,1).Formula="'PI" 233Cells(34,2).Formula="=PI()" 234Cells(34,3).Formula="=3.14159265359" 235Cells(34,6).Formula="'PI" 236Cells(34,7).Formula="'Returns the value of Pi " 237Cells(35,1).Formula="'POWER(2,4)" 238Cells(35,2).Formula="+power(2,4)" 239Cells(35,3).Formula="16" 240Cells(35,6).Formula="'POWER" 241Cells(35,7).Formula="'Returns the result of a number raised to a power " 242Cells(36,1).Formula="'PRODUCT(1,2,3)" 243Cells(36,2).Formula="+product(1,2,3)" 244Cells(36,3).Formula="6" 245Cells(36,6).Formula="'PRODUCT" 246Cells(36,7).Formula="'Multiplies its arguments " 247Cells(37,1).Formula="'QUOTIENT" 248Cells(37,6).Formula="'QUOTIENT" 249Cells(37,7).Formula="'Returns the integer portion of a division " 250Cells(38,1).Formula="'RADIANS" 251Cells(38,2).Formula="=RADIANS(180)" 252Cells(38,3).Formula="=3.1459265359" 253Cells(38,6).Formula="'RADIANS" 254Cells(38,7).Formula="'Converts degrees to radians " 255Cells(39,1).Formula="'RAND" 256Cells(39,2).Formula="=RAND()" 257Cells(39,3).Formula="'0 to 1" 258Cells(39,6).Formula="'RAND" 259Cells(39,7).Formula="'Returns a random number between 0 and 1 " 260Cells(40,1).Formula="'RANDBETWEEN(3,7)" 261Cells(40,2).Formula="=RANDBETWEEN(3,7)" 262Cells(40,3).Formula="'3 to 7" 263Cells(40,6).Formula="'RANDBETWEEN9" 264Cells(40,7).Formula="'Returns a random number between the numbers you specify " 265Cells(41,1).Formula="'ROMAN" 266Cells(41,6).Formula="'ROMAN" 267Cells(41,7).Formula="'Converts an Arabic numeral to Roman9" 268Cells(42,1).Formula="'ROUND(8.1234,2)" 269Cells(42,2).Formula="=ROUND(8.1234,2)" 270Cells(42,3).Formula="=8.12" 271Cells(42,6).Formula="'ROUND" 272Cells(42,7).Formula="'Rounds a number to a specified number of digits " 273Cells(43,1).Formula="'ROUNDDOWN(8.1234,2)" 274Cells(43,2).Formula="=ROUNDDOWN(8.1234,2)" 275Cells(43,3).Formula="=8.12" 276Cells(43,6).Formula="'ROUNDDOWN" 277Cells(43,7).Formula="'Rounds a number down" 278Cells(44,1).Formula="'ROUNDUP(8.1234,2)" 279Cells(44,2).Formula="=ROUNDUP(8.1234,2)" 280Cells(44,3).Formula="=8.13" 281Cells(44,6).Formula="'ROUNDUP" 282Cells(44,7).Formula="'Rounds a number up" 283Cells(45,1).Formula="'SERIESSUM" 284Cells(45,6).Formula="'SERIESSUM" 285Cells(45,7).Formula="'Returns the sum of a power series based on the formula " 286Cells(46,1).Formula="'SIGN" 287Cells(46,6).Formula="'SIGN" 288Cells(46,7).Formula="'Returns the sign of a number " 289Cells(47,1).Formula="'SIN(0)" 290Cells(47,2).Formula="=SIN(0)" 291Cells(47,3).Formula="=0" 292Cells(47,6).Formula="'SIN" 293Cells(47,7).Formula="'Returns the sine of the given angle " 294Cells(48,1).Formula="'SINH(1)" 295Cells(48,2).Formula="=SINH(1)" 296Cells(48,3).Formula="=1.1752011" 297Cells(48,6).Formula="'SINH" 298Cells(48,7).Formula="'Returns the hyperbolic sine of a number " 299Cells(49,1).Formula="'SQRT(8)" 300Cells(49,2).Formula="=SQRT(8)" 301Cells(49,3).Formula="=2.82842712" 302Cells(49,6).Formula="'SQRT" 303Cells(49,7).Formula="'Returns a positive square root " 304Cells(50,1).Formula="'SQRTPI(2)" 305Cells(50,2).Formula="=SQRTPI(2)" 306Cells(50,3).Formula="=2.50662827" 307Cells(50,6).Formula="'SQRTPI" 308Cells(50,7).Formula="'Returns the square root of (number * PI) " 309Cells(51,1).Formula="'SUM(1,2,3,4)" 310Cells(51,2).Formula="=SUM(1,2,3,4)" 311Cells(51,3).Formula="=10" 312Cells(51,6).Formula="'SUM" 313Cells(51,7).Formula="'Adds its arguments" 314Cells(52,1).Formula="'SUMIF("">2"",1,2,3,4)" 315Cells(52,2).Formula="=SUMIF("">2"",1,2,3,4)" 316Cells(52,3).Formula="=7" 317Cells(52,6).Formula="'SUMIF" 318Cells(52,7).Formula="'Adds the cells specified by a given criteria " 319Cells(53,1).Formula="'SUMPRODUCT" 320Cells(53,6).Formula="'SUMPRODUCT" 321Cells(53,7).Formula="'Returns the sum of the products of corresponding array components " 322Cells(54,1).Formula="'SUMSQ" 323Cells(54,6).Formula="'SUMSQ" 324Cells(54,7).Formula="'Returns the sum of the squares of the arguments " 325Cells(55,1).Formula="'SUMX2MY2" 326Cells(55,6).Formula="'SUMX2MY2" 327Cells(55,7).Formula="'Returns the sum of the difference of squares of corresponding values in two" 328Cells(56,1).Formula="'SUMX2PY2" 329Cells(56,6).Formula="'SUMX2PY2" 330Cells(56,7).Formula="'Returns the sum of the sum of squares of corresponding values in two arrays " 331Cells(57,1).Formula="'SUMXMY2" 332Cells(57,6).Formula="'SUMXMY2" 333Cells(57,7).Formula="'Returns the sum of squares of differences of corresponding values in two arrays " 334Cells(58,1).Formula="'TAN(1)" 335Cells(58,2).Formula="=TAN(1)" 336Cells(58,3).Formula="=1.5574077" 337Cells(58,6).Formula="'TAN" 338Cells(58,7).Formula="'Returns the tangent of a number " 339Cells(59,1).Formula="'TANH(1)" 340Cells(59,2).Formula="=TANH(1)" 341Cells(59,3).Formula="=0.761594155" 342Cells(59,6).Formula="'TANH" 343Cells(59,7).Formula="'Returns the hyperbolic tangent of a number 9" 344Cells(60,1).Formula="'TRUNC(8.1234)" 345Cells(60,2).Formula="=TRUNC(8.1234)" 346Cells(60,3).Formula="=8" 347Cells(60,6).Formula="'TRUNC" 348Cells(60,7).Formula="'Truncates a number to an integer " 349Worksheets(3).Activate 350Columns("A").ColumnWidth = 39.571429 351Columns("B").ColumnWidth = 39.571429 352Cells(2,1).Formula="'left(""left"";2)" 353Cells(2,1).HorizontalAlignment = xlLeft 354Cells(2,2).Formula="=left(""left"";2)" 355Cells(3,1).Formula="'right(""right"";3)" 356Cells(3,1).HorizontalAlignment = xlLeft 357Cells(3,2).Formula="=right(""right"";3)" 358Cells(4,1).Formula="'mid(""middle"";2;3)" 359Cells(4,1).HorizontalAlignment = xlLeft 360Cells(4,2).Formula="=mid(""middle"";2;3)" 361Cells(5,1).Formula="'concatenate(""abc"",""def"")" 362Cells(5,1).HorizontalAlignment = xlLeft 363Cells(5,2).Formula="=concatenate(""abc"",""def"")" 364Cells(6,1).Formula="'len(""len"")" 365Cells(6,1).HorizontalAlignment = xlLeft 366Cells(6,2).Formula="=len(""len"")" 367Cells(7,1).Formula="'instr(""ing"",""string"")" 368Cells(7,1).HorizontalAlignment = xlLeft 369Cells(7,2).Formula="=instr(""ing"",""string"")" 370Cells(8,1).Formula="'rtrim("" testtesttesttest "")" 371Cells(8,1).HorizontalAlignment = xlCenter 372Cells(8,2).Formula="=rtrim("" testtesttesttest "")" 373Cells(8,2).HorizontalAlignment = xlCenter 374Cells(9,1).Formula="'ltrim("" testtesttesttest "")" 375Cells(9,1).HorizontalAlignment = xlCenter 376Cells(9,2).Formula="=ltrim("" testtesttesttest "")" 377Cells(9,2).HorizontalAlignment = xlCenter 378Cells(10,1).Formula="'trim("" testtesttesttest "")" 379Cells(10,1).HorizontalAlignment = xlCenter 380Cells(10,2).Formula="=trim("" testtesttesttest "")" 381Cells(10,2).HorizontalAlignment = xlCenter 382Worksheets(4).Activate 383Columns("A").ColumnWidth = 28.714286 384Columns("C").ColumnWidth = 15.000000 385Columns("D").ColumnWidth = 6.857143 386Columns("E").ColumnWidth = 5.000000 387Columns("F").ColumnWidth = 6.857143 388Cells(1,1).Formula="'AVEDEV" 389Cells(1,2).Formula="+AVEDEV(11.4, 17.3, 21.3, 25.9, 40.1)" 390Cells(1,3).Formula="7.84" 391Cells(1,7).Formula="'Returns the average of the absolute deviations of data points from their mean " 392Cells(2,1).Formula="'AVERAGE" 393Cells(2,2).Formula="=AVERAGE(1,2,3,4) " 394Cells(2,3).Formula="=2.5" 395Cells(2,7).Formula="'Returns the average of its arguments " 396Cells(3,1).Formula="'BETADIST" 397Cells(3,7).Formula="'Returns the cumulative beta probability density function " 398Cells(4,1).Formula="'BETAINV" 399Cells(4,7).Formula="'Returns the inverse of the cumulative beta probability density function " 400Cells(5,1).Formula="'BINOMDIST" 401Cells(5,7).Formula="'Returns the individual term binomial distribution probability " 402Cells(6,1).Formula="'CHIDIST" 403Cells(6,7).Formula="'Returns the one-tailed probability of the chi-squared distribution " 404Cells(7,1).Formula="'CHIINV" 405Cells(7,7).Formula="'Returns the inverse of the one-tailed probability of the chi-squared distribution " 406Cells(8,1).Formula="'CHITEST" 407Cells(8,7).Formula="'Returns the test for independence " 408Cells(9,1).Formula="'CONFIDENCE" 409Cells(9,7).Formula="'Returns the confidence interval for a population mean " 410Cells(10,1).Formula="'CORREL" 411Cells(10,7).Formula="'Returns the correlation coefficient between two data sets " 412Cells(11,1).Formula="'COUNT(1,2,3,4)" 413Cells(11,2).Formula="=count(1,2,3,4)" 414Cells(11,3).Formula="=4" 415Cells(11,7).Formula="'Counts how many numbers are in the list of arguments " 416Cells(12,1).Formula="'COUNTA" 417Cells(12,7).Formula="'Counts how many values are in the list of arguments " 418Cells(13,1).Formula="'COVAR" 419Cells(13,7).Formula="'Returns covariance" 420Cells(14,1).Formula="'CRITBINOM" 421Cells(14,7).Formula="'Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value " 422Cells(15,1).Formula="'DEVSQ" 423Cells(15,7).Formula="'Returns the sum of squares of deviations " 424Cells(16,1).Formula="'EXPONDIST" 425Cells(16,7).Formula="'Returns the exponential distribution " 426Cells(17,1).Formula="'FDIST" 427Cells(17,7).Formula="'Returns the F probability distribution " 428Cells(18,1).Formula="'FINV" 429Cells(18,7).Formula="'Returns the inverse of the F probability distribution " 430Cells(19,1).Formula="'FISHER" 431Cells(19,7).Formula="'Returns the Fisher transformation " 432Cells(20,1).Formula="'FISHERINV" 433Cells(20,7).Formula="'Returns the inverse of the Fisher transformation " 434Cells(21,1).Formula="'FORECAST" 435Cells(21,7).Formula="'Returns a value along a linear trend " 436Cells(22,1).Formula="'FREQUENCY" 437Cells(22,7).Formula="'Returns a frequency distribution as a vertical array " 438Cells(23,1).Formula="'FTEST" 439Cells(23,7).Formula="'Returns the result of an F-test " 440Cells(24,1).Formula="'GAMMADIST" 441Cells(24,7).Formula="'Returns the gamma distribution " 442Cells(25,1).Formula="'GAMMAINV" 443Cells(25,7).Formula="'Returns the inverse of the gamma cumulative distribution " 444Cells(26,1).Formula="'GAMMALN" 445Cells(26,7).Formula="'Returns the natural logarithm of the gamma function" 446Cells(27,1).Formula="'GEOMEAN" 447Cells(27,2).Formula="+GEOMEAN(11.4, 17.3, 21.3, 25.9, 40.1)" 448Cells(27,3).Formula="21.279182482" 449Cells(27,7).Formula="'Returns the geometric mean " 450Cells(28,1).Formula="'GROWTH" 451Cells(28,7).Formula="'Returns values along an exponential trend " 452Cells(29,1).Formula="'HARMEAN" 453Cells(29,2).Formula="+HARMEAN(11.4, 17.3, 21.3, 25.9, 40.1)" 454Cells(29,3).Formula="19.529814427" 455Cells(29,7).Formula="'Returns the harmonic mean " 456Cells(30,1).Formula="'HYPGEOMDIST" 457Cells(30,7).Formula="'Returns the hypergeometric distribution " 458Cells(31,1).Formula="'INTERCEPT" 459Cells(31,7).Formula="'Returns the intercept of the linear regression line " 460Cells(32,1).Formula="'KURT" 461Cells(32,7).Formula="'Returns the kurtosis of a data set " 462Cells(33,1).Formula="'LARGE" 463Cells(33,7).Formula="'Returns the k-th largest value in a data set " 464Cells(34,1).Formula="'LINEST" 465Cells(34,7).Formula="'Returns the parameters of a linear trend " 466Cells(35,1).Formula="'LOGEST" 467Cells(35,7).Formula="'Returns the parameters of an exponential trend " 468Cells(36,1).Formula="'LOGINV" 469Cells(36,7).Formula="'Returns the inverse of the lognormal distribution " 470Cells(37,1).Formula="'LOGNORMDIST" 471Cells(37,7).Formula="'Returns the cumulative lognormal distribution " 472Cells(38,1).Formula="'MAX(1,2,3)" 473Cells(38,2).Formula="=MAX(1,2,3)" 474Cells(38,3).Formula="=3" 475Cells(38,7).Formula="'Returns the maximum value in a list of arguments " 476Cells(39,1).Formula="'MEDIAN(1,2,4,3)" 477Cells(39,2).Formula="=MEDIAN(1,2,4,3)" 478Cells(39,3).Formula="2.5" 479Cells(39,7).Formula="'Returns the median of the given numbers " 480Cells(40,1).Formula="'MIN(1,2,3)" 481Cells(40,2).Formula="=MIN(1,2,3)" 482Cells(40,3).Formula="=1" 483Cells(40,7).Formula="'Returns the minimum value in a list of arguments " 484Cells(41,1).Formula="'MODE" 485Cells(41,7).Formula="'Returns the most common value in a data set " 486Cells(42,1).Formula="'NEGBINOMDIST" 487Cells(42,7).Formula="'Returns the negative binomial distribution " 488Cells(43,1).Formula="'NORMDIST" 489Cells(43,7).Formula="'Returns the normal cumulative distribution " 490Cells(44,1).Formula="'NORMINV" 491Cells(44,7).Formula="'Returns the inverse of the normal cumulative distribution " 492Cells(45,1).Formula="'NORMSDIST" 493Cells(45,7).Formula="'Returns the standard normal cumulative distribution " 494Cells(46,1).Formula="'NORMSINV" 495Cells(46,7).Formula="'Returns the inverse of the standard normal cumulative distribution " 496Cells(47,1).Formula="'PEARSON" 497Cells(47,7).Formula="'Returns the Pearson product moment correlation coefficient " 498Cells(48,1).Formula="'PERCENTILE" 499Cells(48,7).Formula="'Returns the k-th percentile of values in a range " 500Cells(49,1).Formula="'PERCENTRANK" 501Cells(49,7).Formula="'Returns the percentage rank of a value in a data set " 502Cells(50,1).Formula="'PERMUT" 503Cells(50,7).Formula="'Returns the number of permutations for a given number of objects " 504Cells(51,1).Formula="'POISSON" 505Cells(51,7).Formula="'Returns the Poisson distribution " 506Cells(52,1).Formula="'PROB" 507Cells(52,7).Formula="'Returns the probability that values in a range are between two limits " 508Cells(53,1).Formula="'QUARTILE" 509Cells(53,7).Formula="'Returns the quartile of a data set " 510Cells(54,1).Formula="'RANK" 511Cells(54,7).Formula="'Returns the rank of a number in a list of numbers " 512Cells(55,1).Formula="'RSQ" 513Cells(55,7).Formula="'Returns the square of the Pearson product moment correlation coefficient " 514Cells(56,1).Formula="'SKEW" 515Cells(56,7).Formula="'Returns the skewness of a distribution " 516Cells(57,1).Formula="'SLOPE" 517Cells(57,7).Formula="'Returns the slope of the linear regression line " 518Cells(58,1).Formula="'SMALL" 519Cells(58,2).Formula="=SMALL(2,1,4,3,2)" 520Cells(58,3).Formula="2" 521Cells(58,7).Formula="'Returns the k-th smallest value in a data set " 522Cells(59,1).Formula="'STANDARDIZE" 523Cells(59,7).Formula="'Returns a normalized value " 524Cells(60,1).Formula="'STDEV(1,2,3,4,5)" 525Cells(60,2).Formula="=STDEV(1,2,3,4,5)" 526Cells(60,3).Formula="=1.58113883008" 527Cells(60,7).Formula="'Estimates standard deviation based on a sample " 528Cells(61,1).Formula="'STDEVP(1,2,3,4,5)" 529Cells(61,2).Formula="=STDEVP(1,2,3,4,5)" 530Cells(61,3).Formula="1.41421" 531Cells(61,7).Formula="'Calculates standard deviation based on the entire population " 532Cells(62,1).Formula="'STEYX" 533Cells(62,7).Formula="'Returns the standard error of the predicted y-value for each x in the regression " 534Cells(63,1).Formula="'TDIST" 535Cells(63,7).Formula="'Returns the Student's t-distribution " 536Cells(64,1).Formula="'TINV" 537Cells(64,7).Formula="'Returns the inverse of the Student's t-distribution " 538Cells(65,1).Formula="'TREND" 539Cells(65,7).Formula="'Returns values along a linear trend " 540Cells(66,1).Formula="'TRIMMEAN" 541Cells(66,7).Formula="'Returns the mean of the interior of a data set " 542Cells(67,1).Formula="'TTEST" 543Cells(67,7).Formula="'Returns the probability associated with a Student's t-Test " 544Cells(68,1).Formula="'VAR(1,2,3,4,5)" 545Cells(68,2).Formula="=VAR(1,2,3,4,5)" 546Cells(68,3).Formula="2.5" 547Cells(68,7).Formula="'Estimates variance based on a sample " 548Cells(69,1).Formula="'VARP(1,2,3,4,5)" 549Cells(69,2).Formula="=VARP(1,2,3,4,5)" 550Cells(69,3).Formula="2" 551Cells(69,7).Formula="'Calculates variance based on the entire population " 552Cells(70,1).Formula="'WEIBULL" 553Cells(70,7).Formula="'Returns the Weibull distribution " 554Cells(71,1).Formula="'ZTEST" 555Cells(71,7).Formula="'Returns the two-tailed P-value of a z-test " 556Worksheets(5).Activate 557Columns("A").ColumnWidth = 26.142857 558Columns("D").ColumnWidth = 8.000000 559Columns("E").ColumnWidth = 6.857143 560Cells(1,1).Formula="'function" 561Cells(1,2).Formula="'result" 562Cells(1,3).Formula="'good result" 563Cells(2,1).Formula="'ISBLANK(B1)" 564Cells(2,2).Formula="=ISBLANK(B1)" 565Cells(2,3).Formula="=0" 566Cells(3,1).Formula="'ISBLANK(D3)" 567Cells(3,2).Formula="=ISBLANK(D3)" 568Cells(3,3).Formula="=1" 569Cells(4,1).Formula="'ISNUMBER(A4)" 570Cells(4,2).Formula="=ISNUMBER(A4)" 571Cells(4,3).Formula="=0" 572Cells(5,1).Formula="'ISNUMBER(C5)" 573Cells(5,2).Formula="=ISNUMBER(C5)" 574Cells(5,3).Formula="=1" 575Cells(6,1).Formula="'ISTEXT(A6)" 576Cells(6,2).Formula="=ISTEXT(A6)" 577Cells(6,3).Formula="=1" 578Cells(7,1).Formula="'ISTEXT(C7)" 579Cells(7,2).Formula="=ISTEXT(C7)" 580Cells(7,3).Formula="=0" 581Worksheets(4).Activate 582End Sub 583