Excel 2010 Bible

Appendix B: What’s on the CD-ROM 939 Chapter 20 l (^) color scale example.xlsx: A workbook that demonstrates a conditional forma ...

Part VII: Appendixes 940 l (^) region3.xlsx: One of three workbooks used to demonstrate data consolidation. l source.xlsx: A wor ...

Appendix B: What’s on the CD-ROM 941 l (^) mortgage loan data table.xlsx: A workbook that demonstrate how to create a data 1-way ...

Part VII: Appendixes 942 Chapter 43 l (^) monitor a range.xlsm: A workbook that contains a VBA Worksheet_Change macro that monit ...

943 Additional Excel Resources I f I’ve done my job, the information provided in this book will be very useful to you. The book, ...

Part VII: Appendixes 944 Microsoft Technical Support Technical support is the common term for assistance provided by a software ...

Appendix C: Additional Excel Resources 945 Note As you know, the Internet is a dynamic entity that changes rapidly. Web sites ar ...

Part VII: Appendixes 946 Table C.1 lists the most popular English-language Excel newsgroups found on the Microsoft news server ( ...

Appendix C: Additional Excel Resources 947 Internet Web sites The World Wide Web has dozens of excellent sites devoted to Excel. ...

Part VII: Appendixes 948 Daily Dose of Excel This is a frequently updated weblog created by Dick Kusleika, with about a dozen co ...

949 Excel Shortcut Keys M any users have discovered that using their keyboard can often be much more efficient than using their ...

Part VII: Appendixes 950 TABLE D.1 Moving through a Worksheet Key(s) What It Does Navigation keys (←, →, ↑, ↓) Moves left, right ...

Appendix D: Excel Shortcut Keys 951 Key(s) What It Does Ctrl+Shift+spacebar Selects the entire worksheet. Ctrl+Shift+spacebar If ...

Part VII: Appendixes 952 TABLE D.4 (continued) Key(s) What It Does Home Moves the cursor to the beginning of the line End Moves ...

Appendix D: Excel Shortcut Keys 953 TABLE D.6 Other Shortcut Keys Key(s) What It Does Ctrl+F1 Toggles the display of the Ribbon ...

Part VII: Appendixes 954 TABLE D.7 Function Keys Key(s) What It Does F1 Displays Help Alt+F1 Inserts default chart object that u ...

Appendix D: Excel Shortcut Keys 955 Key(s) What It Does Ctrl+Alt+F9 Global calculation Ctrl+F9 Minimizes the workbook F10 Displa ...

59_474877-bapp04.indd 95659_474877-bapp04.indd 956 3/29/10 11:47 PM3/29/10 11:47 PM ...

957 Access database program versus Excel, 678 importing tables, 679–680 Accounting format, Format Cells dialog box, 46–47, 554 A ...

958 Index Covariance, 785 Descriptive Statistics, 785–786 exponential smoothing, 786 Fourier Analysis, 787 F-Test, 786–787 Histo ...