Create a worksheet for university report

1. A university maintains a year wise result for three courses and then generates an average report as given below :

SR NO	YEAR	COURSE1	COURSE2	COURSE3	AVERAGE
1	2014	300	650	560
2	2015	450	500	400
3	2016	490	400	250
4	2017	600	650	350
5	2018	500	550	450
Course Wise Average

(a) Create the worksheet shown above.

(b) Save the file with name "Courses".

(c) Use the AutoFill to put the SR NO. into cells.

(d) Set the column widths as follows : Column A : 8, Column B : 14, Columns C & D : 15, Columns E & F : 14.

(e) Complete the report to calculate the course wise average in row 6.

(f) Provide formula to calculate year wise average in column F.

Output/ Explanation: