Plan , Design and create a new workbook to reflect the batting average of a cricket learn ove designated period in a series of 5 matches 2 . Names of batsmen should be listed down in Column A 3 . Matches 1 , 2 3 4 and 5 headings should be in columns B , C , D E and F respectively . Input run score for each player of each match Calculate the average , minimum and maximum runs for each match and each playe 5 . Use AutoFill wherever necessary 6 . Add a footer with your name , date and filename Create a column chart on a new sheet showing the averages minimums and maximums for each playe 8 . Save the workbook as Project 9 . Print the chart and spreadsheet Print a copy of the spreadsheet in formula view through the 10 . Submit all three printouts and the project file to your trainer / assessor ( through the Moodle )