• Apply Table in Excel
• Set one column as a result column state ‘Average’
• Click one of the result column, click Fx button
• In categories, select ‘Statistical’ >> Average >> OK
• In number1 box, select First number (MidExam) >> In number2 box, select Second number (FinalExam) >> OK
• Apply to the entire list of the table