Google Answers: How do i do a formula audit on excel using a macintosh computer.

View Question

Q: How do i do a formula audit on excel using a macintosh computer. ( No Answer, 2 Comments )

Question

Subject: How do i do a formula audit on excel using a macintosh computer.
Category: Computers > Operating Systems
Asked by: gard0196-ga
List Price: $8.00

Posted: 14 Apr 2005 21:13 PDT
Expires: 14 May 2005 21:13 PDT
Question ID: 509492

I need to do a formula audit on an assignment for my FMIS class. It
requires me to not only do a spreadsheet but also do a formula audit
that shows the formulas ON the spreadsheet. Using a PC it is
relatively easy but I am using a Mac. If I go to tools and choose
auditing it offers me just the ability to trace the spreadsheet using
a blue arrow. That is not what I want. I want the actual formulas to
prove to my professor I just didn?t type in numbers.

Clarification of Question by gard0196-ga on 15 Apr 2005 06:16 PDT

ok, when I go to excel preferences I do not see a windows options section.
I do see a view,save, calculation, edit, general, transition, custom
lists, chart. color.

Answer

There is no answer at this time.

Comments

Subject: Re: How do i do a formula audit on excel using a macintosh computer.
From: xarqi-ga on 14 Apr 2005 22:41 PDT

For V.x:
Under Excel/Preferences menu, in the "Window options" section, check
the "Formulas" box.

Subject: Re: How do i do a formula audit on excel using a macintosh computer.
From: xarqi-ga on 15 Apr 2005 21:16 PDT

Sorry, my error.

It is Excel/Preferences/View, then you should see the Window options section.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy