Excel 2019 Bible

Part II: Working with Formulas and Functions # N/A e r r or s The #N/A error occurs if any cell referenced by a formula displays ...

Chapter 19: Making Your Formulas Error-Free 19 The following formula doesn’t return #NULL! but displays the contents of cell B9, ...

Part II: Working with Formulas and Functions #VALUE! errors A #VALUE! error is common and can occur under the following conditio ...

Chapter 19: Making Your Formulas Error-Free 19 The first formula, as expected, returns 9. The second formula, however, returns – ...

Part II: Working with Formulas and Functions One solution to this type of error is to use the ROUND function. The following form ...

Chapter 19: Making Your Formulas Error-Free 19 If you select a multicell range before displaying the Go to Special dialog box, t ...

Part II: Working with Formulas and Functions Cell dependents These formula cells depend upon a particular cell. A cell’s depende ...

Chapter 19: Making Your Formulas Error-Free 19 ■ (^) Choose Formulas ➪ Formula Auditing ➪ Trace Dependents. Excel will draw arro ...

Part II: Working with Formulas and Functions FIGURE 19.1 Excel can check your formulas for potential errors. Using Formula Evalu ...

Chapter 19: Making Your Formulas Error-Free 19 FIGURE 19.2 The Evaluate Formula dialog box shows a formula being calculated one ...

Part II: Working with Formulas and Functions Searching and Replacing Excel has a powerful search-and-replace feature that makes ...

Chapter 19: Making Your Formulas Error-Free 19 Format button Click to search for cells that have a particular formatting. (See t ...

Part II: Working with Formulas and Functions Click the top Format button. The Find Format dialog box appears. This dialog box r ...

Chapter 19: Making Your Formulas Error-Free 19 AutoCorrect Add the misspelled word and its correct spelling (which you select fr ...

Part II: Working with Formulas and Functions Capitalize First Letter of Sentences Capitalizes the first letter in a sentence. Al ...

T he five chapters in this part deal with charts and visualizations. You’ll dis- cover how to use Excel’s graphics capa- bilitie ...

445 C H A P T E R 20 Getting Started with Excel Charts IN THIS CHAPTER How Excel handles charts The parts of a chart The basic s ...

Part III: Creating Charts and Other Visualizations their interrelationships. Making a chart can often help you spot trends and p ...

Chapter 20: Getting Started with Excel Charts 20 value in a single cell and is represented by a marker. You can distinguish the ...

Part III: Creating Charts and Other Visualizations shadow. Using embedded charts enables you to view the chart next to the data ...