Microsoft Office Professional 2010 Step by Step eBook

the row labels, you can make each row its own named range. To create a series of named ranges from a group of cells, select all ...

284 Chapter 10 Perform Calculations on Data To manage the named ranges in a workbook, display the Formulas tab, and then, in the ...

In the Name box at the left end of the formula bar, type V101LastWeek, and then press Enter. Excel creates a named range named ...

286 Chapter 10 Perform Calculations on Data In the Name field, type V102LastWeek. Verify that the definition in the Refers to f ...

You can locate a function, if you don’t know its name, by entering key descriptors in the Search For A Function box and then cli ...

288 Chapter 10 Perform Calculations on Data The PMT function is a bit more complex. It calculates payments due on a loan, assumi ...

As an example, consider a worksheet that contains a two-column Excel table named Exceptions. The first column is labeled Route; ...

290 Chapter 10 Perform Calculations on Data The AutoComplete list suggests functions that begin with the letters you type. To ad ...

You can enter cells and cell ranges in a formula by selecting the cells while creating the formula. Troubleshooting The appearan ...

292 Chapter 10 Perform Calculations on Data Relative references are useful when you summarize rows of data and want to use the s ...

Copying a formula to other cells automatically updates cell references to reflect the new location. You can use a similar techni ...

294 Chapter 10 Perform Calculations on Data In an Excel table, changing a formula in one cell automatically changes it in relate ...

In this exercise, you’ll create a formula manually, revise it to include additional cells, create a formula that contains an Exc ...

296 Chapter 10 Perform Calculations on Data Type [, and then in the Formula AutoComplete list, click Labor Expense, and press T ...

The IF function returns one value if a specified condition is true, and another if it is false. When you work with an IF functio ...

298 Chapter 10 Perform Calculations on Data You can use the IFERROR function to display a custom error message, instead of relyi ...

The AVERAGEIFS, SUMIFS, and COUNTIFS functions extend the capabilities of the AVERAGEIF, SUMIF, and COUNTIF functions to allow f ...

300 Chapter 10 Perform Calculations on Data In cell I3, type the formula =AVERAGEIF(C3:C14, “=Box”, F3:F14), and press Enter. ...

Error codes begin with a number sign (#). When a cell with an erroneous formula is the active cell, an Error button is displayed ...

302 Chapter 10 Perform Calculations on Data You can also audit your worksheet by identifying cells with formulas that use a valu ...