2
AssignmentMultiple Select

Getting Started with Excel

Question 2 • {CR} Computer Applications II

What are the purposes of Flash Fill? Click all that apply.Flash Fill recognizes patterns across rows for easy data entry.Flash Fill copies a pattern down a column of entries.Flash Fill is a storage location on your personal computer.Flash Fill can be used to create formulas using the Tell Me bar.Flash Fill can be used to combine entries or parts of entries.

Answer
A
Flash Fill recognizes patterns across rows for easy data entry.
B
Flash Fill copies a pattern down a column of entries.
C
Flash Fill is a storage location on your personal computer.
D
Flash Fill can be used to create formulas using the Tell Me bar.
E
Flash Fill can be used to combine entries or parts of entries.

Explanation

Flash Fill detects a pattern in examples you enter and uses it to complete similar data, such as filling a pattern down a column or recognizing related entries across rows. It can also combine or extract parts of entries, such as joining first and last names. It is not a computer storage location, and it does not create formulas using the Tell Me bar.

AI-written and checked against the verified answer.

Previous
Next