p.47 In step 5, "Create an array formula" should read
"Create a formula"
p.62 In step 8, "The blinking vertical line (I)" should read
"The blinking vertical line (|)"
p.81 In Step 2, "if you change you change your mind" should read
"if you change your mind"
p.82 In Step 3, "The next few stops" should read
"The next few steps"
p.108 In Figure 3-1, the "Increase Indent" points to the "Decrease Indent" button
the "Decrease Indent" points to the "Increase Indent" button
P.108 In Step 4, "instead of the previous 12 point type" should read
"instead of the previous 10 point type"
p. 161 Under the illustration, "Format -> Selected Data Series" should read
"Format -> Selected Chart Area..."
p. 175 In Step 1, "Select Format -> Selected Object From The Menu" should read
"Select Format -> Selected Data Series... From The Menu"
p. 175 In Step 2, "Select Format -> Selected Object From The Menu" Should read
"Select Format -> selected Axis... From The Menu"
p. 208 In Step 2, "You need to need to add column headings" should read
"You need to add column headings"
p. 212 In Step 11, "then save it" should read
"Click the Close button to close the preview, then save it"
p. 236 In Step 5, "The selected cell reference, Monday!$A$4:$I$60" should read
"The selected cell reference, Tuesday!$A$4:$I$60"
p. 241 In Question 14, the answer "click the Paper Size tab" should read
"click the Paper tab"
p. 242 In Answer 7, the answer should also list 'D.' as a valid answer because
Excel does NOT normally print row and column labels on every
page unless it is specifically configured by the user to do
so.
p. 243 In Answer 14, the answer "click the Paper Size tab" should read
"click the Paper tab"
p. 248 In Table 6-1, The % operator description "Percent" should read "Modulus"
p. 254 In Quick Reference, To Delete Names,"Insert -> Name -> Create" should read
"Insert -> Name -> Define"
p. 261 In Quick Reference, "To Use The If Function In A Formula" should read
"To Use The PMT Function In A Formula"
p. 265 In Step 6, "Click Cell C5" should read
"Double-Click Cell C5"
p. 266 "Select Tools -> Auditing -> Show Auditing Toolbar"should read
"Select Tools -> Formula Auditing -> Show Auditing Toolbar"
p. 268 In The Table, RANDBETWEEN is NOT a function in Excel 2003.
p. 271 In The Table, "=WEEKDATE (" under Syntax column should read
"=WEEKDAY"
p. 275 "To Delete Names: Select Insert -> Name -> Create" should read
"To Delete Names: Select Insert -> Name -> Define"
P. 275 "selecting Tools -> Auditing -> Show Auditing Toolbar" should read
"selecting Tools -> Formula Auditing -> Show Auditing Toolbar"
p. 307 "C. Select Data -> Filter from the menu" should read
"C. Select Data -> Filter -> Advanced Filter from the menu"
p. 310 In Step 1, "create a macro that inserts the current data" should read
"create a macro that inserts the current date"
p. 326 In Step 6, Add the following instructions: Delete the line:
EmployeeNo = InputBox("Enter the Employee Number.")
Located after the "End If" statement and before the
follwing line:
Worksheets("Sheet1").PageSetup.CenterFooter = "Expense Report
for: " & EmployeeName
p. 329 In Answer A. "select the macro." should read
"select the macro, then click the Run button"
p. 344 In Step 7,Add "Then click the File name textbox and type Europe Expenses."
p. 356 "who have Microsoft's Internet Explorer 4.01" should read
"who have Microsoft? Internet Explorer 5.01 Service Pack 2 (SP2) or later
and the Microsoft Office 2003 Web Components."
p. 360 "uses Microsoft Internet Explorer 5.01 or later" should read
"uses Microsoft? Internet Explorer 5.01 Service Pack 2 (SP2) or later and
the Microsoft Office 2003 Web Components.
p. 361 In Step 10, "AS:F7" should read
"A5:F7"
p. 365 In Step 1, Add "Right-click the toolbar and select External Data to
display the External Data toolbar" before the instruction
to click the Data Range Properties button.
p. 400 "Paste Function Button" should read
"Insert Function Button"
p. 421 In Number 5, "and clicking View." should read
"and clicking Show."
p. 440 Add to NOTE in Step 5, "If you are using a later version of Windows such
as Windows Visa, click the Start button, type
Budget in the text box and press Enter. Double-
click the BUdget Proposal file in the Search
Results list to open the workbook."
p. 451 Answer Explanation "Select File -> Save As from the menu and click the
Options button to password protect
a workbook" should read
"Select Tools -> Options -> Security tab"