Programming Examples
Create a worksheet university and perform the following operation
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 |
(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