Download the template file (q6.xls) and complete the mark sheet as indicated in figure 1 by setting up suitable formulae in Excel.

Figure 1