Page 372 - Computer Software Application TP - Volume 1
P. 372

COMPUTER SOFTWARE APPLICATION - CITS



           4  Review and Confirm:

              Excel will attempt to recognize the pattern and automatically fill the cells below with the expected results.










































           Related Exercises:
           1  Extract the first names from the list of full names using Flash Fill?

                                    Full Names                    First Names
                           John Doe
                           Jane Smith

                           Alice Johnson
                           Bob Brown




           2  Separate the email addresses into usernames and domains using Flash Fill.
                        Email Addresses                   Username                       Domain

                  john@example.com

                  jane@example.com
                  bob@example.com
                  alice@example.com

           Hint: Separate the first email address into the “Username” and “Domain” columns (e.g., “john” in the
           Username column and “example.com” in the Domain column.





                                                           357
 CITS : IT & ITES - Computer Software Application - Exercise 64  CITS : IT & ITES - Computer Software Application - Exercise 64
   367   368   369   370   371   372   373   374   375   376   377