When Choosing Between Access and Excel, It Is Best to Use

question 69

Multiple Choice

When choosing between Access and Excel, it is best to use Excel in all of the following circumstances EXCEPT:

• A) you only need a single worksheet to manage data.
• B) you need to manage primarily of numeric data.
• C) you need to run a series of "what if" scenarios .
• D) you need to group, sort, and total data based on various parameters.

---

Definitions:

Trend Analysis

The practice of collecting information and attempting to spot a pattern, often used in financial markets or statistical data analysis.

Horizontal Analysis

An analytical method in financial statements analysis where amounts in a series of financial statements are compared line by line to detect changes and trends over different periods.

Vertical Analyses

An accounting method where each entry in a financial statement is listed as a percentage of another item to analyze relative size and composition.

Horizontal Analyses

Analysis technique for financial statements that evaluates changes in financial information over multiple reporting periods using percentage or absolute comparisons to find growth or decline trends.