Instruction: Read ALL of the information carefully before you begin answering. Use the Excel built-in function recommended in completing all tasks. If you are unable to complete the task using the function, you may use an alternative method but this will result in the loss of some of the marks for the part. All your answers must be shown in the spreadsheet. The spreadsheet should be constructed using the Excel built-in functions such that, should any of the values in these cells be changed, then all calculations will update automatically. In awarding marks consideration will be given to the efficiency of any formulae constructed. You MUST save your work in the same file at least once every five minutes. All your answer must be presented within the colored space. You are required to download the excel file and follow the following steps before submission: 1 Save your file according to your name followed by assessment. (ie. Ahamd bin Rosli_Practical Test) 2 Upload you answers (Excel file) in the Moodle only.QUESTION 1 (25 marks) (a) (i) Complete the table below using "countif" functions Age Group Frequency Young 32 Middle 35 Old 33 (3 marks) (ii) Plot a Pie Chart using part (a) (i) table Frequency 33% 32% 35% Young . Middle . Old (2 marks)