CS 101 ASSINGMRNT NO 3
QUESTIONNO 01
ANS :
SOLUTION
Sum of Marks Of All Subject :
=SUM(B6:B15)
Average Of All Marks :
=AVERAGE(B6:B15)
Higest Marks Attained :
=MAX(B6:B15)
Total Number Of Subject having Grade A :
=COUNTIF(C6:C15,”a”)
SumOf Marks Of Those Subjest having Grade B:
=SUMIF(C6:C15,”b”,B6:B15)
QUESTION NO 02
ANS:
SOLUTION:
<html>
<head>
<title> FOR LOOP </title>
</head>
<body>
<script>
for (i=1;i<=99;i=i+2){
document.write(i+"<br>");
}
</script>
</body>
</html>
No comments:
Post a Comment