Question: When you create dropdown lists in Excel, you need to... Cell reference the list of choices that are typed on a spreadsheet Type the list
When you create dropdown lists in Excel, you need to... Cell reference the list of choices that are typed on a spreadsheet Type the list of choices directly into the dropdown list function Trick question as you cannot create dropdown lists in Excel Create a macro that will run a list of choices against those in a spreadsheet Question 7 ( 1 point) Which is a reason people do NOT create dropdown lists in Excel? Dropdown lists are faster for data entry Dropdown lists reduce the amount of data inputting error by the user Dropdown lists can easily be manipulated by the data enterer Dropdown lists make sure that the user can only input what is part of the list
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
