Case 15-1 Frank, a Business Analyst at Pro-White Technologies, Deals

question 5

Multiple Choice

Case 15-1 Frank, a business analyst at Pro-White Technologies, deals with vast amount of data and analysis. Since Frank uses Excel worksheets for most of his work, he uses several advanced functions of Excel that eases and speeds up his work.
Using an Excel worksheet, Frank creates a list of the cities where his company's business could possibly thrive. He also includes the names of the states the cities belong to and the average revenue of the residents in the sheet. Frank wants to collate the whole data in a single column (for example, Boston, Massachusetts - $75667) . In this scenario, Frank should use _____ as the data he needs to collate follows a pattern. ​

• A)Data Validation
• B)Text to Columns
• C)Group Fill
• D)Flash Fill

---

Definitions:

Delivery Costs

Expenses associated with the distribution or transport of goods from the manufacturer or warehouse to the end customer.

Installation Costs

The expenses incurred to put an asset into operation and prepare it for use, including costs of setting up, assembling, and installing.

Testing

The process of evaluating the functionality, performance, or quality of a product, system, or procedure, often prior to general release or implementation.

Revaluation Measurement Model

An accounting approach where fixed assets are periodically adjusted to reflect their current market values rather than their historical cost.