?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
Answer: D
Computer Science & Information Technology
You might also like to view...
In the Excel IF function, >< is the proper way to indicate "Not equal to"?
Indicate whether the statement is true or false
Computer Science & Information Technology
A class that contains public methods that can change the data in the object of a class is called a/an:
a. mutable class b. immutable class c. invariant class d. none of the above
Computer Science & Information Technology