Question

A spreadsheet is created with drop down items that a user can select from. This is an example of which function?

Answer 1

Answer:

A drop-down list is an excellent way to give the user an option to select from a pre-defined list. ... Using OFFSET function to create the Excel drop down list ... In the above example, when the items listed in 'Drop Down 2' are dependent on the ... If using either VBA User Form or a spreadsheet template to display records they ...

Explanation: