marcus wants to create a spreadsheet with names, street addresses, city, and state for a mailing list. all…

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?\nflash fill\nautocomplete\nautofill\ntell me bar

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?\nflash fill\nautocomplete\nautofill\ntell me bar

Answer

Brief Explanations:

AutoFill in Excel is used to quickly copy the same data or a series of data to multiple cells. Since all on the list have the same city and state, AutoFill can be used to enter this repetitive information. Flash Fill is for recognizing patterns in data and filling in related data, AutoComplete is for suggesting text as you type based on existing entries in the column, and the Tell Me bar is for searching for Excel commands and features.

Answer:

C. Autofill