I first created a spreadsheet with answers to a series of questions. Let's
say there are 10 questions and I want a final column to tabulate how many
questions are answered correctly. The questions could be done with
true/false or multiple
choice, whichever is easiest. What formula(s) should I use to do this? I
am thinking that the final column would display a number that is the sum of
the total number of right answers.