We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
+ Link For Assignments, GDBs & Online Quizzes Solution
+ Link For Past Papers, Solved MCQs, Short Notes & More
Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion
How to Add New Discussion in Study Group ? Step By Step Guide Click Here.
Assignment # 3 Discussion Spring 2012
Solved, Solution Uploaded
Question No. 1 : [ 5 * 2 = 10 marks]
Suppose following is a work sheet of MS Excel.
Apply the appropriate formulas in MS Excel using the same data given in above diagram, to find the result (same as shown in the diagram) of the below mentioned requirements and just write down the formulas in the solution file ( MS word file).
Question No. 2 : [ 5 marks]
Find Result of Formulas in MS Excel
Sum of marks of all subjects =SUM(B6:B15)
Average of all marks =AVERAGE(B6:B15)
Highest marks attained =MAX(B6:B15)
Total number of subjects having Grade A =COUNTIF(C6:C15,"A")
Sum of Marks of those subjects having Grade B =SUMIF(C6:C15,"B",B6:B15)
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
your style of formula for those who are good in excel are already have some how know which is not easy to understand for beginner.
I think so for the rest I don't know their views.
Answer depends on which Rows and Columns Numbers you are using. According to assignment picture, your solution is wrong
Assignment Solved, Solution Uploaded
Note: below is according to my excel format so, please see you cell reference and do accordingly.