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