Weighting questions - Calculator
This question isn't specific to any Articulate products, but I knew that this community is full of awesome heroes, so I figured I'd give it a shot.
Does anyone know of an Excel spreadsheet or other calculator that can help me weight questions?
Extremely simple example (for clarity): I am given a 100-question quiz, but 25 questions must be weighted to be worth 2 points. I need to know how to scale the score of the other 75 questions quickly and still equal 100.
Obviously, the example above would be easy to calculate, but what if I have an 87-question quiz, 14 questions need to be weighted at 2 points, 5 questions at 3 points, and the rest need to take up the slack... still equaling 100.
This seems like something that could be done in Excel, but I don't have the gray-matter to create such a formula.