I have no clue if Excel even has the ability to do this for me. If it can, then I need to know how to do it.
I want to create a worksheet/form on Excel where users can select options from dropdown menus instead of checking a box next to the option (which means I have to have all options listed out on the sheet).
From there, I want to know if I can code each option with a numerical score, so that when a number of options are selected, Excel computes the average of the assigned numerical scores.
Thanks!