Answered step by step
Verified Expert Solution
Question
1 Approved Answer
According to the following data; Name Surname 1. 2. 3. Avarage Situtation Ali ener 40 45 15 Semra stn 55 20 50 Yeim Salkm 75
According to the following data; | |||||||
Name | Surname | 1. | 2. | 3. | Avarage | Situtation | |
Ali | ener | 40 | 45 | 15 | |||
Semra | stn | 55 | 20 | 50 | |||
Yeim | Salkm | 75 | 70 | 65 | |||
Serap | Bulgurolu | 84 | 75 | 70 | |||
Ahmet | Gelge | 86 | 80 | 80 | |||
Mehmet | Karausta | 95 | 80 | ||||
lhan | Bayraktar | 32 | 30 | 45 | |||
Sema | Batrk | 100 | 35 | 15 | |||
Fikret | Sezgin | 20 | 45 | 15 | |||
a. What is the highest average | |||||||
b. What is the lowest average | |||||||
c.What is the highest grade | |||||||
d. What are the number of First takers | |||||||
e.What are the number of student Passes | |||||||
f. What are the number of student Unsuccess | |||||||
g. What are the number of students from the third exam "15" grade | |||||||
h. What are the number of students who cannot take the third one | |||||||
i. What is the second highest grade | |||||||
n.What is lowest third grade from the second one | |||||||
please create a table In according with above articles to calculate. | |||||||
In addition; | |||||||
*f grade average point is equal to 45 and more than 45, type "success" otherwise in type "Unsuccess", in the "situation" column | * If average point is more than 75, the average column text color is programed in blue color. | ||||||
Please solve in excel and show how to use formula
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started