Asked by Tommy Clobes on Jul 24, 2024

verifed

Verified

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

Flash Fill

A feature in spreadsheet software that automatically fills in values based on a pattern recognized from neighboring data.

AutoFill List

A feature in spreadsheet and form software that automatically completes a field based on previously entered data.

Fill Handle

A feature in spreadsheet software that allows users to quickly copy and paste content or to autofill data in adjacent cells by dragging the handle.

  • Master the technique of macro recording and operation to facilitate task automation.
verifed

Verified Answer

KT
Kushal TavvaJul 26, 2024
Final Answer :
C
Explanation :
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.