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

question 27

Multiple Choice

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

---

Definitions:

Show Feelings

The act of expressing or demonstrating one's emotions or sentiments, typically through words, facial expressions, or gestures.

Self-Concept

The understanding a person has about who they are, shaped by their experiences, thoughts, and social interactions.

Evaluative Representations

The mental assessments or judgments made about objects, individuals, or concepts based on criteria, leading to various attitudes or opinions.

Pride

A sense of profound contentment that comes from personal accomplishments, the successes of close associates, or from having attributes or belongings that are broadly esteemed.