More examples of Excel’s functions are shown in Table 14.4.
The Now and Today Functions
When you work on an important Excel document, it is a good idea to indicate when the doc-
ument was last modified. In one of the top cells, you may want to type “Last Modified:”, and
in the adjacent cell, you can use the now( )or today( )function. Then, each time you
access the Excel document, the now( )function will automatically update the date and the time
the file was last used. So, when you print the sheet, it will show the date and the time. If you
use the today( )function, it will only update the date.Example 14.4 Using Excel, compute the average (arithmetic mean) and the standard deviation of the density
of water data given in Table 14.5. Refer to Chapter 19, Section 19.5, to learn about what the
value of standard deviation for a set of data points represents.
Refer to Figure 14.7 when following the steps.- In cell B1, type Group A findings, and in cell C1 type Group B findings.
- In each of cells B3 and C3, type Density (kg /m
3
). Highlight the 3 in the kg /m
3
, and use
the following command to make 3 a superscript. Choose Cellsfrom the Format, Cells
430 Chapter 14 Electronic Spreadsheets
■Figure 14.6 The Excel worksheet for Example 14.3.
Example 14.3 A set of values is given in the worksheet shown in Figure 14.6. Familiarize yourself with some of
Excel’s built-in functions, as described in Table 14.3. When studying Table 14.3, note that col-
umns A and B contain the data range, which we have namedvalues; cell D1 contains the angle- Also note that the functions were typed in the cells E1 through E14; consequently, the
results of the executed Excel functions are shown in those cells.
Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