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 columnA)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.

Question

Quizplus · Accepted Answer

Flash Fill in Excel generates content based on a pattern it recognizes from the user's input but does not automatically update if the source data changes.

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