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

Question

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

Quizplus · Accepted Answer

Flash Fill in Excel automatically fills in data when it detects a pattern, making it the ideal choice for Frank to collate his data in the desired format.

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