Instruction: Explain the steps to create an MCDA tool in Excel to evaluate and rank multiple product features based on various weighted criteria.
Context: This question evaluates the candidate's ability to use advanced Excel functionalities to build decision-making tools. The candidate should demonstrate knowledge of using formulas for weighted scoring, data validation for input control, and conditional formatting to visually differentiate between high and low scores. Additionally, they should be able to incorporate dropdown lists for criteria selection and scoring sliders.