Suppose formulas have been entered in the cells just above the component score heading row that reproduce the course weightings on the parametersE sheet. Performing the operations listed below will give course averages for students that: 1. Develop formulas that combine each exam's parts into a score out of 100 and adds the adjustment points 2. Create a formula that averages the rst student's scores by referencing absolutely the weights above the columns 3. Copy the formulas for the rst student into the rows for other students lQuestion options: Show error conditions for the averages re higher than the correct averages re equal to the correct avemges Are lower than the correct averages