5
AssignmentMultiple Choice

Getting Started with Excel

Question 5 • {CR} Computer Applications II

Marcus wants to create a spreadsheet with names, street addresses, city, and state for a mailing list. All those on the list will have the same city and state. Which tool would be the best to use to quickly enter that information?

Answer
A
Flash Fill
B
AutoComplete
C
Autofill
D
Tell Me bar

Explanation

Autofill can quickly copy the same city and state into multiple spreadsheet rows, such as by dragging the fill handle down a column. Flash Fill recognizes patterns in data, while AutoComplete suggests entries as you type; neither is the best tool for repeating the same information across the mailing list.

AI-written and checked against the verified answer.

Previous
Next