Assignment 10 Mathematics and Logical Function Marksheet Assignment

 

Assignment 10

Mathematics and Logical Function

Marksheet Assignment

Function use

SUM :- Sum function is built in function which add all the number in the range of cell and return the result of the addition.

IF :- The IF function can perform a logical test and return one value for a "TRUE" result and another for a "FALSE" result.

VLOOKUP :- The excel VLOOKUP function is used for when you need to find things in a table or a range by row.

RANK :- This function returns the rank of a number in a list of number

Function use in that for Practical

=SUM(E4:H4)*25%

Sum :- sum function add to the value

Function For total

=SUM(I4,D4)*50%

Sum function add the tow or more value.

I4 :- it is cell reference value number 1

D4 :- It is cell reference value number 2

Function For Result

=IF(J4<=40,"Fail","Pass")

IF :- IF check the entire function but basically use of test to logical task and it return true or false value that we specified.

<=40 :- Check the value is less then 40 in a range if the cell value less than 40 than it will be print "Fail" otherwise "Pass".

Function For Percentage

=J4*200/200

Percentage same as total because it has only two subject at the end we will take only those.

Function For Grade

=IF(L4<=40,"Fail",VLOOKUP(L4,$l$19:$M$23,2,1)

VLOOKUP :- Find thing in a table or a range by row.

Function For Position

=IF(RANK(L4,$L4:$L$13,0)<=5,RANK(L$,$L4:$L$13,0),"")

RANK :- Rank function return a rank number in a row

Note :-

Calculate practical and total which can't have more than.

Result Criteria :- If total marks is greater than or equal to 40 then.

Grade :- Must be come in grade table which will based of the .

Position :- Simply find out the position of top 5 student others.