Ace the Broward College Computer Literacy Challenge 2026 – Level Up Your Tech Skills!

Pattern-based data entry is what Flash Fill is designed for. It watches the data you already have and detects the pattern, then fills in the rest of the column to match that pattern automatically. For example, if you have a list of full names and you want just the last names, Flash Fill can infer the pattern and extract them in the remaining rows. Or if you have dates in one format and want them in another, Flash Fill can apply that pattern consistently. Live Preview shows how a formatting change would look before applying; Theme changes the document’s color scheme and style; a Range reference is simply a cell or block of cells identified for formulas or navigation. So the feature that enters text based on patterns it finds in the data is Flash Fill.