Cambridge AssessmentInternational EducationINFORMATION AND COMMUNICATION TECHNOLOGY0417/31Paper 3 Spreadsheets and Website AuthoringFebruary/March 20232 hours 15 minutesYou will need:Candidate source files(listed on page 2)INSTRUCTIONSCarry out all instructions in each step.Enter your name,centre number and candidate number on every printout before it is sent to the printer.Printouts with handwritten candidate details will not be marked.At the end of the examination,put all your printouts into the Assessment Record Folder.If you have produced rough copies of printouts.put a cross through each one to indicate that it is not thecopy to be marked.You must not have access to either the intemet or any email system during this examination.INFORMATIONThe total mark for this paper is 70.The number of marks for each question or part question is shown in brackets []This document has 8 pages.DC(CJ)3275706R●UCLES2023[Turn over2You have been supplied with the following source files:m23bat.jpgm23batting.csvm23logo.jpgm23tcc.htmm23text.txtTask 1-Evidence DocumentCreate a new word-processed document.Make sure your name,centre number and candidate number will appear on every page of thisdocument.Save this document in your work area as m23evidence_followed by your centre number_candidatenumber,for example,m23evidence_ZZ999_9999You will use this as your Evidence Document during the examination.Task 2-SpreadsheetThe Tawara Cricket Club records on a spreadsheet the number of runs scored by each player in eachmatch that they played.1Open and examine the file m23batting.csv in your spreadsheet software.Delete row 2.Insert a new row at the top of the spreadsheet.Merge cells A1 to V1.Place the text Tawara Cricket Club in this merged cell.Merge cells A2 to V2.Place in the footer,right aligned,the text Spreadsheet edited by followed by a space,your name,centre number and candidate number.Save this as a spreadsheet with the file name m23cricket_centre number_candidate number,forexample,m23cricket_ZZ999_9999[50417131/FMW232 Format the spreadsheet to look like this.Tawara Cricket ClubFormat row 1 to have 36 point sans-serif white text on a dark-grey background.Format row 2 to have 18 point sans-serif black text on a light-grey background.3 Place in cell U4 a function to count the number of matches played by this player.Replicate thisformula for each player.4 Place in cells B33 and B34 functions to display the highest and lowest scores for this matchReplicate this for all other matches.5 Place a replicable formula in cell V4 to calculate the average score for this player,rounded to1 decimal place.Total runs scoredAverage scoreNumber of matches played-Not outEdit this formula to make sure that cell contents are not displayed if this player has played fewerthan 5 matches.Replicate this formula for all playersUCLES 2023041731/F/M23[Turn over