The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
| Version |
Location |
Description |
Submitted by |
Date submitted |
| Printed |
Page 133
1st paragraph |
In other words, instead of having the web address (URL) of http://www.oreily.com you...
should be www.oreilly.com!
|
Anonymous |
|
| Printed |
Page 191
figure |
figure 9-3 has the same screen shot as figure 9-2. There's something different in the Safari version, so maybe it's been corrected? Didn't see page 191 listed in any errata.
|
Anonymous |
|
| Printed |
Page 203-204
The explanation of uses Data->Table menu is wrong. |
When I folow the instruction I get the next table:
6,50% 222,22 SIT
7,00% 222,2222222 360
7,50% 222,2222222 80000
8,00% 222,2222222
8,50% 222,2222222
9,00% 222,2222222
9,50% 222,2222222
10,00% 222,2222222
and not the table from the book. At least the column input cell is wrong
(Figure 9.15, page 204).
|
Anonymous |
|
| Printed |
Page 240
Figure 10-3 caption |
With a Line chart you can quickly illustrated any trends...
should read -
With a Line chart you can quickly illustrate any trends...
|
Anonymous |
|
| Printed |
Page 279
4th paragraph (under *Type* subheading, Chapter 12 [Financial |
Functions]);
The second sentence under the Recurring Argument description "Type" on page
279 of Excel 2000 In A Nutshell states the following: "If the payment is
made at the BEGINNING of the period (beginning of the month), specify a 0,
otherwise specify 1 for the END of the period [MY EMPHASIS ADDED]."
THIS SHOULD BE REVERSED ... if the assumption is that payments are made at
the BEGINNING of a period, then the user should specify 1 (ONE) and NOT 0
(zero). The DEFAULT -- EQUIVALENT to specifying 0 (zero) -- is assuming
that payments are made at the END of the period.
While the above may sound counter-intuitive, it is DEFINTELY TRUE. You can
confirm this by either: (a) checking with the Help / *Clippy* (I guess
Clippy is useful for something), OR (b) by doing a simple calculation using
a function like PV() or PMT() {simple mathematical logic would suggest that
if payments are assumed to be made at the beginning of a period than the PV
would be greater than (>), and PMT would be less than (<), if the
respective calculations were made with the end of period assumption}.
THIS IS A SERIOUS ERROR (someone might just plug in numbers and
find out they made a serious mis-calculation on important financial data).
Page 287 The "Note" and "TIP #77" contradict each other - one says the end period
must be greater, the other states they can be equal.
Page 303 "Values"
The text reads "... -100 followed by four positive values..."
when five numeric values are listed.
|
Anonymous |
|
| Printed |
Page 378
Figure 14-13 |
The examples of MINVERSE and MMULT are misleading. They show both functions
producing single values. Actually, MINVERSE and MMULT produce matrices, not just
single values.
The value at F7 is the upper left entry of the inverse matrix produced by MINVERSE,
not the complete result of MINVERSE. The comment accompanying F7 should have been
"{MINVERSE({3,8,4;5,6,2;4,9,3})}." Likewise, the value at B7 is a single entry from
the inverse matrix, whereas the entire inverse matrix should have been shown.
The value at D11 is the upper left entry of the product matrix produced by MMULT, not
the entire result of MMULT. And the comment accompanying D11 should have been
"{MMULT({2,4,5;4,3,7;6,4,8},{3,8,4;5,6,2;4,9,3})}."
|
Anonymous |
|
| Printed |
Page 382
First paragraph under MULTINOMIAL |
Should read something like, "...to determine the ratio of the factorial of the sum of
the specified values..." instead of "...to determine the ratio of the sum of the
factorials for the specified values..." [The second sentence in the paragraph was
correct, and not as described in the first sentence.]
First paragraph under Example.
Should read "...is used to determine the ratio of the factorial of the sum of three
numbers ...", instead of "is used to determine the ratio of the sum of three
factorials..."
|
Anonymous |
|
| Printed |
Page 390
Last two sentences in "Num_Digits" description |
The sentence, "If the Num_Digits argument is a negative value the value on the left side of the decimal is rounded down" is misleading. Actually, a negative value of the Num_Digits argument indicates the number of place to round to the left of the decimal: -1 means to round to the nearest 10, -2 means to round to the nearest 100, etc.
Last sentence should say something more like "For example,
=ROUND(119.45,-2) returns a value of 100," instead of "...
=ROUND(19.45) returns a value of 17," which is incorrect.
There is a similar mistake in the descriptions of the ROUNDDOWN and
ROUNDUP functions, pages 391 and 392. [=ROUNDUP(119.45,-2) returns
a value of 200.]
|
Anonymous |
|
| Printed |
Page 393
Figure 14-21 |
The comment attached to E2 should read "2*5^2+3*5^(2+2)+4*5^(2+(2*2))", not
"2*52+3*5(2+2)+4*5(2+(2*2))"
|
Anonymous |
|
| Printed |
Page 400
First paragraph after SUMX2MY2 |
Is misleading. Should say something more like, "Use SUMX2MY2 to take two arrays, subtract the squares of the elements of the second array from the squares of the elements of the first array, and then sum the differences: sum(xi^2 - yi^2)."
First paragraph in Example is similar.
Should say something more like "...illustrates how SUMX2MY2 is used to find the
result of subtracting the squares of array2 from the squares of array1 and then
summing the differences."
|
Anonymous |
|
| Printed |
Page 419
3rd paragraph, line 3 after fig 15.7 |
... represents a numeric value), or are mpty are not counted.
should read -
... represents a numeric value), or are empty are not counted
|
Anonymous |
|
| Printed |
Page 460
top of page, fig. 15.41 |
Typo in a screen shot:
Figure 15-41. Use SKEW to determine the asymmetry of a list of numeric values.
In the screen shot, the top of column C says asymmety.
|
Anonymous |
|