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.
Frank has a set of data in four columns B, C, D, and E, which he wants to collate in a single column A. He uses Flash Fill to collate the data. However, after filling the column using Flash Fill, Frank changes the data in cell C5. Which of the following is the most likely result of this change?
A. ?Cell A5 automatically updates with the changed data.
B. ?Content generated by Flash Fill remains unchanged.
C. ?The text in cell A5 disappears.
D. ?The text in A4 copies to A5.
Answer: B
Computer Science & Information Technology
You might also like to view...
To indicate the end of a conditional comment, you would use ____.
A. B. C. D.
Computer Science & Information Technology
____________ enables you to define how built-in operators work with objects of your own types.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
Data processed by computer scripts can come from many different sources, including ____.
A. Databases B. Files C. User Input D. All of the above
Computer Science & Information Technology
Using Linux to wipe the target drive, the command-line command would be ___
a. cc b. dd c. nd d. md5sum
Computer Science & Information Technology