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

Figure 1