Appendix B: What’s on the CD-ROM
935
The CD-ROM files will be copied to a subfolder in the folder you specified in Step 3. To designate this new
folder as a trusted location:- Start Excel and choose File ➪ Options to display the Excel Options dialog box.
- In the Excel Options dialog box, click the Trust Center tab.
- Click the Trust Center Settings button.
- In the Trust Center dialog box, click the Trusted Locations tab.
- Click the Add New Location button to display the Microsoft Office Trusted Location dialog
box. - In the Microsoft Office Trusted Location dialog box, click the Browse button and locate the
folder that contains the files you copied from the CD-ROM. - Make sure that you select the option labeled Subfolders Of This Location Are Also Trusted.
After performing these steps, when you open XLSM files from this location, the macros are enabled and you
don’t see the security warning.Following is a list of the sample files, along with a brief description.Note
Some chapters don’t use any sample files. nChapter 01
l table and chart.xlsx: An introductory hands-on example that creates a table and a chart.Chapter 02l (^) loan payment calculator.xlsx: A workbook that demonstrates the difference between
unformatted cells and formatted cells.
l (^) number formatting.xlsx: A workbook with some examples of number formatting.
Chapter 04
l budget.xlsx: A simple multisheet budget workbook to demonstrate formatting across
worksheets.
Chapter 05
l real estate table.xlsx: A workbook that contains a table of real estate listings for practice
working with tables.
Chapter 06
l background image.xlsx: A workbook that contains a background image for a worksheet.
l (^) loan payments.xlsx: A workbook that contains a range of data and formulas to demonstrate
the effect of applying simple formatting.
57_474877-bapp02.indd 93557_474877-bapp02.indd 935 3/29/10 11:47 PM3/29/10 11:47 PM