Errata

On the Practice Task where it reads "In the MyVersions document, change the title to Business Office Procedures.
Then save the document." it should read "In the MyVersions document, change the title to Business Office Procedures.
Wait at least 1 minute, then save the document."
If there's no activity (i.e. typing, any format change, etc.) the software will not make any auto save. Therefore, even if there has been more than 1 minute before the title is changed, there will be no auto saved copy of the original MyVersions file (with the title Office Procedures). Also, once the title is changed to Business Office Procedures, if the file is saved immediately (before 1 minute), no auto saved copy will be created.

Regards,

Note from the Author or Editor:
On page 29, in the Practice Tasks box, in the second bullet point, change "Then save the document." to "Wait one minute, and then save the document."

There is no Price category on the worksheet - I assume this should be the Sales category instead.

Note from the Author or Editor:
Location:
Page 295
Practice Tasks

In 1st bullet, change:
by Category.

To:
by Category only.

In 2nd bullet, change:
by Category and then Price.

To:
by Category and then by Sales.

I was not able to locate any "Powdered" styles.

Note from the Author or Editor:
On page 270, in the Practice Tasks section, in the second list item, change "Powdered" to "Powder".

I was unable to locate any "stylized budget clip art."

Note from the Author or Editor:
Page 270
Practice Tasks
1st bullet

Change:
On the Budget worksheet...insert a stylize budget clip art image...

To:
On the My Monthly Budget worksheet...insert a clip art image that has a budget-related keyword...

If I specify the worksheet scaling to fit on 1 page wide by 2 pages tall the entire worksheet prints on one page only. If I specify 2 pages wide by 1 page tall it prints vertically on 2 pages. Is the correct solution to first create a manual page break between the January and February data and then specify printing each month on a separate page?

Note from the Author or Editor:
Page 222
Practice Tasks (at top of page)
1st bullet

Change:
...contents will print horizontally on two pages of letter-size paper.

To:
...contents will print in a landscape orientation on two pieces of letter-size paper.

There are no row titles in the HeightWidth workbook.

Note from the Author or Editor:
Location:
Page 218
Practice Tasks (at very top of page)
Bulleted item

Change:
row and column titles

To:
row and column headings

There is no hyperlink in cell A12 (or in B13 or C13.)

Note from the Author or Editor:
I have emailed a replacement for this practice file (Excel\Chapter03\Hyperlink.xlsx) to Adam Zaremba and Nellie McKesson.

"Move the Cost Per Ad data to the left of the Total Cost cells." - it is already to the left.

Note from the Author or Editor:
Location (1):
Page 192
Practice Tasks
2nd bullet

Change:
on the Ad Buy Constraints worksheet.

To:
on the Ad Buy Constraints worksheet into the new worksheet.

Location (2):
Page 192
Practice Tasks
3rd bullet

Change:
Move the Cost Per Ad data to the left of the Total Cost cells.

To:
Move the Cost Per Ad data so that it is immediately to the left of the Total Cost cells.

I am confused by this and by the following tip in the box. I tried using the help function but....no help.

Note from the Author or Editor:
On page 184, in the procedure "To display properties in a browsing dialog box," change step 2 to "Right-click any column heading, and then click the property you want to display."

The instructions in step 3 are to double-click the command. When I do this nothing happens - the command is not added to the custom group. It is added, however, when I click the command to select it and then click the ADD button.

Note from the Author or Editor:
On page 179, in the procedure "To add a command to a custom group," change step 3 to "In the <bold>Choose commands</bold> pane, click the command. Then click the <bold>Add</bold> button.