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

Answer: C

Computer Science & Information Technology

You might also like to view...

Which of the following tags should NOT be located in the head section?

a. ``` ``` b. ``` <h1> ``` c. ``` <meta> ``` d. All the tags listed above should be coded in the head section. </p> </div> <div class="d-flex justify-content-between align-items-center"> <div class="btn-group"> <a href="https://sciemce.com/qa/WFxoOR42Plwe" class="btn btn-sm btn-dark px-3">View</a> </div> <span class="badge bg-secondary">Computer Science & Information Technology</span> </div> </div> </div> </div> <div class="col"> <div class="card shadow-sm"> <div class="card-body"> <div class="card-area-ad"> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-5615111067852633" crossorigin="anonymous"></script>  <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-5615111067852633" data-ad-slot="7303124573" data-ad-format="auto" data-full-width-responsive="true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> </div> </div> </div> <div class="col"> <div class="card shadow-sm"> <div class="card-body"> <div class="card-area mb-2"> <p class="card-text">Two methods that are expected to be in all Java classes are:</p> <p class="card-text">(a) getName and setName (b) toString and equals (c) compareTo and charAt (d) toLowerCase and toUpperCase</p> </div> <div class="d-flex justify-content-between align-items-center"> <div class="btn-group"> <a href="https://sciemce.com/qa/gDqefzn0YF5i" class="btn btn-sm btn-dark px-3">View</a> </div> <span class="badge bg-secondary">Computer Science & Information Technology</span> </div> </div> </div> </div> <div class="col"> <div class="card shadow-sm"> <div class="card-body"> <div class="card-area-ad"> <script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-5615111067852633" crossorigin="anonymous"></script>  <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-5615111067852633" data-ad-slot="7303124573" data-ad-format="auto" data-full-width-responsive="true"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> </div> </div> </div> </div> <div class="col"> <div class="card shadow-sm"> <div class="card-body"> <div class="card-area mb-2"> <p class="card-text">A grouped object can be exported and saved in a different file format</p> <p class="card-text">Indicate whether the statement is true or false</p> </div> <div class="d-flex justify-content-between align-items-center"> <div class="btn-group"> <a href="https://sciemce.com/qa/ncC99mnYBhhp" class="btn btn-sm btn-dark px-3">View</a> </div> <span class="badge bg-secondary">Computer Science & Information Technology</span> </div> </div> </div> </div> <div class="col"> <div class="card shadow-sm"> <div class="card-body"> <div class="card-area mb-2"> <p class="card-text">A(n) ________ command has two settings: on and off</p> <p class="card-text">Fill in the blank(s) with correct word</p> </div> <div class="d-flex justify-content-between align-items-center"> <div class="btn-group"> <a href="https://sciemce.com/qa/ZTOMsFZeKhhQ" class="btn btn-sm btn-dark px-3">View</a> </div> <span class="badge bg-secondary">Computer Science & Information Technology</span> </div> </div> </div> </div> </div> </div> </div> </main> <footer class="text-body-secondary py-4"> <div class="container"> <div class="row"> <div class="col-md-6"> <p class="mb-1 text-center">Sciemce: Your Gateway to Quick, Reliable Answers.</p> </div> <div class="col-md-6"> <p class="mb-1 text-center"> <a href="https://sciemce.com/honor/" class="text-decoration-none">Honor Code</a> | <a href="https://sciemce.com/privacy/" class="text-decoration-none">Privacy Policy</a> </p> </div> </div> </div> </footer> <script src="https://sciemce.com/assets/js/bootstrap.bundle.min.js"></script> </body> </html>