A. The AICPA developed standards called ADS for the formatting of data files and fields typically needed to support an external audit in a given financial business process area. What does the acronym ADS stand for?

Multiple Choice

• Accounting Doctoral Scholars

• Accounting Data Standards

• Audit Data Standards

• Auditor Data Standards

B. To convert raw data to a table in Excel, you select any cell within the data and then do which of the following?

Multiple Choice

• Select Insert > Tables > Table

• Select Data > Outline > Group

• Select View > Get External Data > From Access

• Select Insert > Tables > Pivot Table

C. Which of the following best describes the appearance of the diagram view in Power Pivot?

Multiple Choice

• It lists the specific data to be summarized.

• It looks like the relationship screen in Microsoft Access.

• It looks like a pivot table.

• It looks like an EXCEL table.

D. After starting Tableau, which of the following is the first step in your data analysis?

Multiple Choice

• Connect to the data.

• Set relationships between worksheets.

• Drag Dimensions to Shelves.

• Create calculated fields.