Excel 2010 Bible

Appendix A: Worksheet Function Reference 919 Function What It Does PERCENTRANK Returns the percentage rank of a value in a data ...

Part VII: Appendixes 920 TABLE A.3 Database Category Functions Function What It Does DAVERAGE Averages the values in a column of ...

Appendix A: Worksheet Function Reference 921 Function What It Does MINUTE Converts a serial number to a minute. MONTH Converts a ...

Part VII: Appendixes 922 TABLE A.5 (continued) Function What It Does DEC2BIN Converts a decimal number to binary. DEC2HEX Conver ...

Appendix A: Worksheet Function Reference 923 TABLE A.6 Financial Category Functions Function What It Does ACCRINT Returns the ac ...

Part VII: Appendixes 924 TABLE A.6 (continued) Function What It Does MIRR Returns the internal rate of return where positive and ...

Appendix A: Worksheet Function Reference 925 TABLE A.7 Information Category Functions Function What It Does CELL Returns informa ...

Part VII: Appendixes 926 TABLE A.9 Lookup & Reference Category Functions Function What It Does ADDRESS Returns a reference a ...

Appendix A: Worksheet Function Reference 927 Function What It Does ASINH Returns the inverse hyperbolic sine of a number. ATAN R ...

Part VII: Appendixes 928 TABLE A.10 (continued) Function What It Does PI Returns the value of pi. POWER Returns the result of a ...

Appendix A: Worksheet Function Reference 929 TABLE A.11 Statistical Category Functions Function What It Does AVEDEV Returns the ...

Part VII: Appendixes 930 TABLE A.11 (continued) Function What It Does F.TEST** Returns the result of an F-test. FISHER Returns t ...

Appendix A: Worksheet Function Reference 931 Function What It Does PERCENTILE.EXC** Returns the kth percentile of values in a ra ...

Part VII: Appendixes 932 TABLE A.11 (continued) Function What It Does VARPA Calculates variance based on the entire population, ...

933 What’s on the CD-ROM T his appendix describes the contents of the CD that accompanies this book. For any last minute changes ...

Part VII: Appendixes 934 Note The interface won’t launch if you have autorun (or autoplay) disabled. In that case, choose Start ...

Appendix B: What’s on the CD-ROM 935 The CD-ROM files will be copied to a subfolder in the folder you specified in Step 3. To de ...

Part VII: Appendixes 936 l (^) text alignment.xlsx: A workbook that demonstrates different types of horizontal text alignment. l ...

Appendix B: What’s on the CD-ROM 937 l counting text in a range.xlsx: A workbook that demonstrates various ways to count text in ...

Part VII: Appendixes 938 Chapter 18 l (^) area charts.xlsx: A workbook that contains an area chart example. l bar charts.xlsx: A ...