?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...
On a traditional IBM mainframe, a channel program consists of one or more __________.
a. channel status words b. channel command words c. primitives d. channel address words
Computer Science & Information Technology
The Database ________ tool creates a detailed report for each selected object
Fill in the blank(s) with correct word
Computer Science & Information Technology
Because Word's mail merge feature does not allow spaces in the field names, any spaces in the field names from an Access database are replaced with:
A) underscores. B) dashes. C) plus signs. D) slashes.
Computer Science & Information Technology
Hyperlinks are commonly added to e-mail addresses
Indicate whether the statement is true or false
Computer Science & Information Technology