1. Is there a way to subtotal large volumes of numbers in Excel 2010, while ignoring the values contained in hidden rows? 2. What is the best way to subtotal data in Excel 2010 that contain ...

Here, we will create all multiple choice questions in sheet 1 and make an answer sheet in sheet 2. To automate the quiz, we will write formulae in sheet 2. Let’s see the process.