EXCEL Problem Objective: learn how to protect spreadsheets.

Required:

a. Read the article “Keeping Secrets: How to protect your computer from snoops and spies,” by Theo Callahan in the July 2007 issue of the Journal of Accountancy (available at the AICPA’s Web site: www.aicpa.org).

b. Create a new workbook that contains two individual worksheets. On the first worksheet, just enter your name, course number, date, and name of your instructor. On the second worksheet, create the refinancing worksheet as depicted in Exhibit 5 of the Journal of Accountancy article.

c. Implement the following controls on the spreadsheet that you created in step b:

a. Password to open

b. Password to modify

c. Apply passwords to each individual worksheet

d. Encrypt the data

e. Set the workbook to be Read-only f Protect the appropriate cells in the refinancing worksheet so that they cannot be altered.

d. Write a brief memo discussing your experience implementing these data pro¬ tection controls (how easy to create, how they worked when you attempted to reopen the workbook, what happens if you did not enter one of the passwords, etc.).

e. Turn in your report and an electronic copy of your workbook.