Microsoft® Excel® 2010 Inside Out

Errata for Microsoft® Excel® 2010 Inside Out




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
PDF
Page 8
1st paragraph

Says "see 'Filtering with slicers' on page -." with no page number given.

Note from the Author or Editor:
Dear Reader: Thanks for the catch! O'Reilly: Should say Page 794.

Brien  Oct 10, 2010  Jul 22, 2011
Printed
Page 11
3rd bullet point of 3rd paragraph

The total amount of computer memory that Excel could previously use (prior to Excel 2007) is stated as 1 megabyte. I believe that it was actually 1 gigabyte (1GB).

Note from the Author or Editor:
Thanks for the catch.

Anonymous  Jan 22, 2013  Jul 19, 2013
Printed
Page 17
2nd sentence of 2nd paragraph

"there will certainly be a or service pack..." Either a word is missing before "or", or more likely this word is just extraneous.

Note from the Author or Editor:
Thanks for the careful review.

Anonymous  Jan 22, 2013  Jul 19, 2013
PDF
Page 68
top line, 1st paragraph

Says "To save an Excel 2010 or 2007 file to share with someone using the Mac version of Excel... Save As ... 97-2003 ..." Needs updated. Excel 2008 can open these files. Excel 2011 can open these files. After Excel 2004, this advice has no longer been relevant.

Note from the Author or Editor:
If possible, reword thusly: "To save an Excel 2010 or 2007 file to share with someone using a version of Macintosh Excel older than the 2008 release, ... "

Brien Muller  Oct 20, 2010  Jul 22, 2011
Printed
Page 105
NOTE Box bottom of the page

Shortcut for worksheet formula view listed as "Ctrl+'", should be "Ctrl+`".

