The previous data represents a table of marks for students in a training program in the field of Computer Skills. Create a workbook called CSMarks and enter the previous data in the same format and order, then fill in the empty fields according to the following instructions:

$($ sign$)$

$1-$ Name the workbook as CMarks and the worksheet as Marks Table

$2-$ Write the necessary formulas to fill in the rest of the cells according to the following: A$-$ The student ID cell, which is installed as follows: Student nickname, first letter of the student name$\_$student number$\_$CS

B Final grades cell: It is the average of the student$$s job grade and exam grade, rounded to the first digit after the comma. C Status cell: If the student$$s final grade is greater than or equal to $50,$ then the student is successful, but if it is less than $50,$ then he is failing.

Add the following formats to the table

Font type: Times New Roman

Alignment: center

Font colour: green

$($two signs$)$

$($sign$)$

$($sign$)$

$($two signs$)$

Font size: $12$

$(5$ Symptoms$)$

After completing the table, find the following requirements:

A$-$ For the final grades cell, write the necessary formulas to calculate

$-$ The total number of students

$2-$ The value of the highest score

$3-$ The value of the lowest mark

$-4$ Number of successful students

The number of students who failed

B For the status cell, write the formulas needed to calculate

$1-$ Success rate $($success rate $=$ number of successful students total number of students $*100\%)$

$2-$ Failing percentage Failing percentage $=$ Number of students who failed Total number of students $*100\%)$

C$-$ For the job and exam cell, write the necessary formulas to calculate

$1$ Number of students who succeed in the job and fail the exam

$2-$The number of students who passed the exam and failed in the job

$4-$ Create a pie chart for the status column $($Pass$,$ Fail$).$

Font type in the chart: Times New Roman, font size $12,$ font color: red

$($two signs$)$

$($two signs$)$

$(4)$ Symptoms$)$