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 fills eight columns and over a thousand rows of text in an Excel worksheet. He wants to collate the text in three of the columns in a single column. Frank enters the first two cells manually and then uses the Flash Fill function. Flash Fill suggests a pattern that is not the pattern Frank requires. To reject the suggested pattern, Frank should press the _____ key.
A)Alt
B)Ctrl
C)Esc
D)Shift

Question

Quizplus · Accepted Answer

To reject the suggested pattern by Flash Fill in Excel, pressing the Esc key will cancel the action.

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