Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Cold Start Problem

Authors: Andrew Chen

1st Edition

0062969749, 978-0062969743

More Books

Students also viewed these Finance questions

Question

What is the relationship between humans?

Answered: 1 week ago

Question

What is the orientation toward time?

Answered: 1 week ago