Liam often types the names of the 12 offices where his company does business.He wants to be able to enter the first office name, then drag the fill handle to enter the other office names.What should he create?
A) macro,
B) Flash Fill list
C) custom AutoFill list
D) Quick Table

Question

Quizplus · Accepted Answer

Liam should create a custom AutoFill list by entering the names of the 12 offices in a column and selecting them. Then he can go to the "File" tab, choose "Options," select "Advanced," and scroll down to "General." He can then click "Edit Custom Lists" and enter the range of cells with the office names. Once he has created the custom list, he can enter the first office name, then drag the fill handle to automatically enter the other office names.

Liam Often Types the Names of the 12 Offices Where