Note from the Author or Editor:
The reader is correct, it's a typo. The straight single quotation mark should be an accent grave. Existing: "Ctrl+'" Should B: "Ctrl+`" Thanks, =Mark

Andrey  Apr 19, 2011  Jul 22, 2011
Printed, PDF
Page 137
2nd Paragraph

The term "region" is defined here as a block of "filled cells". Yet the last sentence of the paragraph contradicts this definition by saying that an "empty cell", in the example shown, is part of the region. Since this is the first place in the book that the term "region" is defined, it would be appropriate to define region here as "a rectangular block of cells bounded by blank rows, blank columns, or worksheet borders". I believe this is the accurate definition, and is, in fact, described this way on page 146, "Current Region".

Note from the Author or Editor:
Update the current (2013) edition. >Chapter 6 >Under the heading "Moving Around Regions" >Replace the first sentence ("A region is a rectangular ...") >With the following sentence: A region is defined as a rectangular block of cells bounded by blank rows, blank columns, or worksheet borders.

M.K.  Aug 03, 2013 
Printed, Safari Books Online
Page 151
5th paragraph

Text states: "To enter a negative exponential number, type a minus sign before the exponent." Text continues: "For example, –1E6 (1 times 10 to the negative sixth power) equals –1,000,000 and is displayed in Excel as –1.00E+06." Typing a minus sign before an exponent does not convert the value to a negative number; it produces a fraction. In the example, 1 times 10 to the negative sixth power would equal 0.000001 (not negative 1,000,000).

Note from the Author or Editor:
There are two errors here. The first sentence should read: "To enter a negative exponential number, type a minus sign before the number." "For example, -1E6 (negative 1 times 10 to the sixth power) equals ..."

M.K.  May 13, 2012  Jun 29, 2012
Printed
Page 158
4th paragraph

"The Undo button remebers the last 16 actions you performed". On page 224 "The Undo includes a drop-down list of up to the last 100 actions you performed". Maybe the first text refers to older versions?

Note from the Author or Editor:
True. On page 158, the second and third sentences in the 4th paragraph should be changed to read: "The Undo button remembers the last 100 actions you performed. If you Ctrl-Z repeatedly, each of the last 100 actions is undone ..."

Britt Tagmark  Jul 31, 2011  Jun 29, 2012
Printed, PDF, Safari Books Online
Page 162
5th Bulleted Paragraph

Text states: "You can move or copy nonadjacent worksheets at the same time by pressing Ctrl while you click to select the sheet tabs. Before dragging, release the Ctrl key to move the selected worksheets, or keep holding it down to create copies." The aforementioned technique as stated will not work. Regardless of the inention to move or copy, both the mouse and Ctrl key should first be released after selecting the worksheet tabs. Then, re-click and drag one of the highlighted tabs to move the group, or click and hold down the Ctrl key while dragging to copy the group. The description of how to move or copy worksheets using the mouse, is more accurately described in the Inside Out section on page 259.

Note from the Author or Editor:
It actually does work sometimes if you keep holding Ctrl, but only sometimes. So, let's make it more accurate and change the quoted errata reference to the following: "You select nonadjacent worksheets at the same time by pressing Ctrl while you click to select the sheet tabs. Then you can click any selected tab and drag to move the group, or click, press Ctrl and drag to create copies."

M.K.  Jun 17, 2012  Jun 29, 2012
Printed, PDF, Safari Books Online
Page 225
2nd Paragraph

Text reads: "Repeat is valid only if Undo was your last action." Redo (not Repeat) is valid only if Undo was your last action.

Note from the Author or Editor:
Yes, this is an error. Please change the quoted text reference to: "Redo is valid only if Undo was your last action."

M.K.  Jun 17, 2012  Jun 29, 2012
Printed, PDF, Safari Books Online
Page 454
2nd Paragraph (Note)

Text reads: "You can display all comments on the worksheet by clicking the Show All Comments button on the Page Layout tab on the ribbon." The Show All Comments button is found on the Review tab (not the Page Layout tab).

Note from the Author or Editor:
Yep. Please change quoted text to: "You can display all comments on the worksheet by clicking the Show All Comments button on the Review tab on the ribbon."

Anonymous  Jun 17, 2012  Jun 29, 2012
Printed
Page 518
Last Paragraph

Text reads: "You need to click the Change Source button to locate the Actual workbook...". Text should have read: "You need to click the Change Source button to locate the Budget workbook...".

Note from the Author or Editor:
Chapter 12, "Saving Linked Workbooks" fourth paragraph: Existing Text: "You need to click the Change Source button to locate the Actual workbook." Change to Read: "You need to click the Change Source button to locate the Budget workbook."

M.K.  Apr 03, 2013  Jul 19, 2013
Printed
Page 539
2nd Paragraph

Text states: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different ranges to sum, each with their own criteria". Actually, the function allows only ONE (1) range to sum. You may specify up to 127 conditional ranges, each with its own criteria, but only one range is summed.

Note from the Author or Editor:
Chapter 14, page 2, "The SUMIF, SUMIFS, and COUNTIF functions," second paragraph: Existing Text: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different ranges to sum, each with their own criteria." Change to Read: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different conditional ranges, each with their own criteria."

M.K.  Apr 03, 2013  Jul 19, 2013
Printed
Page 548
3rd Section - Practical Text Manipulation

In this section, the author points out that one might want to use the TRIM function on column A to be sure there are no extra spaces. With that in mind, it should also be pointed out that the result of the formula, =LEFT(A2,SEARCH(" ",A2)), will produce first names, each with one trailing blank space. If you care about the trailing space, you could embed the formula in the TRIM function (as an argument to the TRIM function), or more simply, edit the 2nd argument of the LEFT function to read "SEARCH(" ",A2) - 1" By the way, a very minor point just noticed: The column headings for Last Name and First Name are reversed.

Note from the Author or Editor:
The very minor point at the end is the errata in this message. I thought that this had already been corrected, but I didn't see it in the errata list. The graphic in the sidebar needs to be corrected. I can provide it, but not sure how in this system. The column headers should be, from left to right: Full Name, First Name, then Last Name. Only the headers change, not the contents of the columns.

M.K.  May 28, 2013  Jul 19, 2013
Printed
Page 553
2nd Paragraph from Bottom

Regarding the COUNTBLANK function: Text states: This function is tricky because formulas that evaluate to null text strings, such as....aren't counted". I believe the author meant to say "blank" text strings rather than null text strings.

Note from the Author or Editor:
Revisited 7/15/13: Change the second sentence under "The COUNTBLANK Function" to read: "This function is tricky because formulas that evaluate to blanks (=" ") or to zero are not counted, but formulas that evaluate to nulls (="") are counted."

M.K.  Apr 20, 2013  Jul 19, 2013
Printed
Page 554
3rd Section - An ISERR Example

Text States: "If the string isn't found, you want the cell to remain empty." However, if the formula, =IF(ISERR(FIND("12A", A1)), " ", "Yes") evaluates to false, the function will return a blank space, causing the cell to not be empty. If the intention is to have the cell remain empty, the 2nd argument to the IF function should be a null ("") string, rather than a space (" ").

Note from the Author or Editor:
Change the third sentence in the sidebar on page 554, "An ISERR Example," to read: "If the string isn't found, you want the cell to remain blank." Also, change the formula shown in the second paragraph of the sidebar (the only difference here is that there is no space between the second set of quotation marks) as follows: =IF(ISERR(FIND("12A", A1)), "", "Yes")

M.K.  Apr 20, 2013  Jul 19, 2013
Printed
Page 755
Figure 22-15

The criteria shown in Figure 22-15 will produce a list that includes lot sizes GREATER THAN 2 (acres) only. Lot sizes EQUAL TO 2 will NOT be included. This does not coincide with the text in the last paragraph on Page 753 which states that homes of AT LEAST 2 acres are desired.

Note from the Author or Editor:
On page 753, third sentence: change "at least 2 acres" to "more than 2 acres" On Page 755, the caption for figure 22-15: change "at least 2 acres" to "more than 2 acres"

M.K.  Jul 13, 2013  Jul 19, 2013
Printed
Page 766
2nd parapraph

Change "[#Age]" to "[Age]"

Note from the Author or Editor:
Thanks for the catch. Nice proofreading. O'Reilly: True. Please delete the "#" as described.

Brian Angus  Sep 09, 2010  Jul 22, 2011
Printed
Page 804
2nd paragraph

Not really a mistake--let's say "Oversight"--but it definitely is SERIOUS. All I wanted to do was subtract the data is Column B from the data in Column A. So simple--and I had your book to guide me. But still, I churned and churned for hours--getting nowhere. My problem was that--under "Pivot Table Tools/Options"--when I clicked on "Fields, Items, & Sets", the "Calculate Field" menu selection was greyed out. I tried everything imaginable to tweak the app into cooperating. But no luck! I have since found the problem and feel that this portion of the book--on "Using Calculated Fields and Items" needs to have a VERY bold note explaining that: "You cannot create a calculated field or a calculated item in a PivotTable based on OLAP source data." None of what you describe on pgs. 804-806 will work if the data source is an OLAP cube. Here is the reference to the relate KB article: http://support.microsoft.com/kb/234700

Note from the Author or Editor:
True. Thanks for the tip! O Reilly: His suggested note would work great ... if it's possible to add it without page break repercussions. Thanks, =Mark

Dr. Edward Hanna  Nov 15, 2010  Jun 29, 2012
Printed
Page 820
Last Paragraph

Text defines "fixed-width" text files as having space characters to achieve field alignment. Although this is correct, it does not address the way in which this type of file differs from delimited files with regards to field BOUNDRIES. With fixed-width text files, each field is allocated a "fixed" number of character positions per field. This is true regardless of whether the field is totally empty (filled with spaces) or totally filled with text.

Note from the Author or Editor:
On page 820, last paragraph, second sentence inside the parentheses: change to read: “In fixed-width files, fields are the same size in each record; space characters are added to fill blanks.”

M.K.  Jul 13, 2013  Jul 19, 2013
Printed
Page 840
2nd Paragraph

Text reads: "Creating Exact-Math Criteria". Should read: "Creating Exact-Match Criteria".

Note from the Author or Editor:
Second paragraph boldface "Creating Exact-Math Criteria" should read "Creating Exact-Match Criteria".

M.K.  Jul 13, 2013  Jul 19, 2013
PDF
Page 862
4th paragraph

The text in Excel 2010 Inside Out says ", Most of the buttons on the Drawing toolbar aren't available either". The above mentioned quote is true for Excel 2003, but since the current edition of this book is about Excel 2010, I would suggest something like ". The Drawing Tools tab is not available either". There is also a grammar error (I would recommend a period here, instead of the comma that the text uses).

Note from the Author or Editor:
>>Change two sentences of the sidebar: "What You Can and Can't Do With a Shared Workbook," to read: The Conditional Formatting, Scenarios, and Data Validation commands are not available for a workbook in shared mode (although you can still see their effects). Most of the tools on the Insert tab aren't available either. >> The first sentence above is unchanged except for a period at the end instead of a comma.<<

Anthony B Croucher  Dec 21, 2011  Jun 29, 2012