answersLogoWhite

0

They are completely different things. Auditing is for checking errors in cells and formulas. You can use it to do things like check what cells are being used by a formula or checking what formulas use a particular cell. Scenarios all you to keep various sets of values for particular cells and choose one set to put into the cells, and then swap them for another. It can be used to compare different scenarios and save those scenarios. You could use the same worksheet based on different currencies, and using different scenarios swap different currencies into the cells.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

Can you troubleshoot in excel?

Depends on what you mean by troubleshoot. Excel does have several auditing functions and error messages.


What is the difference between Excel sheet and spread sheet?

They are the same thing, excel is Microsoft's spreadsheet programme.


Where is the formula error button in Excel 2007?

There is no formula error button in Excel. However, there is an Error Checking button on the Formulas ribbon in the Formula Auditing section in Excel 2007.


What is the difference between the way Access saves a record and the way Excel saves a row in a work sheet?

the difference between the way Access saves a record and the way Excel saves a row in a worksheet. Answer


What is the difference between MS Excel to Paint?

MS Excel is a spreadsheet; MS Paint is a basic graphics editing program.


What is the difference between SQL2005 and Excel 2007?

SQL is Structured Query Language, and relates to databases. Excel is a spreadsheet application.


What tab in excel on the ribbon displays error checking tools?

It is in Formula Auditing on the Formulas tab.


What are the differences between trace precedents in Excel 2003 and Excel 2007?

It works basicly the same way in both versions, but the commands are in different locations. The command is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003. See related links for an animated tutor of how to use trace precedents.


What is the difference between excel and a word window?

Excel is a spreadsheet program that is marketed by Microsoft. Word is a word processing program that is marketed by the same company.


Is the difference between -20 and -10 equal to 10 or to -10 and why?

You can get the difference on your calculator, or in Excel. In Excel, the expression would be: = -10 - (-20) As to the "why", look at the numbers on a number line. That should help you visualize the situation.


What is the difference between saving an Excel file in xls or xlt?

The extension xls is a spreadsheet and xlt is a template. A template is a pre-designed layout for an Excel spreadsheet.


What is the difference between Excel 2003 menu and Excel 2007 menu?

Excel 2007 does not have menus, but has what are known as ribbons. The various options are grouped and displayed on different ribbons. Options that would have been in menus and toolbars are displayed on the ribbons.