Excel 2010 Bible

Chapter 32: Making Your Worksheets Error-Free 659 Cell B5 contains the following formula: =SUM(B2:B4) All the cells are formatte ...

Part IV: Using Advanced Excel Features 660 Here’s another example of a “precision” problem. Try entering the following formula: ...

Chapter 32: Making Your Worksheets Error-Free 661 Using Excel Auditing Tools Excel includes a number of tools that can help you ...

Part IV: Using Advanced Excel Features 662 FIGURE 32.7 Zooming out and selecting all formula cells can give you a good overview ...

Chapter 32: Making Your Worksheets Error-Free 663 Figure 32.8 shows an example of a worksheet displayed in two windows. The wind ...

Part IV: Using Advanced Excel Features 664 Cell A4 has three precedent cells (A1, A2, and A3), which are all direct precedents. ...

Chapter 32: Making Your Worksheets Error-Free 665 Identifying dependents You can identify formula cells that use a particular ce ...

Part IV: Using Advanced Excel Features 666 FIGURE 32.10 Excel can check your formulas for potential errors. FIGURE 32.11 After y ...

Chapter 32: Making Your Worksheets Error-Free 667 You can choose Formulas ➪ Formula Auditing ➪ Error Checking to display a dialo ...

Part IV: Using Advanced Excel Features 668 Click the Evaluate button to show the result of calculating the expressions within th ...

Chapter 32: Making Your Worksheets Error-Free 669 Searching for information Enter the information to search for in the Find What ...

Part IV: Using Advanced Excel Features 670 Note Because the Find and Replace dialog box is modeless, you can access the workshee ...

Chapter 32: Making Your Worksheets Error-Free 671 In the Find and Replace dialog box, click Replace All. Excel locates all cell ...

Part IV: Using Advanced Excel Features 672 FIGURE 32.17 Use the Spelling dialog box to locate and correct spelling errors in you ...

Chapter 32: Making Your Worksheets Error-Free 673 l (^) Capitalize Names of Days: Capitalizes the days of the week. If you enter ...

Part IV: Using Advanced Excel Features 674 Note In some cases, you may want to override the AutoCorrect feature. For example, yo ...

E xcel is a superb data analysis tool — if you know how to extract the information you really need. In this part, you’ll learn h ...

40_474877-pp05.indd 67640_474877-pp05.indd 676 3/29/10 11:39 PM3/29/10 11:39 PM ...

677 CHAPTER Getting Data from External Database Files IN THIS CHAPTER Understanding external database files Getting started usin ...

Part V: Analyzing Data with Excel 678 Accessing external database files from Excel is useful in the following situations: l You ...