Explain the difference between Auto Fill and Flash Fill.

What will be an ideal response?


Auto Fill is used to fill in names of months, weekdays, abbreviated months or weekdays, quarters, or a series of numbers. Flash Fill is used to set the pattern to extract data from a previous column and then fill in the rest of the column. For example, if column A contains first and last names, a person could type the first person’s first name in column B and then use Flash Fill to identify the pattern and fill the rest of the column with people’s first names based on the data in column A.

Computer Science & Information Technology

You might also like to view...

The command prevents programmers from accidentally altering the size and location of the Form’s controls.

a) Lock Controls b) Anchor Controls c) Lock d) Bind Controls

Computer Science & Information Technology

Match the following terms with their description

I. Cybercrime II. Phishing III. Pharming IV. Hacking V. Hacktivism A. Gaining unauthorized access to a computer system or network B. Generally used to make a political statement C. Criminal activity on the Internet D. Messages designed to trick you E. Redirects you to a phony website

Computer Science & Information Technology

The technology used for displaying images in stages is called ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

If you forget your ________, it is easy to retrieve it

Fill in the blank(s) with correct word

Computer Science & Information Technology