Excel 2010 Bible

959 Index summing the n largest values, 381 using arrays instead of range reference, 376–377 Artistic Effects feature, Office 20 ...

960 Index BeforeSave event, 876, 878–879 Bernoulli distribution option, Random Number Generation dialog box, 790 BESSELI functio ...

961 Index editing, 98 formatting, 95 hiding and showing, 97 overview, 94–95 printing, 96–97 reading, 96 selecting, 97–98 conditi ...

962 Index Chart Element drop-down control, 439–440 Chart Layouts option, 437 chart macros.xlsm sample file, 942 chart series fea ...

963 Index CHIDIST function, 918 CHIINV function, 918 CHISQ.DIST function, 929 CHISQ.DIST.RT function, 929 CHISQ.INV function, 92 ...

964 Index formatting, 95 hiding and showing, 97 overview, 94–95 printing, 96–97 reading, 96 selecting, 97–98 VBA code, 812 Comme ...

965 Index creating macros for, 864–866 design mode, 862 linking controls to cells, 864 overview, 843–844, 861 Convert button, 15 ...

966 Index COVARIANCE.S function, 929 Create Chart dialog box, 736 Create from File tab, Object dialog box, 623, 626 Create Links ...

967 Index Form button, 41–42 New button, 42 Customize Regional Options dialog box, 257 Customize Ribbon tab, Excel Options dialo ...

968 Index data validation examples.xlsx sample file, 939 data validation feature adding comments to cells, 98 cell references, 5 ...

969 Index decimal hours, 277–278 Decimal option, Data Validation dialog box, 571 decimal points, 38 Decrease Decimal Places butt ...

970 Index Document Information Panel dialog box, 151 Document Inspector dialog box, 646–647 Document Properties panel, 911 docum ...

971 Index CUMIPMT function, 332 CUMPRINC function, 332 depreciation functions, 351 Engineering Category Functions, 921–922 enter ...

972 Index workbook BeforeClose, 879 BeforeSave, 878–879 NewSheet, 878 Open, 876–877 SheetActivate, 878 worksheets BeforeRightCli ...

973 Index display preferences, 147 Info options Compatibility Mode section, 154 Permissions section, 154–155 Prepare for Sharing ...

974 Index formatting chart elements, 415–416 comments in cells, 95 conditional copying cells, 500 deleting, 500 formula-based ru ...

975 Index overview, 202–203 pasting range names, 205–206 by pointing, 203–205 tips, 208–209 errors #DIV/0! errors, 653–654 #N/A ...

976 Index Formulas option defined, 85 Go to Special dialog box, 75, 661 Paste Special dialog box, 87 Formulas tab Excel Options ...

977 Index fv function argument, 331 FVSCHEDULE function, 923 G GAMMADIST function, 918 GAMMA.DIST function, 930 GAMMAINV functio ...

978 Index Microsoft Office Home page, 944–945 options, 944 HEX2BIN function, 922 HEX2DEC function, 922 HEX2OCT function, 922 Hid ...