Engineering Fundamentals: An Introduction to Engineering, 4th ed.c

in Figure 14.2, we have grouped the measured voltages and the resistance into one range, which we have calledMeasurements. You c ...

To enter a formula, select the cell where you want the result of the formula to be displayed. In the Formula bar, then type the ...

Pick cells A5 and A6 and use the fill command with the handle to copy the pattern into cells A7 to A15. 424 Chapter 14 Electr ...

14.3 Creating Formulas in Excel 425 Use the Homemenu (tab) and the Fillcommand to copy the formula into cells B6 to B15. You co ...

The final results for Example 14.1 are shown in Figure 14.3. The cell contents were centered using the center button (icon) from ...

relative reference to a cell, a special character, such as $, is not needed. You simply refer to the cell address. For example, ...

428 Chapter 14 Electronic Spreadsheets TABLE 14.2 The Relationship between the Interest Earned and the Amount Deposited Interest ...

and trigonometric, statistical, financial, and logical functions. In this chapter, we will dis- cuss some of the common function ...

More examples of Excel’s functions are shown in Table 14.4. The Now and Today Functions When you work on an important Excel docu ...

14.4 Using Excel Functions 431 TABLE 14.4 More Examples of Additional Excel Functions Function Description of the Function SQRT( ...

432 Chapter 14 Electronic Spreadsheets ■Figure 14.7 The Excel spreadsheet for Example 14.4. menu, and turn on the superscript to ...

14.5 Using Excel Logical Functions In this section, we will look at some of Excel’s logical functions. These are functions that ...

Example 14.5 The pipeline shown in Figure 14.8 is connected to a control (check) valve that opens when the pressure in the line ...

Excel offers Chart Wizard, which is a series of dialogue boxes that walks you through the necessary steps to create a chart. To ...

Finally, you can place the chart in an approprite location as shown. If for some reason you need to make changes, pick the item ...

14.6 Plotting with Excel 437 It is worth noting that you can plot more than one set of data on the same chart. To do so, first p ...

Example 14.7 Use the following empirical relationship to plot the fuel consumption in both miles per gallon and gallons per mile ...

14.6 Plotting with Excel 439 In the Select Data Source, under Legend Entries, click on the Add button, and then type in the ser ...

440 Chapter 14 Electronic Spreadsheets With the mouse pointer over the Gallons Per Mile curve, double-click the left mouse butt ...

14.7 Matrix Computation with Excel 441 ■Figure 14.11 The final results for Example 14.11. 14.7 Matrix Computation with Excel Dur ...