Forum Discussion
Total score
Hello everyone, Probable a very ease question, but i don't know how to do it. I tried to look it up but i wasn't sure how to find the right way. So what i want to do is this: - i have...
As even a further refinement--isn't it wonderful how many ways Excel can do these things?--I took Riny_van_Eekelen's variant and turned the basic matrix of questions and scores into an Excel Table, made the total of the "Possible Points" a calculation, and thus enabled you to have a flexible scoring sheet.
Which is to say, you can now add questions into the middle of the mix, with whatever weight you want--there's no compelling reason why the max score needs to be 100, since you're turning it into a percentage anyway.
This is why Excel is exceptional. So many ways to be creative!